Automation

Google Sheets to Airtable Sync via Apps Script (REST API)

Google Apps Script Developer / API Integration Engineer

Business summary
Operations automation • Remove manual work and increase operational reliability
  • 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.

Tech stack

Google Apps ScriptJavaScriptAirtable APIREST API IntegrationGoogle SheetsREST APIUrlFetchAppJSONWebhooksTriggersData SyncCustom Scripting