Question

Replace an existing sheet with new google sheet which contains update date / new rows

  • 24 March 2022
  • 2 replies
  • 544 views

Userlevel 1

Hi

Scenario

We use Google Data Studio to display MI to users.  We have a series or automated reports (runs daily), sent via Gmail as a .csv attachment.  I am able to use a Zap to copy the csv to a folder in Google Drive.  Im now looking to run a zap which finds the existing file (which Data Studio connects to) and replace it with the new spreadsheet containing the fresh data.

 

Is there a find and replace query I can run to replace the entire spreadsheet?  My hope it that the connector from Data Studio will just update with the new / replaced data? 

Many thanks, in advance, for any help.

Simon


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 @SimonCarr 

Good question.

Have you tried this Zap action: GDrive Replace File

 

Userlevel 1

Thanks @Troy Tessalone, I will give that a try.