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