{"product_id":"woocommerce-telegram-ai-store-assistant-n8n-order-digests","title":"WooCommerce Telegram AI Store Assistant (n8n) + Order Digests","description":"\u003ch3\u003eChatGPT-like control for your WooCommerce ebook store—inside Telegram (with daily order digests)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you manage a WooCommerce ebook store through a Telegram bot powered by OpenRouter AI. It verifies who can chat, lets the AI fetch\/update WooCommerce orders and products, logs everything to Google Sheets, and sends daily 09:00 order digests via Telegram and email.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram chat access control:\u003c\/strong\u003e When the store owner sends a message, the workflow looks up the sender’s \u003cem\u003eTelegram chat ID\u003c\/em\u003e in a Google Sheets \u003cstrong\u003e“Allowed Users”\u003c\/strong\u003e allowlist. Unapproved users are refused access.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenRouter-powered AI assistant with per-chat memory:\u003c\/strong\u003e For approved chats, the message is sent to an OpenRouter AI agent that can maintain context for that chat.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWooCommerce actions:\u003c\/strong\u003e The agent can fetch WooCommerce orders, browse and update WooCommerce products, and append\/update an order archive in Google Sheets based on the owner’s requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomer email sending via Gmail:\u003c\/strong\u003e The agent can send customer emails (e.g., for order-related follow-ups) using Gmail based on the owner’s instructions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts and fallbacks:\u003c\/strong\u003e The agent’s reply is sent back to the owner in Telegram. If the agent returns no response, an admin is alerted in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily 09:00 order digests:\u003c\/strong\u003e Every day at \u003cstrong\u003e09:00\u003c\/strong\u003e, the workflow fetches WooCommerce orders, builds a 24-hour digest (order count, revenue, and a short list of latest orders), then sends it to the admin via Telegram and email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDigest logging:\u003c\/strong\u003e Each digest run (status, revenue, run date, and order count) is recorded in the Google Sheets \u003cstrong\u003e“Digest Log”\u003c\/strong\u003e sheet, with Telegram alerts if the digest step fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAsk the AI in Telegram: “What were today’s top orders?” or “Update this product’s details.”\u003c\/li\u003e\n  \u003cli\u003eAutomatically maintain an order archive in Google Sheets while sending order-related customer emails.\u003c\/li\u003e\n  \u003cli\u003eReceive reliable daily revenue and order summaries without manually exporting WooCommerce reports.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Telegram, WooCommerce, Google Sheets, OpenRouter, Gmail (or update to SMTP in your email node).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n node logic (as implemented):\u003c\/strong\u003e if, set, code, no op, switch, telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirement:\u003c\/strong\u003e A Google Sheets spreadsheet with \u003cstrong\u003e“Allowed Users”\u003c\/strong\u003e (chat_id column) and \u003cstrong\u003e“Digest Log”\u003c\/strong\u003e sheets, plus credentials for Telegram, WooCommerce, Google Sheets, OpenRouter, and Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978923139251,"sku":"N8N-19348","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Uoo02RnYVkFm7YP5FUXn8_pL0G4U1H.png?v=1788858929","url":"https:\/\/buyflowscripts.com\/products\/woocommerce-telegram-ai-store-assistant-n8n-order-digests","provider":"N8N Commerce","version":"1.0","type":"link"}