{"product_id":"telegram-bot-lead-capture-google-sheets-gmail-mysql","title":"Telegram Bot Lead Capture: Google Sheets + Gmail + MySQL","description":"\u003ch3\u003eCapture Telegram “Call Request” leads and instantly sync them to Google Sheets, MySQL, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow powers a button-driven Telegram bot that collects call request details from users, validates a mobile number, then logs each lead to \u003cb\u003eGoogle Sheets\u003c\/b\u003e and \u003cb\u003eMySQL\u003c\/b\u003e while sending a \u003cb\u003eGmail\u003c\/b\u003e notification to your team.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTelegram-triggered conversations:\u003c\/b\u003e The workflow starts on new Telegram messages and inline button clicks, routing users through a main menu, service sub-menus, and service detail screens.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCall Request data capture:\u003c\/b\u003e When a user taps \u003cb\u003eCall Request\u003c\/b\u003e, the bot collects \u003cb\u003ename\u003c\/b\u003e, validates a \u003cb\u003emobile number\u003c\/b\u003e, optionally captures an \u003cb\u003eemail address\u003c\/b\u003e, asks for the \u003cb\u003edesired service\u003c\/b\u003e, and can record \u003cb\u003enotes\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSave leads to Google Sheets:\u003c\/b\u003e It appends the captured lead details to a Google Sheets tab named \u003cb\u003e“Call Requests”\u003c\/b\u003e (with columns matching the appended fields).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSave leads to MySQL:\u003c\/b\u003e It inserts the same lead record into a MySQL table named \u003cb\u003ecall_requests\u003c\/b\u003e. (If you don’t need database storage, the MySQL step can be disabled.)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEmail your team via Gmail:\u003c\/b\u003e It sends a Gmail notification containing the lead details and confirms receipt back to the user inside Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCollect call-back requests for a service business directly from Telegram without manual data entry.\u003c\/li\u003e\n  \u003cli\u003eCentralize lead storage for sales or support teams using \u003cb\u003eGoogle Sheets\u003c\/b\u003e for reporting and \u003cb\u003eMySQL\u003c\/b\u003e for structured history.\u003c\/li\u003e\n  \u003cli\u003eRoute inbound Telegram leads to your team instantly with \u003cb\u003eGmail\u003c\/b\u003e alerts and confirmation messages.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTelegram:\u003c\/b\u003e Trigger on new messages + inline button interactions; maintains per-chat conversation state.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogic:\u003c\/b\u003e Uses \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eswitch\u003c\/b\u003e, and \u003cb\u003ecode\u003c\/b\u003e nodes for routing, validation, and data handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets:\u003c\/b\u003e Appends lead rows into the \u003cb\u003e“Call Requests”\u003c\/b\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail:\u003c\/b\u003e Sends team notifications with lead details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eMySQL:\u003c\/b\u003e Inserts into the \u003cb\u003ecall_requests\u003c\/b\u003e table.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123108270259,"sku":"N8N-20133","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OlyEVNXIPf5ZyhLSzByFI_ICz6X2eS.png?v=1790672587","url":"https:\/\/buyflowscripts.com\/products\/telegram-bot-lead-capture-google-sheets-gmail-mysql","provider":"N8N Commerce","version":"1.0","type":"link"}