@Robert_Blakeley You have hit upon one of the major limitations of Airtable’s Automations, which is that Airtable’s Automations do not support looping through found records.
Airtable’s Automations can only process your found records as an entire group of records, but it can’t separate them out individually.
First, I would highly recommend sending an email to support@airtable.com about this issue to request that they add this as a feature in Airtable’s automations.
Second, you didn’t actually say what you are trying to accomplish, so I can only assume that you are trying to add new rows to a Google Sheets spreadsheet based on the records that were found — one new row for each record found.
There are at least 3 workarounds that would enable you to accomplish this:
-
Write a JavaScript. I do not know JavaScript, so I can’t help you there.
-
Use the workaround that I discuss in this BuiltOnAir Airtable podcast episode:
- Use an external automation tool like Make to accomplish this. In my personal opinion, Make is the best automation platform on the market, and I believe that it is a million times better than Zapier. Doing what you want to do would be a very simple 2-step automation that looks like the screenshot below. It is literally as simple as this:
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with #2 or #3 above, please feel free to contact me through my website: Airtable consulting — ScottWorld
