Question

Move Google Sheets Row to New Sheet then Delete

  • 26 January 2021
  • 2 replies
  • 346 views

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?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @ReadingItLater 

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

 

Userlevel 7
Badge +10

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