Enrich new leads and write personalized icebreakers with Google Sheets and Claude

Quick Overview

This workflow watches a Google Sheets lead list, fetches each new lead’s website, extracts page text, and uses Anthropic Claude to generate a personalized cold-email icebreaker plus an ICP fit score and reasoning, then writes the results back to the same sheet.

How it works

1. Triggers when a new row is added to the specified Google Sheets “Leads” worksheet.
2. Loads your ICP definition from a configuration step and reads the new row’s company and website fields.
3. Fetches the prospect’s website homepage via HTTP and extracts the visible text from the page body.
4. Sends the ICP definition, company details, and truncated website text to Anthropic Claude to generate a one-line icebreaker, a 0–100 fit score, and a short justification as structured JSON.
5. Updates the originating Google Sheets row (matched by row_number) with the icebreaker, icp_fit_score, and reasoning values.

Setup

1. Add Google Sheets OAuth credentials and set the Google Sheet document ID and worksheet name used by the trigger and the update step.
2. Ensure your sheet includes columns named company, website, row_number, icebreaker, icp_fit_score, and reasoning.
3. Add an Anthropic API credential and select the Claude model you want to use.
4. Edit the ICP definition text in the configuration step to match your target customer profile.