Google SheetApi

Instantly Outreach from Google Sheets Leads

This template reads sourced leads from Google Sheets, generates personalized M1/M2/M3 outreach variables, and pushes prepared leads into an existing Instantly campaign.

This automation sends prepared leads from a Google Sheet into an existing Instantly campaign.

  1. Reads Sheet rows: It reads the people tab and joins matching companies rows by company domain when company signal research is available.
  2. Extends outreach columns: It adds Instantly outreach state columns if they are missing, preserving existing sourcing columns and values.
  3. Selects ready leads: It processes rows with blank, ready, or failedRetryable status and ignores rows already pushed, drafted, sent, skipped, or marked do-not-contact.
  4. Applies outreach filters: It can filter by stored personIcpScore and require stored emailVerificationStatus to be deliverable.
  5. Generates M1/M2/M3 copy: It personalizes the approved three-email sequence from the initial prompt using row data, company context, and tone of voice guidance.
  6. Pushes to Instantly: It creates or updates leads in the configured Instantly campaign and passes the personalized sequence copy as custom variables.
  7. Writes Instantly state: It stores generated copy, Instantly lead IDs, timestamps, attempts, and errors back to the people tab so future runs can resume safely.

The Instantly campaign must already have a sequence that uses the m1_subject, m1_body, m2_subject, m2_body, m3_subject, and m3_body custom variables. This template does not source leads, enrich contacts, verify emails, score ICP fit, or configure Instantly sequences.

Agent inputs

Required

NameTypeDefault
campaignNamestringNone
Campaign label used in logs, results, and personalized outreach context
instantlyCampaignIdstringNone
Existing Instantly campaign ID that receives prepared leads
workspaceSpreadsheetUrlstringNone
Google Sheet URL or ID containing sourced leads

Optional

NameTypeDefault
maxContactsToProcessnumber25
Maximum ready people rows to process for Instantly outreach in one run
minIcpScorenumber0
Optional minimum personIcpScore required before Instantly outreach. Set to 0 to trust the upstream sourcing agent's qualification.
requireVerifiedEmailbooleanfalse
If true, only process rows whose stored emailVerificationStatus is deliverable.
toneOfVoiceDocumentSlugstringcommunication-tone
Knowledge base document containing tone of voice guidance for generated Instantly sequence copy

See it run.

Spin up your first agent in five minutes.