I’m trying to set up an automated workflow where deleting a row in my Airtable base will also remove the corresponding entry from my PostgreSQL database. I’ve been using Zapier to connect these two services, but I’m running into an issue. When I look at the available triggers for Airtable in Zapier, I can only find options for when new records are added or when existing records get modified. I don’t see any trigger specifically for record deletions. Has anyone figured out a workaround for this? Maybe there’s a different approach or a trigger I’m missing that would let me sync deletions between Airtable and Postgres through Zapier.
Indeed, the absence of deletion triggers for Airtable in Zapier can be inconvenient. One approach I’ve taken is to include a timestamp field that updates whenever a record is altered. I set a Zap to run hourly, which compares records in Airtable with those in PostgreSQL. If a record exists in PostgreSQL but not in Airtable, I then mark it for deletion. Although this method isn’t immediate, it effectively meets my requirements. Alternatively, consider using Airtable’s API with Integromat for more precise deletion management.
Had this exact problem six months ago migrating our inventory system. Airtable’s deletion triggers are a pain - everyone knows it. Here’s what worked for me: skip Zapier’s native triggers and run a daily cleanup script instead. The script checks both databases and finds orphaned PostgreSQL records where the Airtable record’s gone. Way more reliable than trying to sync everything in real-time. I added a last_synced timestamp to the Postgres table to catch stale records that need purging. It’s not instant, but it handles weird edge cases better than webhooks and you don’t need complicated Airtable automations. Still running smooth with thousands of records.
Yeah, Zapier’s missing delete trigger for Airtable is super annoying. Hit this same issue at work.
Webhooks solved it for me. Set up an Airtable automation that fires a webhook to Zapier when records get deleted. Build this in Airtable’s automation section - way more flexible than Zapier’s triggers.
Webhook sends the record ID to Zapier, then Zapier queries and deletes the matching Postgres row. Takes about 10 minutes once you know what you’re doing.
This video covers migrating automations and compares platforms if you’re thinking beyond Zapier:
I ditched Zapier for some workflows because of stuff like this. But the webhook approach works great if you’re staying put.
i totally get it, jess! the lack of a delete trigger in airtable can be frustrating. what i do is create a “status” field to flag records instead of deleting them. when it’s marked as “deleted”, zapier can update your postgres. it’s a good workaround!
Yeah, Zapier’s Airtable deletion issues are super frustrating. I switched to Make.com (used to be Integromat) - their delete triggers actually work instantly. Moved everything over and it’s been rock solid compared to all those hacky workarounds.