{"product_id":"n8n-gmail-leads-google-sheets-internal-email-alerts","title":"n8n Gmail Leads → Google Sheets + Internal Email Alerts","description":"\u003ch3\u003eAutomatically capture Gmail leads into Google Sheets—with instant internal email alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your \u003cb\u003eGmail\u003c\/b\u003e for new lead\/contact\/inquiry messages, extracts key details, logs them into \u003cb\u003eGoogle Sheets\u003c\/b\u003e, and sends an \u003cb\u003einternal notification\u003c\/b\u003e email so your team can respond fast.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003ePolls Gmail every minute\u003c\/b\u003e and searches for messages newer than one day using a lead-related subject query (e.g., lead\/contact\/inquiry terms).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts lead data\u003c\/b\u003e from each matching email, including:\n    \u003cul\u003e\n      \u003cli\u003eReceived time\u003c\/li\u003e\n      \u003cli\u003eSender name\u003c\/li\u003e\n      \u003cli\u003eSender email\u003c\/li\u003e\n      \u003cli\u003eSubject\u003c\/li\u003e\n      \u003cli\u003eA cleaned message snippet\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends a new row\u003c\/b\u003e to a Google Sheets spreadsheet (default sheet name: \u003cb\u003eLeads\u003c\/b\u003e) with the captured fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends an internal notification email\u003c\/b\u003e via Gmail using the same extracted lead details (e.g., to \u003ccode\u003eyour-team@example.com\u003c\/code\u003e or your team’s address).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eSaaS lead tracking:\u003c\/b\u003e Automatically log inbound demo requests and contact inquiries without manually copying emails into a CRM sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSupport-to-sales routing:\u003c\/b\u003e Capture sales-oriented messages (based on subject terms) and alert your internal owners immediately.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSmall team visibility:\u003c\/b\u003e Keep your \u003cb\u003eGoogle Sheets\u003c\/b\u003e updated while ensuring key leads are surfaced via internal Gmail notifications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail integration\u003c\/b\u003e (OAuth2): reads new messages and sends internal alert emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets integration\u003c\/b\u003e (OAuth2): appends lead rows to the target spreadsheet and sheet tab (default: \u003cb\u003eLeads\u003c\/b\u003e).\u003c\/li\u003e\n  \u003cli\u003eUses n8n nodes including \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003eswitch\u003c\/b\u003e, and \u003cb\u003esticky note\u003c\/b\u003e to control logic, formatting, and data extraction.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSetup tip:\u003c\/b\u003e Create the \u003ccode\u003eLeads\u003c\/code\u003e sheet with columns like \u003cb\u003eReceived At\u003c\/b\u003e, \u003cb\u003eName\u003c\/b\u003e, \u003cb\u003eEmail\u003c\/b\u003e, \u003cb\u003eFrom\u003c\/b\u003e, \u003cb\u003eSubject\u003c\/b\u003e, \u003cb\u003eMessage\u003c\/b\u003e, and \u003cb\u003eSource\u003c\/b\u003e (or align mappings to your headers), then update the Gmail search query and notification recipient.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865772482739,"sku":"N8N-18342","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EHd0INLqJ44Ouc2zkjR_r_mRICU8hW.png?v=1787045010","url":"https:\/\/buyflowscripts.com\/products\/n8n-gmail-leads-google-sheets-internal-email-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}