{"product_id":"solar-lead-qualification-workflow-webhook-sheets-calendar-gmail-slack","title":"Solar Lead Qualification Workflow: Webhook → Sheets, Calendar, Gmail, Slack","description":"\u003ch3\u003eTurn Solar Lead Webhooks into Booked Surveys (or Smart Manual Review) — Automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives solar leads via a \u003cstrong\u003eWebhook\u003c\/strong\u003e, validates and scores them, then updates \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. High-confidence leads get a \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e site-survey event and a booking confirmation email via \u003cstrong\u003eGmail\u003c\/strong\u003e, while lower-confidence leads are routed to \u003cstrong\u003eSlack\u003c\/strong\u003e for manual follow-up.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives lead submissions\u003c\/strong\u003e through an n8n webhook endpoint using a POST request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates data\u003c\/strong\u003e by generating a correlation ID and checking required fields such as \u003cstrong\u003econtact details, address\u003c\/strong\u003e, and \u003cstrong\u003ecommunication consent\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf required data is \u003cstrong\u003emissing or invalid\u003c\/strong\u003e, the workflow \u003cstrong\u003eposts an alert to Slack\u003c\/strong\u003e and returns an \u003cstrong\u003eerror response\u003c\/strong\u003e to the webhook caller.\u003c\/li\u003e\n  \u003cli\u003eFor valid leads, it \u003cstrong\u003ecalculates a qualification score\u003c\/strong\u003e, creates a \u003cstrong\u003ededupe key\u003c\/strong\u003e, and \u003cstrong\u003eupserts\u003c\/strong\u003e the record into the Google Sheets tab (using the dedupe key to reduce duplicates).\u003c\/li\u003e\n  \u003cli\u003eIf the score meets the \u003cstrong\u003eminimum threshold\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eCreates a \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e \u003cstrong\u003esite-survey\u003c\/strong\u003e event.\u003c\/li\u003e\n      \u003cli\u003eSends a \u003cstrong\u003eGmail\u003c\/strong\u003e confirmation email.\u003c\/li\u003e\n      \u003cli\u003eResponds to the webhook with \u003cstrong\u003e“survey_booked”\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf the score is below the threshold:\n    \u003cul\u003e\n      \u003cli\u003ePosts a \u003cstrong\u003ereview task\u003c\/strong\u003e to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eSends a review acknowledgement email via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eResponds to the webhook with \u003cstrong\u003e“manual_review”\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate qualification of solar leads from a website or lead form into a single source of truth in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003ePrevent duplicate entries using a dedupe key during Sheets upserts.\u003c\/li\u003e\n  \u003cli\u003eSpeed up booking by automatically scheduling site surveys and emailing confirmation for high-score leads.\u003c\/li\u003e\n  \u003cli\u003eRoute uncertain leads to your team via Slack for consistent manual follow-up.\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 (POST lead intake)\u003c\/li\u003e\n  \u003cli\u003eLogic nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSetup requires Google credentials for Sheets\/Calendar\/Gmail and Slack credentials in n8n, plus configuration of the \u003cstrong\u003eGoogle Sheet ID\u003c\/strong\u003e, target Slack channel, and the `minimum score` threshold (sheet tab should be named \u003cstrong\u003e“Solar leads”\u003c\/strong\u003e).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830376915123,"sku":"N8N-18251","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XhbhhgA1MDSrbyMIE4eNs_rQGPvBPU.png?v=1786698059","url":"https:\/\/buyflowscripts.com\/products\/solar-lead-qualification-workflow-webhook-sheets-calendar-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}