{"product_id":"n8n-workflow-google-sheets-apify-claude-cold-email-icebreakers","title":"n8n Workflow: Google Sheets + Apify + Claude Cold Email Icebreakers","description":"\u003ch3\u003eTurn Google Sheets leads into personalized cold email icebreakers—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Google Sheets for unprocessed B2B leads, uses Apify to pull each lead’s most recent LinkedIn post and website content, then leverages Anthropic Claude to generate a 15–30 word LinkedIn-based email icebreaker. Approved results are written back to your sheet with “Processed” marked as “YES.”\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads leads from Google Sheets\u003c\/strong\u003e: start the workflow manually, then selects rows where the \u003cem\u003e“Processed”\u003c\/em\u003e column is set to \u003cem\u003e“NO”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses up to 50 leads\u003c\/strong\u003e: loops through the first 50 leads one at a time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes recent LinkedIn activity via Apify\u003c\/strong\u003e: runs an Apify actor to fetch each lead’s recent LinkedIn posts, extracts the most recent non-repost post text, and uses it as the base for personalization.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches company website context\u003c\/strong\u003e: pulls the company website HTML, converts it to plain text, and uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to summarize relevant company details for context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a tight icebreaker\u003c\/strong\u003e: asks Claude to produce \u003cstrong\u003eone 15–30 word LinkedIn-based cold email icebreaker\u003c\/strong\u003e using only the LinkedIn post content—or returns \u003cstrong\u003e“SKIP”\u003c\/strong\u003e if there isn’t a strong personalizable detail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters weak or unwanted outputs\u003c\/strong\u003e: rejects icebreakers that match banned patterns (e.g., missing “LinkedIn,” salesy language, clichés, or hyphenated phrasing) and flags them as \u003cstrong\u003e“SKIP”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets\u003c\/strong\u003e: appends\/updates the lead row matched by email with the icebreaker and sets \u003cem\u003e“Processed”\u003c\/em\u003e to \u003cem\u003e“YES”\u003c\/em\u003e, after a short rate-limit wait.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFast enrichment of SaaS sales or recruiting lead lists stored in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eCreating compliant, non-generic LinkedIn-based email openers at scale with n8n.\u003c\/li\u003e\n  \u003cli\u003eAutomating “research → icebreaker → write back” for outbound sequences.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Sheets, \u003cstrong\u003eApify\u003c\/strong\u003e, Anthropic (Claude)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes mentioned\u003c\/strong\u003e: set, code, wait, merge, markdown, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eControls\u003c\/strong\u003e: processes first 50 leads; loops one by one; includes rate-limit waits; updates rows matched by \u003cem\u003eemail\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114750398643,"sku":"N8N-19987","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QV1CoJXlC44tUtxa4bcL8_wHdWUXcT.png?v=1790587353","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-apify-claude-cold-email-icebreakers","provider":"N8N Commerce","version":"1.0","type":"link"}