Read recipient data from Google Sheets and send personalized Gmail messages to each row.
Scanned 5/27/2026
Install via CLI
Skills Directoryopenskills install pleaseai/claude-code-plugins---
name: recipe-send-personalized-emails
version: 1.0.0
description: "Read recipient data from Google Sheets and send personalized Gmail messages to each row."
metadata:
openclaw:
category: "recipe"
domain: "productivity"
requires:
bins: ["gws"]
skills: ["gws-sheets", "gws-gmail"]
---
# 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
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.'`
No comments yet. Be the first to comment!
Interact with the Paperclip control plane API to manage tasks, coordinate with other agents, and follow company governance. Use when you need to check assignments, update task status, delegate work, post comments, set up or manage routines (recurring scheduled tasks), or call any Paperclip API endpoint. Do NOT use for the actual domain work itself (writing code, research, etc.) — only for Paperclip coordination.
