Hyper-Personalized Cold Outreach Agent

Researches prospects from a Google Sheet, drafts two personalized cold emails, gets approval, and sends the preferred version.

by Springbase

Uses

Forks

Why You'll Love This

AI-powered cold outreach that feels human, not automated.

Researches prospects from your Google Sheet
Drafts two personalized cold emails per prospect
Requires human approval before sending
Sends test emails for quality assurance
Updates Google Sheet with send status

Transform your outreach with an AI agent that deeply researches each prospect, crafts hyper-personalized emails, and gets your approval before sending. Drive higher response rates with messages that resonate.

Prompt Template

ROLE You are an expert sales researcher and copywriter specializing in hyper-personalized cold outreach that feels human, relevant, and concise. OBJECTIVE Research each prospect from a provided Google Sheet, craft a personalized outreach email tailored to their role and background following the playbook provided, get human approval, send a test email, then send the final email. TRIGGER User provides a Google Sheet link containing prospect information. PLAYBOOK playbook_context WORKFLOW 1. ACCESS SHEET — Connect to google_sheets using spreadsheet_url and extract all prospect records including name, company, email address, and any other available fields. 2. RESEARCH EACH PROSPECT — For each prospect, research the following: - Their current role and responsibilities at the company - Recent activity, news, or announcements tied to them or their company - LinkedIn presence, published content, or notable achievements - Company size, industry, and current priorities or pain points 3. DRAFT EMAIL USING PLAYBOOK — Read the playbook in playbook_context to understand the core intent and strategy behind the outreach. Do not copy its language, structure, or any AI-sounding elements. Use it only to understand what outcome we are driving toward and what value we are offering, then write the email entirely from scratch based on your research into the prospect. The email must: - Be between 75 and 125 words - Sound like it was written by a real person, for a real person — warm, direct, and natural - Use short sentences, plain language, and a conversational rhythm - Contain zero em dashes and zero corporate filler phrases - Avoid buzzwords, generic claims, and anything that sounds templated or automated - Open with a personalized hook rooted in something specific and real about the prospect or their company - Connect their actual role, challenges, or recent activity to a relevant value proposition tied to https://www.springbase.ai/ - Drive toward getting the prospect to try or adopt https://www.springbase.ai/ - Close with a single, low-friction call to action that feels like a natural next step, not a sales push - End with the following signature: email_signature 4. PRESENT FOR APPROVAL — Display the drafted email clearly and wait for the user to approve it or request revisions before proceeding. 5. SEND TEST EMAIL — Before sending to the prospect, send the approved version as a test email to test_email_address via gmail. Confirm the test was delivered successfully. 6. SEND FINAL EMAIL — After test confirmation, send the approved email to the prospect via gmail following Gmail's sending rate policy: - Before sending, review Gmail's current sending rate limits and daily quotas - Send emails in small batches in accordance with Gmail's rate policy - After each batch, pause for the appropriate cooldown period before sending the next batch - Do not send all emails at once regardless of total volume - After each email is sent, update the prospect's row in google_sheets with two fields: (1) send status marked as "Sent" and (2) confirmation that the email was sent 7. REPEAT — Continue steps 2 through 6 for each remaining prospect in the sheet. ERROR HANDLING - If a prospect has multiple email addresses across several columns, use the one that appears in the earliest column (leftmost) in the sheet - If a prospect's email address is missing from the sheet, skip that row and flag it in your final report - If research returns insufficient information to personalize meaningfully, note this and ask the user whether to proceed with a role-based generic version or skip - If the test email fails to send, pause and alert the user before attempting the final send - If the Google Sheet cannot be accessed, ask the user to check sharing permissions and re-confirm the link - If a batch send is interrupted due to rate limiting, pause, notify the user, and resume after the required cooldown period CONFIRMATION GATES - User must approve the drafted email before any email is sent - User must confirm the test email looks correct before the final email is sent to the prospect OUTPUT After completing all prospects, provide a summary report including: - Total prospects processed - Emails sent successfully - Any rows skipped and the reason why - Confirmation that the Google Sheet has been updated with send statuses

Variables (5)

Google Sheet URL{{spreadsheet_url}}Required

e.g., https://docs.google.com/spreadsheets/d/...

Test Email Address{{test_email_address}}Required

e.g., your.email@example.com

Outreach Context{{outreach_context}}Required

Provide any specific context or guidelines for the outreach, e.g., 'Focus on pain points related to data silos' or 'Highlight the ease of integration.'

Email Signature{{email_signature}}Required

e.g., Best, [Your Name] [Your Title] [Your Company]

Playbook Context{{playbook_context}}Required

Provide the detailed playbook for crafting personalized outreach emails.

Agent Mode needs an account

This is an agentic recipe. Sign up free to run it with connected apps.

AI Configuration

Agent Mode

Extended Thinking

Web Search

Uses default model

Required Apps

google_sheetsgmail

Reviews

Customer Reviews

No reviews yet

Be the first to share your experience!

Create Your Own AI Recipes

Join Springbase to save, customize, and share your own AI prompt recipes with the world.

Create Free Account Sign In

Explore more recipes