There are multiple threads regarding how to convert a google sheet to CSV. A customer provided a solution which in my opinion works the best for this.
@Jordan_VanMaanen Thanks!
Of note - The Google Sheet needs to be public if you’re going that route; otherwise it’s unable to be downloaded. Or somehow have your HTTP request authenticated.
I also discovered that you can get that same link via the Google Drive module which has an Exports Links collection returned with various outputs, CSV being one - But also, you need to be authenticated.
I settled on this solution which uses the Make an API Call module of Google Drive to download the file as a CSV.
1 Like
I do not get. You just sent screenshot without explaining how the stuff works. You even covered the other modules
@Bulala Welcome to the Make community!
While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic as the post was made last year. It helps other community users to respond to your query and help you with your scenario. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.
The “New Topic” link can be found in the top-right of the header:
Thanks!