I have a mysql module that creates data.
It is processed using the csv module and it will be sent directly to a google sheet file to be saved.
The only problem is that is not saved as I want inside the google sheet.
The data would be better saved like a normal csv with every value inside his specific column.
This is the scenario and it might be inside the google sheet itself or in Make
The entire scenario:
Inside the Google Sheet:
The csv module:
The result inside the google sheet module
Thanks in advance
If you already have a CSV, you can’t just add it to a row like that.
You can use the Google Drive “Upload a file” module, which you can use to convert a CSV into a spreadsheet document in the module advanced settings.
3 Likes
That is good advice and I am doing that right now. The only problem is that i would like to create a single csv file having all the information that I need. Right now it creates multiple csv’s per query. Is it possible to aggregate all the results from mysql and store them in a global variable. Than use the drive upload a file module to create a single csv file with all the query’s results? Thank you in advance
I am almost done with the solution and once I fix this error I will upload the final solution. Drive does not save me the values in the correct format at the end.
It’s easier to show what I mean by that:
Inside the Google Drive module:
Inside Google Sheet:
The problem is the double quotes inside the A2 column “08:00:00” that does not make sense to me 
