Skip to main content
Question

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

  • March 24, 2022
  • 2 replies
  • 661 views

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 24, 2022

Hi @SimonCarr 

Good question.

Have you tried this Zap action: GDrive Replace File

 


  • Author
  • Beginner
  • March 24, 2022

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