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?
Solved! Go to 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
User | Count |
---|---|
17 | |
11 | |
7 | |
3 | |
2 |