This project called for a data quality workflow around Airtable records, using a FastAPI backend, an AWS Lambda, and a Zapier automation.
- The Airtable Base stores source rows, validation rules, issues, and scan logs.
- The Dockerized FastAPI backend — running on AWS App Runner — executes scans, applies validation, and tracks issues.
- The Lambda isolates Airtable authentication, field mapping, and writes from the backend.
- The automation accepts Google Form requests, calls the API, and sends completion emails.
This tool helps teams validate Airtable-based operational data.
Built with
- Airtable
- Zapier
- PostgreSQL
- Python