Automated Google Sheets to Telegram: Daily Digest Workflow

Never miss important daily updates again! This n8n workflow automatically transforms your Google Sheets data into clean, formatted Telegram messages delivered straight to your chat every morning at 9:00 AM.

What this workflow does

This automated daily digest system seamlessly connects Google Sheets with Telegram to keep you informed:

• Automatically runs every morning at 9:00 AM without manual intervention
• Reads all rows from your specified Google Sheet
• Intelligently filters only today's entries using your Date column
• Formats filtered data into a clean, numbered digest message
• Sends the summary directly to your Telegram chat or channel
• Gracefully handles empty days with separate notifications, so you're never left wondering

Perfect use cases

This Google Sheets to Telegram automation workflow is ideal for:

• Daily task summaries and project status updates for remote teams
• Sales pipeline notifications and lead tracking digests
• Event schedules and appointment reminders
• Content publishing calendars and social media planning
• Customer support ticket summaries and priority alerts
• Inventory updates and stock level monitoring

Technical details

Built with essential n8n nodes for reliable automation:

• Google Sheets - OAuth2 integration for secure data access
• Telegram - Bot API for message delivery to chats or channels
• If/Set/Code nodes - Smart filtering and message formatting logic
• Sticky Note - Clear documentation for easy maintenance

Setup takes just 10 minutes: connect your Google Sheets OAuth2 credentials, configure your Spreadsheet ID, ensure your Date column uses YYYY-MM-DD format, create a Telegram bot via @BotFather, set your Chat ID, and activate. Your automated daily digest workflow will handle the rest, delivering consistent morning updates that keep your team informed and organized.