Hi there,
I need to refresh my google sheet data from a csv file on a daily basis
data from the csv file should completely replace existing data in the sheet
I need the sheet to remain the same as it’s connected to looker studio
I’m not sure if this specific “refresh” aspect of the scenario is faisible
Would love some help with this
(I’m stuck with Gmail Iterate Attachment module, don’t know what is the best module to use then) Thanks for your help!
Hi @MC_Petit,
I think there are multiple approaches to this they differ in the complexity but also the operations usage.
The naiive approach would be to simple use the “Clear a Row” module for all rows that you want to remove before adding the new CSV data. Sadly, that’s potentially operations intensive if you have. a lot of rows.
My preferred approach would be to use the module ‘Make an API Call’ and setup an API Call to clear the sheet in one go. For that you’d need to get into the Google Sheets API Documentation (Link here) and get this one call up and running.
Then for the CSV you’d probably use the ‘Parse CSV’ module and add the rows individually or in bulk.
I’d suggest to go and try the naiive approach first, get something to work and then you can optimize! 
Best,
Richard
Welcome to the Make community!
see Clear google sheet before adding new rows for this.
Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
— @samliew
Thanks for the link!
Thansk a lot of for your help @Richard_Johannes and @samliew