Skip to main content
Best answer

google sheets rows to understandable gmail body

  • September 10, 2020
  • 3 replies
  • 142 views

Hi there!

 

I’m trying to obtain some rows from a google sheet (like open job positions), and send them by email once per week. 

I would like to send a nice table in the email body… but I cannot find any way to convert the raw data into a table.

Any idea?

 

Thanks!

Best answer by Wemakefuture

Hello 👋 create a zap which is time based: https://zapier.com/help/create/customize/schedule-zaps-to-run-at-specific-intervals

In the meantime:

Create your self an amazing email template for example: https://stripo.email/ there are many other free email templates 🤓.

Now pull in the google sheet rows (maybe add a filter here and there) and parse them in between your Gmail HTML email. And you are ready to go!

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

3 replies

Wemakefuture
Forum|alt.badge.img+8
  • Zapier Solution Partner
  • Answer
  • September 11, 2020

Hello 👋 create a zap which is time based: https://zapier.com/help/create/customize/schedule-zaps-to-run-at-specific-intervals

In the meantime:

Create your self an amazing email template for example: https://stripo.email/ there are many other free email templates 🤓.

Now pull in the google sheet rows (maybe add a filter here and there) and parse them in between your Gmail HTML email. And you are ready to go!


  • Author
  • Beginner
  • September 11, 2020

Hey,

 

thanks for your answer. The problem is not the time interval, but how to build an html table based on the data coming from google sheets :-)


Wemakefuture
Forum|alt.badge.img+8
  • Zapier Solution Partner
  • September 11, 2020

Hey,

 

thanks for your answer. The problem is not the time interval, but how to build an html table based on the data coming from google sheets :-)

Define the table in the HTML template and inser the selected data. If you want we can consult/Dev it.