I would like to sync google sheets and airtable. (new or modified row in sheets -> updated row in airtable)
Could you please confirm that my understanding of the tasks consumed is correct.
(Assumption the google sheet has 500 rows.)
First syncing from the 500 rows to the until then empty airtable: 500 Tasks
Adding 100 rows to google sheets. 100 tasks to update airtable.
modifying 50 rows in google sheets: 50 tasks to update airtable.
(In other words, there is no automation which syncs the entire google sheet whenever there is a change, e.g. for one task?
That would be more convenient (and cheaper), to simply sync (or overwrite) the entire airtable with the google sheet, independently if there is one change or one hundred, instead of "paying" with tasks for each changing row.
So in short, is the assumption correct that one pays per changed row and there is no option to sync entire tables.
Thanks a lot
Could you please confirm that my understanding of the tasks consumed is correct.
(Assumption the google sheet has 500 rows.)
First syncing from the 500 rows to the until then empty airtable: 500 Tasks
Adding 100 rows to google sheets. 100 tasks to update airtable.
modifying 50 rows in google sheets: 50 tasks to update airtable.
(In other words, there is no automation which syncs the entire google sheet whenever there is a change, e.g. for one task?
That would be more convenient (and cheaper), to simply sync (or overwrite) the entire airtable with the google sheet, independently if there is one change or one hundred, instead of "paying" with tasks for each changing row.
So in short, is the assumption correct that one pays per changed row and there is no option to sync entire tables.
Thanks a lot