Insert a table in an automated email

AppSheet AppSheet Q&A
, , ,
1

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

newsletter.JPG
newsletter.JPG924×315 44.5 KB

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

Do you have any tips for it?

2

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 <> in Column 2 Row 2. You can change the table line colours to suit