Hi,
We created a zap that ends with copying a table from a Google Sheet and pasting it in an email. Unfortunately, the table is not showing up in the email…
Here are the two steps that we have used:
And the setup of each step:
Copying the Google Sheet data:
And how we setup copying it in the email body:
Last but not least, we confirm that Google sheet has been set up appropriately, with all the permissions required for zap.
Thank you for your help!
+14Hi
You need to format the returned GSheet step data as HTML to be used in the email.
OPTIONS
The issue here is that Zapier's Gmail action doesn't natively handle full table formatting from Google Sheets well—HTML gets stripped or mangled in most cases.
Quick fix that usually works: add a Formatter by Zapier step (Utilities > Text) right before Gmail to convert your table rows into plain text with pipes or tabs for alignment, like this:
Column1 | Column2 | Column3
Value A | Value B | Value C
Then drop that formatted text block into the email body. Keeps it readable without fancy HTML fights. If you need proper tables, switch to sending via SendGrid or another email app that respects HTML better.
Hi
We added the step as recommended:
and call the output in the email as follow:
We do get the data in text format, which is great progress, but it is returned in columns instead of lines.
Example- instead of getting the content of the cells like this: Line 1 / Col A - Col B - Col C, then Line 2 / Col A - Col B - Col C, we get:
Is there a way to change this? (We obviously want the content of the table line by line and not column by column)
Thank you very much!
+14
First, I do not recommend using the Email by Zapier app to send emails as there are limitations.
Help: https://zapier.com/apps/email/integrations#help
Instead, use your own email app account. (e.g. Gmail, Outlook)
Help link about HTML tables: https://www.w3schools.com/html/html_tables.asp
For the Formatter step, for the Separator field instead of a comma use: [:newline:]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
