---
id: sm-recipe-send-personalized-emails
name: "recipe-send-personalized-emails"
url: https://skills.yangsir.net/skill/sm-recipe-send-personalized-emails
author: googleworkspace
domain: marketing
tags: ["personalized-email", "email-marketing", "crm-integration", "marketing-automation", "mail-merge"]
install_count: 620
rating: 4.20 (20 reviews)
github: https://github.com/googleworkspace/cli
---

# recipe-send-personalized-emails

> 从Google Sheets读取收件人数据，并发送个性化邮件，实现批量定制化营销或通知。

**Stats**: 620 installs · 4.2/5 (20 reviews)

## Before / After 对比

### 个性化邮件群发，精准营销触达

## Readme

# recipe-send-personalized-emails

# 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.'`

Weekly Installs620Repository[googleworkspace/cli](https://github.com/googleworkspace/cli)GitHub Stars21.4KFirst Seen14 days agoSecurity Audits[Gen Agent Trust HubPass](/googleworkspace/cli/recipe-send-personalized-emails/security/agent-trust-hub)[SocketPass](/googleworkspace/cli/recipe-send-personalized-emails/security/socket)[SnykPass](/googleworkspace/cli/recipe-send-personalized-emails/security/snyk)Installed oncodex603opencode603gemini-cli601cursor601github-copilot601kimi-cli600

---
*Source: https://skills.yangsir.net/skill/sm-recipe-send-personalized-emails*
*Markdown mirror: https://skills.yangsir.net/api/skill/sm-recipe-send-personalized-emails/markdown*