n8n Lead Scoring Workflow: Webhook, Drive Photos, Sheets Score

Auto-score new leads from your webhook—using photos + Gemini, then write results to Google Sheets

This n8n Lead Scoring Workflow accepts quote requests via a POST webhook, uploads customer photos to Google Drive, logs the lead in Google Sheets, and uses OpenRouter (Gemini) to generate a 0–100 lead score. The score is then written back to the matching spreadsheet row by lead ID.

What this workflow does

• Receives webhook requests: Accepts contact details, job info, and one or more uploaded photos via a POST webhook.
• Uploads photos to Google Drive: Stores the lead photos in a target Drive folder and keeps a shareable Drive link.
• Creates a unique lead record: Generates a lead ID and appends a new row to Google Sheets with the lead details and the Drive photo link.
• Prepares photo + context for scoring: Downloads the uploaded photo from Google Drive and packages it with the lead details for analysis.
• Scores with Gemini via OpenRouter: Sends lead details and photo to the OpenRouter-hosted Gemini model to produce a structured JSON lead score from 0–100.
• Updates the sheet: Matches by ID and updates the existing Google Sheets row with the returned score.

Use cases

• Real-time lead qualification: Instantly score quote requests based on provided job details and uploaded customer photos.
• Sales prioritization: Use the 0–100 score to rank incoming leads in Google Sheets for faster follow-up.
• Photo-assisted estimation: Improve lead triage when photo context matters (e.g., property or project condition).

Technical details

• Webhook: Receives POST requests with lead data and photos.
• Google Drive: OAuth2 upload + shareable link creation; photo download for analysis.
• Google Sheets: Append lead row and update score by lead ID (columns include at minimum: ID, Full Name, Email, Phone, Address/Location, Type of Job, Prefered Timeline, Description, Link, Score).
• OpenRouter (Gemini via AI): Uses the model google/gemini-2.5-flash to produce a 0–100 structured JSON score.
• Workflow stack/nodes: set, code, webhook, google drive, google sheets, and n8n-nodes-langchainagent.