{"product_id":"n8n-workflow-google-sheets-lead-research-briefs-with-claude","title":"n8n Workflow: Google Sheets Lead Research Briefs with Claude","description":"\u003ch3\u003eTurn unprocessed Google Sheets leads into ready-to-send research briefs (with Claude + Google Docs)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls “NO” leads from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, fetches each company’s website, uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to generate a factual research note and a 3-idea brief, then saves a polished 350–500 word pre-outreach brief as a \u003cstrong\u003eGoogle Doc\u003c\/strong\u003e—optionally adding the lead to an \u003cstrong\u003eInstanlty\u003c\/strong\u003e campaign with the Doc link.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e and loads workflow settings like your offer, sender name, and the maximum number of leads to process.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads leads from Google Sheets\u003c\/strong\u003e where the \u003cem\u003eProcessed\u003c\/em\u003e column is set to \u003cem\u003eNO\u003c\/em\u003e, then processes leads one-by-one (limited by your configured maximum).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes lead fields\u003c\/strong\u003e, fetches each company website via HTTP, and converts the returned HTML into plain text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Anthropic Claude\u003c\/strong\u003e to produce a factual company summary, target audience, and a short “3 ideas” brief aligned to your offer—then validates the analysis and skips unusable outputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a 350–500 word pre-outreach brief\u003c\/strong\u003e, validates the required format\/length, and stops processing that lead if the brief is invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a Google Doc\u003c\/strong\u003e in Google Drive, builds the document URL, and optionally posts the lead to \u003cstrong\u003eInstantly\u003c\/strong\u003e with the Doc link stored in the personalization field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e with the document link and sets \u003cem\u003eProcessed\u003c\/em\u003e to \u003cem\u003eYES\u003c\/em\u003e (or \u003cem\u003eDOC ONLY\u003c\/em\u003e if Instanlty fails, or \u003cem\u003eNO\u003c\/em\u003e on error) before continuing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams researching prospects from a lead spreadsheet and sending personalized pre-outreach drafts.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building scalable outbound workflows that generate assets per lead (Docs + optional messaging).\u003c\/li\u003e\n  \u003cli\u003eMarketing operators who want website-grounded briefs using Claude, with auditability via Google Docs.\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, Google Drive, HTTP website fetching, Anthropic Claude, optionally Instanlty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes:\u003c\/strong\u003e if, set, code, limit, markdown, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKey validation:\u003c\/strong\u003e checks Claude output usefulness and ensures the outreach brief is 350–500 words before proceeding.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e add credentials for Google Sheets and Google Drive.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244551852211,"sku":"N8N-21116","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bNqtjcZF-8yIhFJLhyW8S_3XAhvemj.png?v=1792401752","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-lead-research-briefs-with-claude","provider":"N8N Commerce","version":"1.0","type":"link"}