Hello team,
Basically I have some information in a google sheets that I need to share with a company. This company does not have access to google, so I need to send an email every Wednesday with this information in an excel. What I need: Understand how I can download this information from google sheets directly by email (and it's an average of 200 lines) Is there any way to download a google sheets through zapier?
Best answer by Danvers
View original
+12
Hi
You can do this without needing to download the information from the sheet by attaching the Google Sheet as a csv file. Excel should be able to open the csv file, even though it was originally a Google sheet. To get the CSV file of the Google Sheet, you need to add a Google Drive Find File step in the Zap before the email step. Set up the step so that it can find the Google Sheets file, the output of that step will include details of the file, including a Csv file of the sheet.
In your Zap, create a Gmail New Email step (or you can use whichever email app you prefer), which means that the Zap will automatically send an email. In the attachment field, use the ‘File Csv’ field from the Find File step:
That will attach a csv file of the Google Sheet to the email, which can be opened by an Excel user.
I hope that’s clear, let me know if you have any questions!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
