Hi all, I am an airtable enthusiast and recently started using automations. I am trying to report data from an airtable table to a google sheet using an automation. I am not getting the desired result, either using the list format or using the table format. Am I doing something wrong or is this a malfunction? I attach the screenshot of the airtable table, the screenshot of the automation and the screenshot of the results on google sheet. I hope someone can help me to solve it without the need to activate paid plugins. Thanks for any support you can give me
Hm, I think the "Insert all records as List/Grid" option is generally expected to be used in conjunction with emails, and it's an HTML element that displays the found records
I don't think you're able to create one new row in Google Sheets per found Airtable record with the "Find Record" action I'm afraid, and you'll need to have an automation run per Airtable record that you want appended as a new row in Google Sheets
If I get for example 30 records with "Find Record" am I able to process them one at a time with automation? I have already done an automation to create a variable number of rows (from 1 to 5) based on the content of a field, but it is a sequential approach and not recursive, I can't expect to use the same method for 20-30 items ...