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