{"product_id":"daily-google-drive-content-queue-digest-to-telegram-n8n","title":"Daily Google Drive Content Queue Digest to Telegram (n8n)","description":"\u003ch3\u003eGet a Daily Google Drive Queue Health Digest Sent to Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your scheduled Google Drive content queue every morning, summarizes what’s next (and what’s unhealthy), and sends a ready-to-read status digest to your Telegram chat—with an optional image preview from the next post.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 8:00am\u003c\/strong\u003e and loads digest settings like \u003cem\u003etimezone\u003c\/em\u003e, \u003cem\u003elookaheadHours\u003c\/em\u003e, \u003cem\u003eunscheduled-day threshold\u003c\/em\u003e, \u003cem\u003eenableImagePreview\u003c\/em\u003e, and your \u003cem\u003eTelegram chat ID\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScans Google Drive\u003c\/strong\u003e by listing all queue folders inside your selected parent “content queue” folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses scheduled timestamps\u003c\/strong\u003e from folder names and calculates:\n    \u003cul\u003e\n      \u003cli\u003ethe \u003cstrong\u003enext scheduled post\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ethe \u003cstrong\u003enext 24 hours lineup\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eflags for \u003cstrong\u003einvalid folder names\u003c\/strong\u003e and \u003cstrong\u003eunscheduled days\u003c\/strong\u003e based on your threshold\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInspects the next scheduled post folder\u003c\/strong\u003e to check for images and a caption file, then compiles the digest text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the digest to Telegram\u003c\/strong\u003e to keep your team updated without opening Drive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional image preview:\u003c\/strong\u003e if enabled and an image exists, it downloads the first image from Google Drive and sends it to Telegram as a photo with a caption.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators tracking scheduled content production from a Google Drive-based queue.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers monitoring whether the queue is staying “on schedule” and spotting invalid\/missing folders early.\u003c\/li\u003e\n  \u003cli\u003eContent teams using Telegram as a lightweight daily operations channel for next-post and next-24-hours planning.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e Google Drive, Telegram, Code, If, Set, Sticky Note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueue folder naming requirement:\u003c\/strong\u003e \u003ccode\u003eYYYY-MM-DD_HHMM__slug\u003c\/code\u003e so timestamps can be parsed correctly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e add Google Drive credentials + set the parent content queue folder ID; add Telegram credentials + configure the target chat ID; adjust \u003cem\u003etimezone\u003c\/em\u003e, \u003cem\u003elookaheadHours\u003c\/em\u003e, \u003cem\u003eunscheduledThresholdDays\u003c\/em\u003e, and \u003cem\u003eenableImagePreview\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850683343027,"sku":"N8N-18124","price":48.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/eFa_5s7kcxc79RKXrr7eD_GWtLU1fe.png?v=1786871417","url":"https:\/\/buyflowscripts.com\/products\/daily-google-drive-content-queue-digest-to-telegram-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}