I’m trying to set up an automated workflow that removes records from my PostgreSQL database whenever I delete them from Airtable. I’ve been exploring Zapier for this task, but it seems like the available triggers only cover new record creation and existing record updates. I can’t find any option that detects when records get deleted from Airtable.
Has anyone managed to create this type of deletion sync between these platforms? I need the PostgreSQL entries to be automatically removed when their corresponding Airtable records are deleted. Any workarounds or alternative approaches would be helpful since this seems like a common requirement for keeping databases in sync.
totally get it, creativeartist88! I faced this too. I now use a webhook approach like you mentioned, but also integrated a small cron job that auto-checks for deletions every few hours. a bit of a hassle but worth it for the sync!
I ran into this same problem and found a workaround that’s been solid. I wrote a Python script that runs daily via cron to compare record IDs between Airtable and PostgreSQL. It grabs all active IDs from Airtable’s API, then nukes any PostgreSQL entries that don’t exist anymore in the source table. Sure, it’s not real-time like Zapier, but it handles deletion sync without messing with your workflow or adding soft deletes. The delay hasn’t hurt me since deleted records don’t usually need instant removal anyway.
Yeah, Zapier doesn’t support deletion triggers from Airtable - it’s super annoying for keeping data in sync. I hit this same problem last year building something similar. Here’s what worked: skip hard deletes and use soft deletes instead. Add a status field in Airtable that marks records as ‘deleted’ rather than actually deleting them. Zapier picks up the status change as an update trigger, then runs your DELETE query in PostgreSQL. You’ll need to tweak your workflow a bit, but it keeps everything automated without messing with webhooks or scheduled jobs.
This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.