Insert a table in an automated email

[rolandkondor]

Hello Guys!

I would like to create a weekly newsletter automatically (open positions in our company).

I have a sheet with open positions and I want to include two column's data into the table (with filter: active) and in an email: 

- Positions name - External link to apply for the job

I would like to see every active open positions in the "generated" table.

Do you have any tips for it? 

[1minManager · Accepted solution]

You'll want to checkout this first - https://support.google.com/appsheet/answer/11541779?hl=en

Create a template file for the email body and in that put a 2x2 table.  The top row are your headers in bold, the <<START: command needs to be in Column 1 Row 2 and the <<END>> in Column 2 Row 2.  You can change the table line colours to suit