{"product_id":"n8n-workflow-automate-google-business-posts-with-gemini-telegram","title":"n8n Workflow: Automate Google Business Posts with Gemini + Telegram","description":"\u003ch3\u003eAutomate Weekly Google Business Posts—Drafted by Gemini and Approved in Telegram\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e builds a client knowledge base from a website, stores it in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e\/\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and then generates \u003cstrong\u003eweekly Google Business Profile (GBP)\u003c\/strong\u003e content using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e. Each draft is sent to \u003cstrong\u003eTelegram\u003c\/strong\u003e for \u003cstrong\u003eApprove\/Veto\u003c\/strong\u003e, so your system improves by learning from veto feedback.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOne-time manual setup:\u003c\/strong\u003e creates a “Google Business Scaler” folder in Google Drive and a multi-tab Google Sheets database file (“Google Business Scaler — Database”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOnboard new clients:\u003c\/strong\u003e accepts submissions via an \u003cstrong\u003en8n Form\u003c\/strong\u003e, crawls the client website (checks \u003cstrong\u003erobots.txt\u003c\/strong\u003e, uses \u003cstrong\u003esitemap\u003c\/strong\u003e, and targets key pages), and compiles cleaned text for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuild a Gemini-ready knowledge base:\u003c\/strong\u003e uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to synthesize tone, differentiators, audience, forbidden claims, and services—saving results into the \u003cstrong\u003eClients\u003c\/strong\u003e, \u003cstrong\u003eIdentity\u003c\/strong\u003e, and \u003cstrong\u003eServices\u003c\/strong\u003e tabs. The client’s \u003cstrong\u003eTelegram\u003c\/strong\u003e chat is notified.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly content generation:\u003c\/strong\u003e runs every Monday at \u003cstrong\u003e8am\u003c\/strong\u003e, reads active client rows (services, photos, promos, history, identity, and learnings), then selects one content item per client via a priority cascade.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrite, log, and track:\u003c\/strong\u003e Gemini writes the chosen piece (promo post, photo caption, update post, or service description). It logs drafts to the \u003cstrong\u003eHistory\u003c\/strong\u003e tab and marks photos as used when applicable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApproval loop (human-in-the-loop):\u003c\/strong\u003e sends the draft to Telegram with \u003cstrong\u003eApprove\/Veto\u003c\/strong\u003e buttons (or auto-approves for autopilot clients) and updates status in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLearn from vetoes:\u003c\/strong\u003e when vetoed in Telegram, Gemini distills checkable writing rules based on the feedback.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators managing GBP posting for multiple clients with consistent tone and compliance\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a Gemini + Telegram review workflow for content production\u003c\/li\u003e\n  \u003cli\u003eAgencies that want drafts generated weekly, with approvals handled in Telegram\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/integration elements:\u003c\/strong\u003e if, code, no op, webhook, telegram, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle assets:\u003c\/strong\u003e Google Sheets (multi-tab database) and Google Drive (client assets)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI generation:\u003c\/strong\u003e Google Gemini for knowledge base synthesis and GBP writing\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApproval interface:\u003c\/strong\u003e Telegram with Approve\/Veto controls and status updates\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45889874002099,"sku":"N8N-18596","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9WL2UT6gdZ-oHTXpV0r7_lPF5DHRs.png?v=1787498877","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-automate-google-business-posts-with-gemini-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}