Hi everyone, I have a question about automations and what the best practices are when dealing with external API calls.
We have an automation that enriches records by pulling data from Google Maps. Every time a new record is added to the table, a second automation is triggered: it uses an enrichment API to find an email address from the website, verify it, and then update the record.
The issue is that this enrichment step takes a few seconds for each record. Because Airtable runs automations one-by-one and queues them, this causes huge backlogs of pending automations, which slows everything down and sometimes causes the system to get stuck or bug out.
My question is:
What’s the recommended best practice to avoid infinite queues or stuck automations when using external APIs that take a few seconds to respond?
Should we batch records? Or is there a better architectural approach?
Any guidance or suggestions would be greatly appreciated.
