I have a spreadsheet with information about multiple records to insert in Airtable.
I pass the spreadsheet ID and project ID to make. Then i delete all the records for that given project in airrable. To do this I use an iterator to iterate through all the records and delete them one by one.
Then I read the records from my spreadsheet and insert them in airtable.
But when I have to delete 2 records and 5 records to insert the set of 5 records is inserted twice.
The action to read the spreadsheet
The step “Google Sheets” is executed for each iteration of deleting a record in airtable.
How can i have that step only executed once?