I use python to get data from API.
Python will give output as csv file.
That folder the python is in, it’s google drive folder (using desktop app)
Now I want to use that csv data and use as google sheet and perform few automations.
What’s the best way to do it?
That csv has 1000’s of rows of data and multiple 3 sheet inside of it.
You should turn this setting on in Google Drive:
This way, the CSV is automatically converted into a Google Sheet directly upon upload.
@samliew Thank you so much, brother.
@Michaela Can we get the thank you letter from the CEO of make.com for @samliew for the work he has done for the community?
This guy is a lifesaver.
I have tried to use “/speadsheet_id” but not working
Your sheet wasn’t converted to Google Sheets, it’s in xslx format I think.
My uploaded CSV looks like this, which meant it was converted automatically by Google
If you are unable to get it to auto-convert, you can try use the module “Download a file” and “Upload a file” with the convert setting turned on (in the advanced settings).
I did receive a card yesterday in the mail 
Heya @itsmeayyub thanks a lot for bringing this up 
Just so you know, Fabian - our CEO - is well aware of “Sam the Incredible” and deeply appreciates all his outstanding contributions to the community.
@samliew You’re a living legend, that is for sure. Thrilled to see that the package has safely made its way to your door 
