Manually researching prospects takes 5–10 minutes each. This template adds a lead to your Google Sheet and automatically scrapes their website, extracts real context, and writes a unique opening line for each prospect — delivered back to your Sheet in 30 seconds.
Add a lead to your Google Sheet and the workflow handles the rest automatically. Here is the full sequence:
The Google Sheets trigger monitors your Leads tab and fires every time a new row is added. Paste in a batch of 50 leads at once and the workflow processes them all automatically, one by one.
An HTTP Request node fetches the company's homepage HTML. A Code node then strips all tags, extracts the page title, meta description, and the first 2,000 characters of readable body text — the information most likely to contain what makes the company unique.
The scraped context — company name, job title, site title, description, and body excerpt — is sent to GPT-4o-mini with a carefully tuned prompt. The AI writes a 1–2 sentence opening line that references something specific about their business. No generic phrases. No mentions of what you are selling.
The generated opener is written back to the personalised_opener column on the same lead row, and the status column updates to ready_to_send. Your Sheet becomes the source of truth — review the openers, add your pitch paragraph, and send.
Set the auto_send column to yes for leads you want emailed automatically. The Gmail node sends the personalised opener plus your pitch paragraph to the prospect. Leave it as no to review and send manually — most users review the first batch to calibrate quality before enabling auto-send.
| n8n workflow | 7-node workflow JSON — Google Sheets Trigger, HTTP Request (scrape), Code (extract context), OpenAI (write opener), Google Sheets (write back), IF (auto-send check), Gmail (optional send) |
| Make.com blueprint | Same logic built in Make.com module format — import and connect credentials |
| PDF setup guide | Plain-English step-by-step guide — Sheet setup, OpenAI connection, auto-send configuration, bulk processing |
| Markdown guide | Same guide in .md format |
| Sheet structure | Exact column headers for the Leads tab — copy directly into your spreadsheet |
| Licence | Personal commercial licence — use on your own business, unlimited runs |
When you add a lead to your Google Sheet, the workflow scrapes their company website, extracts the key text, and passes it to GPT-4o-mini which writes a unique, specific opening line referencing something real about their business. The opener is written back to your Sheet within 30 seconds. Optional auto-send via Gmail for hands-off outreach.
Some sites return a 403 error or timeout — this is handled gracefully. The workflow still generates an opener using the company name and job title. You can also add a brief company description in the website_url field and the AI will use that context instead.
When the scrape succeeds, openers reference specific product names, mission statements, unique positioning, or recent initiatives from the company's site. The AI is instructed to avoid generic phrases and never mention what you are selling in the opener. Most users report the outputs read like they spent 5–10 minutes researching each prospect.
Yes. Set the auto_send column to yes for leads you want emailed automatically. Most users review the first 10–20 outputs to calibrate quality, then switch to auto-send. The email body is fully editable in the Gmail node — add your pitch paragraph once and it applies to every send.
GPT-4o-mini costs approximately $0.001–0.002 per lead. Personalising 1,000 leads costs $1–2 USD total. At 100 leads per day, monthly OpenAI costs are under $6 — a fraction of Clay's $149/month.
For the personalised opener use case, yes. Clay charges $149/month for similar functionality. This template does the same job — scrape context, write opener, write back to your CRM — for a one-time $79 with no monthly fees from Peak Automations.
Import the workflow, connect your Google Sheet and OpenAI key, add your first lead row — and watch a unique, specific opener appear in your Sheet within 30 seconds.
Get the Template — $79