Google Sheets to Airtable Sync via Apps Script (REST API)
Google Apps Script Developer / API Integration Engineer
- Eliminated repetitive manual steps across the workflow
- Faster response time and fewer missed handoffs
- Error handling and edge-case coverage to reduce operational risk
What I built
Built a custom Google Apps Script integration that keeps a Google Sheet and Airtable base in perfect sync. On every lead added or updated, an installable trigger fires a script that reads the row, formats fields and dates with Utilities.formatDate, and pushes the record to Airtable through its REST API using UrlFetchApp with Bearer-token authentication. The script parses JSON responses, maps each column to the correct Airtable field and creates or updates records idempotently. The execution log shows dozens of completed runs - replacing manual copy-paste with real-time, code-driven data sync.