{"product_id":"build-lead-lists-in-chat-openai-specstream-mcp-sheets","title":"Build Lead Lists in Chat: OpenAI + SpecStream MCP + Sheets","description":"\u003ch3\u003eBuild lead lists inside chat—OpenAI + SpecStream + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you request a lead list in chat, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to turn your criteria into a runnable \u003cstrong\u003eSpecStream\u003c\/strong\u003e search, confirms the \u003cstrong\u003equoted cost\u003c\/strong\u003e before execution, and then appends the results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e when you’re ready.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a chat request\u003c\/strong\u003e (e.g., “Get 200 leads in Austin with rating ≥ 4 and category = dentists”).\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to interpret your request and generate a \u003cstrong\u003eSpecStream\u003c\/strong\u003e search specification (via \u003cstrong\u003eSpecStream MCP\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests a SpecStream quote\u003c\/strong\u003e for the desired number of leads, displays the \u003cstrong\u003emaximum cost\u003c\/strong\u003e, and \u003cstrong\u003ewaits for your approval\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRejects quotes that exceed your configured \u003cstrong\u003espending cap\u003c\/strong\u003e, so you stay within budget.\u003c\/li\u003e\n  \u003cli\u003eAfter approval, starts the paid SpecStream \u003cstrong\u003efind job\u003c\/strong\u003e and checks progress when you ask for results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetrieves completed (or partial) results\u003c\/strong\u003e, paginates through all rows, and shows the \u003cstrong\u003efirst 20 rows\u003c\/strong\u003e in a Markdown table including a \u003cstrong\u003eSource URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWhen you ask to save, \u003cstrong\u003eappends one row per lead\u003c\/strong\u003e to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (e.g., Name, Website, Phone, Email, City, Source, and the original Request) and can generate a share link for the find.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams sourcing targeted prospects by \u003cem\u003elocation, rating, or business type\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eSales ops creating batches of leads on demand without switching tools.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers validating lead generation searches with an explicit \u003cstrong\u003ecost confirmation\u003c\/strong\u003e step.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSpecStream MCP\u003c\/strong\u003e with Bearer Auth (API key) for quotes + find jobs\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI Chat\u003c\/strong\u003e to interpret your criteria into a runnable spec\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tool integration to append results\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes include: \u003cstrong\u003en8nnodes-langchainchat trigger\u003c\/strong\u003e, \u003cstrong\u003en8nnodes-langchainlm chat open ai\u003c\/strong\u003e, \u003cstrong\u003en8nnodes-langchainagent\u003c\/strong\u003e, and a \u003cstrong\u003eGoogle Sheets tool\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232427724979,"sku":"N8N-21044","price":17.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/GJJR39hBC3woatJPFZ2lW_j8lIUKG2.png?v=1792142138","url":"https:\/\/buyflowscripts.com\/products\/build-lead-lists-in-chat-openai-specstream-mcp-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}