I’m looking to move my automations from Zapier to Make, and I’ve rebuilt my automation all the way to the final stage which is to email out a CSV of a Google Sheet created as part of the process.
To locate the CSV via the autogenerated link in Google Sheets and send it. I can’t make this work in Make.
I suspect it might have something to do with file permissions, which I have also struggled to adjust using Make. I found a thread in this community that talks about using an API to change permissions, but when I followed the instructions this didn’t work.
An important point I forgot to mention… I need the SECOND tab of the google sheet as a CSV, not the first.
On Zapier, I was able to doctor together the auto generated google CSV link with elements from previous steps (file ID, sheet ID) and then dump that into the ‘attachment’ box on the Gmail step to get a CSV sent.
I’ve actually just solved part of it I used ‘Google Drive - Get a Share Link’ to set the permissions and then it seems the ‘HTTP - Get a File’ can access it… but it’s getting the first sheet not the second one…
just wanted to give you a pat on the back for the great job you did with figuring this out! It makes me happy to see Makers learning how to work with the product and fixing their issues.
FYI I marked your suggestion as a solution so other users can find it while searching for help with similar issues. Thank you for doing the same in the future .
The steps you have taken
Relevant screenshots
Any links you have
Exclude Personal Information.
I used ‘Google Drive - Get a Share Link’ to set the permissions and then it seems the ‘HTTP - Get a File’ can access it… but it’s getting the first sheet not the second one…
,
.