Question

How do I send a properly formatted table from Google Sheets to email daily?

I want to send an email every morning with a table from google sheets but I can’t get the table to format correctly in the email.

I want it to put each account on a new line so its easier to read

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+14

Hi @gb123

Good question.

Will depend on which email Body Type you are using: TEXT or HTML

Try using these options: Formatter > Utilities > options with line items

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

Hi @gb123

Good question.

Will depend on which email Body Type you are using: TEXT or HTML

Try using these options: Formatter > Utilities > options with line items

@Troy Tessalone

I received this error. im trying to do this with TEXT

+14

@gb123
We would need to see screenshots with how your Formatter step is configured.

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

@Troy Tessalone

+14

@gb123

Try using a different option.

You are trying to convert line items to text

You may need to use the Line Itemizer option.

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

Sign up