Notifications
Clear all
Topic starter
Hello,
I have a scenario where I retrieve data from an Airtable table and then perform a batch update into a Google Sheet.
I've spent considerable time trying to prevent rows from one branch of a router from being overwritten when rows from a subsequent branch are written to the Google Sheet.
The batch.update method used in the "Make an API call" module doesn't seem to support appending rows sequentially. It appears to overwrite previous rows when I utilize a router.
I need this router because, for instance, one row might have data for a specific column mapped from an Airtable field, and the next row might have data for the same column mapped from a different Airtable field.
Does anyone have suggestions on how I can adjust this scenario to ensure all rows from each branch are recorded into Google Sheets? I would greatly prefer to use batch.update as I anticipate processing between 2000 to 4000 operations once or twice a month.
Thank you in advance.
Laure
Posted : 11/01/2024 3:51 pm
If you plan to add multiple lines to a Google Sheet via a batch API call, it's recommended to use batch append rather than batch update. Batch update will overwrite existing data, whereas batch append will insert new rows.
You can consult the images below for guidance on making a batch append API call.
Posted : 11/01/2024 4:58 pm