AI-Powered Cold Outreach Draft Generator from Google Sheets
Automates the creation of highly personalized cold outreach email drafts by reading buying signals from a Google Sheet, enriching them with strategic messaging, and generating unique, relevant content for each prospect.
This automation streamlines your top-of-funnel sales process by transforming a simple list into a powerful outreach engine. Here's how it works:
- Reads Buying Signals: The automation connects to your specified Google Sheet and reads a list of prospects and the "buying signals" that make them a good fit, such as a recent funding round, a key new hire, or geographic expansion.
- Applies Strategic Angles: For each signal, it selects a relevant "bridge angle"—a talking point that connects the signal to a specific business challenge. It rotates through different angles and call-to-action styles to ensure variety in your outreach.
- Generates Personalized Drafts: Using a powerful AI model, it crafts a unique three-part email for each prospect. This includes a hook referencing the signal, a bridge explaining the resulting challenge, and a value proposition line that connects directly to your company's offering.
- Saves the Output: Finally, the automation saves the generated subject lines and email bodies. You can choose to have them written back directly into your Google Sheet for easy review and copy-pasting, or you can configure it to push the drafts directly into a sales outreach platform.
Usage Ideas
- Scale your top-of-funnel prospecting without sacrificing personalization.
- A/B test different messaging angles and calls-to-action at scale to see what resonates.
- Enable non-sales team members, like founders or marketers, to conduct effective outreach.
- Create personalized follow-up sequences for leads from conferences or webinars.
- Automate targeted outreach for Account-Based Marketing (ABM) campaigns.
Customization Ideas
This template is designed to be highly adaptable to your specific sales strategy. You can easily customize it to:
- Use Your Data: Simply provide the URL to your own Google Sheet. The automation can be adjusted to match your specific column names for prospect and signal information.
- Define Your Brand: Set your name, company, and unique value proposition to ensure every draft is authentic to you and your business.
- Control the Tone: Specify the exact tone for the emails (e.g., "witty and informal" or "formal and direct"), or let it learn from your organization's existing communication guidelines.
- Craft Your Messaging: Easily modify the strategic "bridge angles" and "calls to action" to perfectly match the problems you solve and how you sell.
- Choose Your Destination: Decide whether to save drafts back to your Google Sheet for manual review or build out a direct integration with your favorite sales engagement platform (e.g., Smartlead, HubSpot, Lemlist).
Agent Inputs
Required Parameters
Name | Type | Default |
|---|---|---|
eventLogSheetUrl | string | None |
URL of the Google Sheet event log containing buying signals to process | ||
outputMode | string | None |
Output destination: "sheet" writes drafts back to the Google Sheet, "platform" pushes to an outreach platform. You must explicitly choose one. | ||
senderCompany | string | None |
Sender's company name, used in context and email signature | ||
senderName | string | None |
Name for the email signature (e.g. your first and last name) | ||
senderValueProp | string | None |
One-sentence description of what the sender's company does. Anchors the value proposition in each draft — the value prop line must reference this offering. | ||
Optional Parameters
Name | Type | Default |
|---|---|---|
customTone | string | |
Custom tone instructions for draft generation. Only used when toneSource is set to "custom" (e.g. "casual, witty, concise") | ||
maxEvents | number | 50 |
Maximum number of events to process per run. Use -1 to process all available events. | ||
outreachPlatform | string | |
Outreach platform name for platform mode. Required when outputMode is "platform". Supported: smartlead, lemlist, instantly, hubspot_sequences, outreach, apollo_sequences, other | ||
outreachPlatformUrl | string | |
URL of the outreach platform home page or sequence builder (platform mode only). If not provided, a default URL is used for known platforms. | ||
reprocessExisting | boolean | false |
When true, also reprocesses rows already marked as "processed" and overwrites their existing drafts. Useful after changing prompt settings or sender config. | ||
targetCampaignName | string | |
Name of existing campaign/sequence in the outreach platform (platform mode only). If empty, a new campaign named "Per-Event Outreach [date]" is created. | ||
toneSource | string | knowledge_base |
Tone source: "knowledge_base" uses the organization's communication-tone document if available (falls back to professional default), "custom" uses the customTone parameter | ||
