Skip to main content
Question

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

  • Aug 15, 2023 2:34 PM UTC
  • 5 replies
  • 226 views

gb123

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.

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Aug 15, 2023 5:06 PM UTC

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


gb123
  • Author
  • Beginner
  • Aug 15, 2023 8:34 PM UTC

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

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Aug 15, 2023 8:55 PM UTC

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

 


gb123
  • Author
  • Beginner
  • Aug 15, 2023 9:04 PM UTC

@Troy Tessalone 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Aug 15, 2023 9:16 PM UTC

@gb123 

Try using a different option.

You are trying to convert line items to text

You may need to use the Line Itemizer option.