{"product_id":"apify-openai-lead-scoring-n8n-to-google-sheets-sync","title":"Apify + OpenAI Lead Scoring n8n to Google Sheets Sync","description":"\u003ch3\u003eApify + OpenAI Lead Scoring Sync to Google Sheets (n8n Workflow)\u003c\/h3\u003e\n\u003cp\u003eAutomatically pull new leads from your \u003cstrong\u003eApify\u003c\/strong\u003e actor every morning, score each lead with \u003cstrong\u003eOpenAI Chat Completions\u003c\/strong\u003e (1–10), and \u003cstrong\u003eappend the results to Google Sheets\u003c\/strong\u003e—including low-scoring leads—so your pipeline stays clean and actionable.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 8:00\u003c\/strong\u003e and loads your configured \u003cem\u003eideal customer profile\u003c\/em\u003e, \u003cem\u003eoffer description\u003c\/em\u003e, \u003cem\u003escore threshold\u003c\/em\u003e, and a \u003cem\u003eper-run lead limit\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls the Apify \u003cstrong\u003erun-sync-get-dataset-items\u003c\/strong\u003e endpoint to fetch a fresh batch of leads from your selected actor.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates\u003c\/strong\u003e incoming lead fields into a consistent structure, then caps processing to your \u003cstrong\u003emax leads per run\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf no leads are returned, the workflow stops processing. Otherwise, each lead is sent to the \u003cstrong\u003eOpenAI Chat Completions API\u003c\/strong\u003e to generate:\n    \u003cul\u003e\n      \u003cli\u003ea \u003cstrong\u003eJSON score\u003c\/strong\u003e from \u003cstrong\u003e1–10\u003c\/strong\u003e,\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003eone-sentence reason\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eParses the AI response, attaches the verdict to each lead, formats a final row with \u003cstrong\u003etimestamp, lead details, score, reason, and threshold\u003c\/strong\u003e, and \u003cstrong\u003eappends every processed lead\u003c\/strong\u003e to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators routing inbound leads into a spreadsheet with consistent AI-based qualification (not just high-score leads).\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers validating lead quality daily using an ideal customer profile and measurable score thresholds.\u003c\/li\u003e\n  \u003cli\u003eTeams that want a lightweight CRM-like view in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e driven by Apify data and OpenAI scoring.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e, plus \u003cstrong\u003eHTTP Request\u003c\/strong\u003e calls.\u003c\/li\u003e\n  \u003cli\u003eIntegrations:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e via Header Auth (Authorization: Bearer \u0026lt;Apify token\u0026gt;)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e via Header Auth (Authorization: Bearer \u0026lt;OpenAI API key\u0026gt;)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via OAuth2, using your sheet URL\/name for append\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet up once, then let this \u003cstrong\u003eApify + OpenAI lead scoring\u003c\/strong\u003e workflow keep your Google Sheets lead list continuously updated—every morning.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748948697267,"sku":"N8N-17665","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MzA4QTiCuIt8lrYVuzunl_8TQwEmK6.png?v=1785575986","url":"https:\/\/buyflowscripts.com\/products\/apify-openai-lead-scoring-n8n-to-google-sheets-sync","provider":"N8N Commerce","version":"1.0","type":"link"}