Hi guys
I am trying to import csv files into google sheets.
I receive csv files by email on my gmail account. I have tried to update a file using google drive api but as i am using the google sheet with Looker Studio replacing the sheet creates a bug and i have to reconnect the data base.
So to avoid it I am parsing the csv files, clean the google spreadsheets, and then import row after row the data.
It creates two issue :
- Time as it’s going to take more than 10 minutes
- Operation limit as there is 6 files of several hundred rows
I wanted to use bulk import but i haven’t been able to finalized the settings to make it work…
I copied a scheme of the current scenario.
Thanks for your help
1 Like
Hello! Welcome to the Make Community!
So, in order to do this, you won’t need the Iterator. The Parse CSV is generating Bundles already.
What you need to do:
- unlink or delete the last Iterator and Google Sheets / Add a Row
- add a Google Sheets / Bulk Add Rows at the end of the scenario and map the Spreadhsheet ID and Sheet Name from what you found earlier
- choose column range
- don’t map or fill anything in Rows yet
- click OK
- Now, right-click on the link between Parse CSV and the new GSheets module, and select “Add a Module”
- select Flow Control / Array Aggregator
- for Source module, select Parse CSV
- for Target structure, select Rows
- then you add as many “values” as you have columns and map the relevant fields from Parse CSV
- once you’re done, click ok and open again the GSheet module
- in Rows, map the new “Array”
- click ok, ave and test and let me know the outcome
Benjamin
Ok thanks a lot. I wasn’t far but this rows data of bulk update drove me crazy for the past days…
I’ll be pleased to try but due to the previous configuration i’ve reached the operations limit of my plan…
I’ve asked support to get a push or a restart of my plan to be able to test the solution and set it up → Ticket : https://make-hq.freshdesk.com/support/tickets/1255119
Regards
1 Like
