Skip to main content

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?

Hi @ReadingItLater 

Check out this related topic about how to create a looping Zap with GSheets

 

@ReadingItLater  Just checking in to see if you still need help with this? 

Terms & Conditions