Best answer

google sheets rows to understandable gmail body

  • 10 September 2020
  • 3 replies
  • 118 views

Userlevel 1

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!

icon

Best answer by Wemakefuture 11 September 2020, 06:08

View original

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

Userlevel 6
Badge +7

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!

Userlevel 1

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 :-)

Userlevel 6
Badge +7

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.