Mục tiêu:

+ tạo email với html template, data từ google sheet với apps script.

=> final workflow: đơn hàng mới => webhook => google sheet => create invoice + compose email => send out

Các bước:

1. Get data từ google sheet: apps script – getRange

2. Tạo html template

3. Fill data from google sheet to email

Ref: https://talentnett.com/how-to-send-html-table-in-the-email-body-using-google-app-script/

Ref 2: https://www.bpwebs.com/pull-data-from-google-sheets-to-html-table/

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *