I’m using a third-party program that will auto-import data from a Google Sheet after X amount of time. However, it will import ALL data on that sheet EVERY time, so it breaks because the full data is more than it can handle as a single import.
What I’m thinking is to setup the Google Sheet to do the following:
- Move new row to a new sheet/tab after entry (AKA keeping a historical record)
- Then after Y amount of time, delete the data from the first sheet/tab.
This would then allow the third-party program to only pull in new data and not try to download the full data load.
When I tried to set this delete step in Zapier, it wanted me to specify a precise row that needs to be deleted. Since data is entered into this spreadsheet in batches, we could have 30 entries in there at a time. How do I work around that?
Check out this related topic about how to create a looping Zap with GSheets