{"product_id":"n8n-lead-scoring-workflow-webhook-drive-photos-sheets-score","title":"n8n Lead Scoring Workflow: Webhook, Drive Photos, Sheets Score","description":"\u003ch3\u003eAuto-score new leads from your webhook—using photos + Gemini, then write results to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n Lead Scoring Workflow accepts quote requests via a POST webhook, uploads customer photos to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, logs the lead in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and uses \u003cstrong\u003eOpenRouter (Gemini)\u003c\/strong\u003e to generate a \u003cstrong\u003e0–100 lead score\u003c\/strong\u003e. The score is then written back to the matching spreadsheet row by lead ID.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives webhook requests:\u003c\/strong\u003e Accepts contact details, job info, and one or more uploaded photos via a \u003cem\u003ePOST webhook\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads photos to Google Drive:\u003c\/strong\u003e Stores the lead photos in a target Drive folder and keeps a shareable Drive link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a unique lead record:\u003c\/strong\u003e Generates a lead ID and appends a new row to Google Sheets with the lead details and the Drive photo link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares photo + context for scoring:\u003c\/strong\u003e Downloads the uploaded photo from Google Drive and packages it with the lead details for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores with Gemini via OpenRouter:\u003c\/strong\u003e Sends lead details and photo to the \u003cstrong\u003eOpenRouter-hosted Gemini model\u003c\/strong\u003e to produce a structured \u003cstrong\u003eJSON\u003c\/strong\u003e lead score from \u003cstrong\u003e0–100\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the sheet:\u003c\/strong\u003e Matches by ID and updates the existing Google Sheets row with the returned score.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReal-time lead qualification:\u003c\/strong\u003e Instantly score quote requests based on provided job details and uploaded customer photos.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSales prioritization:\u003c\/strong\u003e Use the 0–100 score to rank incoming leads in Google Sheets for faster follow-up.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePhoto-assisted estimation:\u003c\/strong\u003e Improve lead triage when photo context matters (e.g., property or project condition).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook:\u003c\/strong\u003e Receives POST requests with lead data and photos.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive:\u003c\/strong\u003e OAuth2 upload + shareable link creation; photo download for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Append lead row and update score by lead ID (columns include at minimum: \u003cem\u003eID, Full Name, Email, Phone, Address\/Location, Type of Job, Prefered Timeline, Description, Link, Score\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenRouter (Gemini via AI):\u003c\/strong\u003e Uses the model \u003cstrong\u003egoogle\/gemini-2.5-flash\u003c\/strong\u003e to produce a 0–100 structured JSON score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow stack\/nodes:\u003c\/strong\u003e set, code, webhook, google drive, google sheets, and \u003cem\u003en8n-nodes-langchainagent\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45814418309299,"sku":"N8N-18008","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/yV6yiEEeOlwJCY7koJAGQ_KpZIP5bY.png?v=1786439328","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-scoring-workflow-webhook-drive-photos-sheets-score","provider":"N8N Commerce","version":"1.0","type":"link"}