{"product_id":"n8n-workflow-project-intake-webhook-to-google-sheets-gmail","title":"n8n Workflow: Project Intake Webhook to Google Sheets \u0026 Gmail","description":"\u003ch3\u003eTurn project intake into a tracked sheet + instant email confirmation—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow accepts incoming project intake requests via a \u003cstrong\u003eWebhook\u003c\/strong\u003e, validates and normalizes the data, logs each request to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a confirmation email through \u003cstrong\u003eGmail\u003c\/strong\u003e—returning a clear JSON success or error response to the caller.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a POST request\u003c\/strong\u003e on a webhook endpoint (or runs with a manual test payload).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes \u0026amp; validates fields\u003c\/strong\u003e, including \u003cstrong\u003eemail format\u003c\/strong\u003e, and generates a unique \u003cstrong\u003eproject reference ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles invalid submissions\u003c\/strong\u003e by returning a \u003cstrong\u003eJSON error response\u003c\/strong\u003e that lists missing or invalid fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs valid requests\u003c\/strong\u003e by appending project details to a Google Sheets document in the \u003cstrong\u003e“Projects”\u003c\/strong\u003e sheet (with mapped columns such as project_id, client_name, email, project_name, project_type, deadline, received_at, status).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an acknowledgement email\u003c\/strong\u003e via Gmail to the client, including the project name and generated reference ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a JSON success response\u003c\/strong\u003e containing the generated project ID.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA SaaS landing form submits project details and needs immediate confirmation plus internal tracking.\u003c\/li\u003e\n  \u003cli\u003eAn automation engineer wants a reliable \u003cstrong\u003eproject intake webhook → Google Sheets CRM log\u003c\/strong\u003e pattern.\u003c\/li\u003e\n  \u003cli\u003eA small agency captures requests from a website and emails clients with their unique reference ID.\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 endpoint configuration: path \u003cstrong\u003ebe-free-intake\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e and \u003cstrong\u003ecode\u003c\/strong\u003e nodes for validation\/normalization and project reference generation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration to append into the \u003cstrong\u003eProjects\u003c\/strong\u003e sheet\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e node to send the acknowledgement email (with verified sender permissions)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky note\u003c\/strong\u003e for workflow documentation\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Add Google Sheets OAuth credentials (replace \u003cem\u003eYOUR_GOOGLE_SHEET_ID\u003c\/em\u003e) and ensure your “Projects” sheet columns match the mapped fields, then add Gmail credentials to enable email delivery.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761004863667,"sku":"N8N-17831","price":30.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/z2cdYIgYHgDYd445fvlH0_QcQ50Ggo.png?v=1785920935","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-project-intake-webhook-to-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}