Zapier trigger for updated record or all records


#24

So I got curious and based on others approaches was able to pretty easily implement this in zapier. I’ll do a full blog post later explaining what I did, but basically set up a checkbox field that I labeled ‘Ready for Update’. I think one of the concerns with update triggers is when to perform them, what if you updated one cell, then in the process of updating the next cell and your process triggers due to the first update. By having a field that you have to check to notify its ready for updating, you avoid that issue.

Then, as Roman suggested, create a view that is filtered to only show rows who have this ‘Ready for Update’ checked.

Then, in zapier, you can perform a lookup for everytime a row is added to this view. That will trigger your workflow.

Then at the end of the workflow, I go back and use the ID i got in the first step, and update that row to uncheck the ‘Ready for Update’. Now if you update it again and check that box, it will re-trigger the workflow again in zapier.

Pretty slick! Full write up to come.


#25

Well, shoot. Maybe I spoke too soon. Looks like Zapier doesn’t re-trigger the second time you check the box to re-add it to the view. This is due to it already having a cache of the id saved to avoid duplicated triggers.

So, maybe it will require a custom zapier connector. I’d still be up for doing that if any takers on sponsoring it.


#26

Yup. If only they would simply allow a setting to disable that feature…


#27

Any updates on this? I too see this as an essential feature and finding the lack of triggering on update or equivalent functionality severely limiting. It is especially frustrating when trying to set up new Airtable integrations and testing the functionality, as any record that is used as a trigger then becomes useless for future tests.


#28

Instead of Zapier taking action on a new Airtable row… can I do that directly through the airtable API?


#29

You still have the issue of knowing when there is a new record.


#30

Yes, that is correct. :frowning:

If anyone here has used Zapier, I could use your help integrating Zapier [Webhook] and Airtable


#31

+1 on this, is there any timeframe on when this will land?


#32

Also bumping this. It’s difficult for us to fully transition to Airtable without this


#33

Is there any timeframe for webhook when a record is updated? We are looking to migrate our CRM here shortly and that is probably a no-go for us without it. Can’t do much tag-based automation (for marketing segmentation) without it.


#34

Adding my +1 to this - allowing an updated record to work as a Zapier trigger would be a game-changer!


#35

I wasted hours and hours trying to figure out why my workflows wouldn’t trigger, then I found this thread.

It seems anytime a Zap touches any Airtable record once, that record can never be used as a trigger again. I even tried a work-around to set up a Zap that creates a duplicate record in a different table (assuming I could then use that duplicate record as a trigger later) but even that fails because the Zap created the record, so it caches the id.

What is most frustrating is this cached id is persistent across different zaps. I would understand (and frankly appreciate) the functionally to never run the same zap on the same Airtable record twice. That’s sensible. But If I want to pick up that record later for an entirely different zap to do something entirely different, I can’t do so. As others have said, that’s severely limiting to creating multi-step workflows.

@Airtable_Team Any chance you’re listening?


#36

I’m not certain the problem is with Airtable. If you look into many Zapier integrations, you’ll find this to be a frequently recurring limitation for a wide range of apps. For instance, I recently used Zapier to link Google Sheets to Airtable for a client, and I quickly ran into the middleware’s refusal to trigger on a cell update if it meant the cell was returned to a value Zapier knew it to have previously held. Given this was an advertising buy-scheduling system, it seemed quite likely for an ad campaign to be shifted off and then back on to a given date, rendering it invisible to Zapier.¹

In any case, this is essentially the same limitation everyone complains about with Zapier’s Airtable triggers – but having nothing to do with Airtable. Admittedly, if it is a problem with Zapier’s architecture, I can’t imagine what purpose it must originally have served, nor can I fathom why it wasn’t fixed years ago.


  1. In the end, I got around the problem by ignoring Zapier’s triggers; instead, I wrote a simple Google Apps Script that’s triggered by a edit to any cell in the sheet. Significant changes fire off a POST to a Zapier webhook, which in turns updates Airtable accordingly.

#37

I think you’re correct, this is not entirely Airtable’s fault. I was mistake in my earlier assessment that records won’t be picked up by a second, entirely different zap.

The problem in my workflow was that I was using Zapier filters to only run the Zap when certain conditions were met (in my case, it was preventing an automated email from sending on weekends). This was a mistake, because if the Zap saw a new record in my Airtable View, it ran. If an Airtable record did not pass the Zapier filters, then later on, when the record would pass the filters, it was ignored. Zapier only gets one “shot” at a new record in a view, and after that it won’t trigger again.

Airtable and Zapier would need to work together to fix this - Airtable would need to provide an API reference that told Zapier when/if an individual record was updated, and Zapier would then need to provide functionality to re-trigger a record when the record was updated since the last attempt.

For me, the way around this is to avoid using Zapier filters altogether. Instead, I control all the filtering on the Airtable View (I added in several Formula fields to compute various things, like current hour of the day, day of the week, etc.).

By ensuring the record will never appear in a view until I want the Zapier to run, it seems to be working quite well. I have different Views set up for different stages of my automation, and the record can pass between Views successfully and the Zaps run without issue.


#38

There’s also the quick-and-dirty work-around of [ab]using Slack as a trigger, of which I first learned from a post by @Chester_McLaughlin. I’ve not used it in a production system, but I did cobble together an Airtable-to-Slack-to-Zapier-to-Airtable integration that seemed to work OK. (Of course, I’m not sure if I tested whether reappearance in the view I’m using to trigger Slack actually triggers Slack…) It’s pretty much real-time notification, as well. I’ve read comments the system drops messages occasionally, seemingly related to integrations that have Airtable triggering messages on multiple Slack channels for the same update, but that’s not something I’ve tested.


#39

Our recent show and tell introduces a solution to this age old question of update record triggers (finally!). Be sure to check it out: Custom Connector for Zapier


#40

Just seeing your connector. At $49.99 a month I’m curious if there is a trial so I can test and be sure this connector will work?


#41

So this isn’t a perfect solution, but I do have a manual workaround that actually worked out better for a given use case.

In my office we were wanting to use AirTable to store and centralize contact information and link it to various other records. We would be constantly adding information to records as we found out people’s cell phone numbers and additional email addresses etc. That makes it slightly risky to auto sync and update the information as someone could accidentally delete some information and clear it our of our database.

The workaround was to set the trigger to be a button push. Air table would then search for any record with “Yes” in the field “Ready for Update?”. It would update the contact information in the first record with Yes in that fields to google contacts, then after it updates it looks back for that same field (using the main ID# we use as a key to identify it) and updates the Yes to “Updated” and puts the timestamp of the button press into another field for records.

You do have to press the button once for each record you update, but it will work every time you press it, and it can repeated any number of times.

I know its not quite automated, but when its something as vital as contact information, it can sometimes be best to have a physical trigger to make sure that things don’t trigger improperly.


#42

@openside is a short trial available to test this out?


#43

Hi @Delali_Dzirasa @Nick_Duda (sorry I missed your post from a few months ago. never got a notification).

We offer a full refund in first 14 days if it doesn’t work out for you. Just reach out to our community site and submit a ticket and it will be refunded.

Thanks!