recipe-send-personalized-emails

SKILL.md

Read recipient data from Google Sheets and send personalized Gmail messages to each row.

Requires gws-sheets and gws-gmail skills to be loaded before execution

Reads recipient lists from a specified Google Sheets range, then iterates through each row to send customized emails

Supports dynamic personalization by embedding recipient data (name, email, etc.) into subject lines and message bodies

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.

Steps

Read recipient list: gws sheets +read --spreadsheet-id SHEET_ID --range 'Contacts!A2:C'

For each row, send a personalized email: gws gmail +send --to recipient@example.com --subject 'Hello, Name' --body 'Hi Name, your report is ready.'