Back to Details

recipe-send-personalized-emails

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Send Personalized Emails from a Sheet

从表格发送个性化邮件

PREREQUISITE: Load the following skills to execute this recipe: 
gws-sheets
, 
gws-gmail
Read recipient data from Google Sheets and send personalized Gmail messages to each row.
前提条件： 加载以下skill以执行此方案：
gws-sheets
, 
gws-gmail
从Google Sheets读取收件人数据，并向每一行发送个性化Gmail消息。

Steps

步骤

  1. Read recipient list: 
    gws sheets +read --spreadsheet-id SHEET_ID --range 'Contacts!A2:C'
  2. For each row, send a personalized email: 
    gws gmail +send --to recipient@example.com --subject 'Hello, Name' --body 'Hi Name, your report is ready.'
  1. 读取收件人列表：
    gws sheets +read --spreadsheet-id SHEET_ID --range 'Contacts!A2:C'
  2. 对每一行，发送个性化邮件：
    gws gmail +send --to recipient@example.com --subject 'Hello, Name' --body 'Hi Name, your report is ready.'