LOW / CODEBlueprints
salesai

AI Personalized Sales Email Drafter

Generate hyper-personalized outreach emails using Claude AI based on prospect data from Google Sheets. Each email is tailored to the prospect's role, company, and pain points before being drafted in Gmail.

Beginner~15 minn8nMake.com 932 downloads 1845 views

Setup Instructions

1. Create a Google Sheet with columns: Name, Email, Company, Job Title, Pain Points, Notes. Add your prospect data. 2. In your automation platform, create a new workflow triggered by "New Row Added" in your Google Sheet. 3. Add an HTTP Request node to call the Claude API (POST https://api.anthropic.com/v1/messages). Set the headers: x-api-key to your Anthropic API key, anthropic-version to 2023-06-01, and content-type to application/json. 4. Set the model to "claude-sonnet-4-20250514" and max_tokens to 1024. Write a prompt that includes the prospect's name, company, job title, and pain points. Ask Claude to write a personalized cold email that is concise (under 150 words), references their specific challenges, and includes a clear call-to-action. 5. Add a Gmail node to create a draft email. Set the To field to the prospect's email, use a compelling subject line from Claude's response, and set the body to the generated email content. 6. Add a Slack node to post a notification to your #sales channel confirming the draft was created, including the prospect name and subject line. 7. Test the workflow by adding a new row to your sheet. Verify the draft appears in Gmail and the Slack notification fires. 8. Refine the prompt based on output quality. Add examples of your best-performing emails to the prompt for better results.
Troubleshooting
**Claude generates generic emails:** Improve your prompt with specific instructions about tone, length, and style. Include 1-2 example emails that performed well. Add more context in the Pain Points column of your sheet. **Gmail draft not appearing:** Ensure Gmail OAuth has "compose" scope. Check that the email address format is valid. If using a Google Workspace account, verify API access is enabled in the admin console. **Google Sheets trigger not firing:** Confirm the trigger is set to "New Row" not "Updated Row." Check that the sheet name and range match exactly. Some platforms require a specific polling interval — set it to 1-5 minutes. **Token limit errors from Claude:** Keep prospect data concise in the spreadsheet. If pain points descriptions are very long, summarize them before sending. The max_tokens of 1024 should be sufficient for a single email.

Need a custom version?

We can build a tailored automation workflow for your specific needs.

New blueprints weekly

Get notified when we publish new automation workflows.