I have created a table to import Google Analytics data. It contains 500 records with relative URLs and total page views.
I then want to use an automation to do the equivalent of a VLOOPUP on the URLs to find matches in a content table.
When there is a match, I want to Update the content table record and insert the page view
If I do Update Record after the Find Record step, it tries to run 500 updates and most fail.
If I add Update Record under Conditional Actions, I would expect to be able to pass along the IDs from the Find Record step and just update those. However - though this passes in Test Step and returns a value for page views, it doesn’t get written to the record.
Unfortunately, Airtable doesn’t loop through the found records after a “find records” action. Be sure to email this as a feature suggestion to firstname.lastname@example.org and let them know how important this is to you.
Your only options are:
Use an automation tool like Make.com, which always loops through your records individually after finding records.
Use the workaround that I describe in the podcast below:
Hi Scott. I went back and had another try using the approach you demonstrated. I did get it to work consistent, but with errors. After many hours I couldn’t get rid of these, although the data seemed accurate, the email alerts from the failed processes was a nuisance. I also just don’t like know why stuff doesn’t work!
Much as I’ve enjoyed grappling with this problem, I’ve just had a demo from Fetch Data, and I think I will go with that as it will be easier for colleagues to maintain.