Hi All,
Wanted to send a daily report that is a table in google sheet which will update everyday automatically. May I know how to convert the google sheet data/ table into the gmail body?
Thnaks
Hi All,
Wanted to send a daily report that is a table in google sheet which will update everyday automatically. May I know how to convert the google sheet data/ table into the gmail body?
Thnaks
Hi
This might be a bit tricky but I do like a challenge
Unfortunately there has to be a manual part, problem is there is no way to get the embed code automatically, so you will need to go to Google Sheets > Select the spreadsheet you wanna share > Click File > Share > Publish to Web > Embed then copy the relevant code (you only need to do this once per spreadsheet you wanna share)
Since you have now the code (which looks something like this
<iframe src="https://docs.google.com/spreadsheets/d/e/XXXXXX-XXXXXXXXXX_-XXXXXXXXX-XXXXXXXXX-XXXXXXXXX/pubhtml?widget=true&headers=false"></iframe>
You can setup your zap in the following way:
Trigger > Schedule by Zapier set to Every Day as per your needs
Action > Gmail > Send Email > Body Type = HTML then create your email in HTML
you can add height & width like this
....headers=false" height="300" width="500"></iframe>
Hope this helps :)
Hi
You could attach a pdf version of the table/sheet to the email? I know that it’s not exactly what you’re looking to do, but it would provide a way for people to easily view the table.
To do that, use a Google Drive Find File action to search for your Google Sheets file and then in the send email step add the ‘File Pdf’ field to the attachments of the email.
Do you think that would work for what you need?
Hi
Sorry I have tried the solution above but seems Gmail won’t be able to embed <iframe>
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.