This n8n automation lets you build a complete AI-powered task management system that integrates Telegram, Google Sheets, and GPT-4o mini to help users easily manage to-do lists and receive daily task reminders.
Users can interact with the system via Telegram, while the AI assistant (powered by GPT-4o mini) processes commands naturally, updates a central Google Sheet, and ensures scheduled reminders are sent for pending tasks.
✅ Add, list, update, complete, or delete tasks via Telegram
✅ AI-powered conversational responses using GPT-4o
✅ All tasks stored and synced in Google Sheets
✅ Daily scheduled task summary and pending reminders sent to Telegram
✅ Friendly, human-like assistant responses
✅ Fully configurable and easy to set up
Sends commands like:
add buy groceries
list tasks
complete submit report
delete dentist appointment
Every operation is logged to Google Sheets
Google Sheets acts as the master task database
Sheet structure includes:
Task
Status
(pending
or done
)Created At
(timestamp)Due Date
(optional)Notes
(optional)At 9 PM daily, the workflow:
Before setting up the workflow, ensure you have:
✔️ An n8n instance (Cloud or self-hosted)
✔️ A Telegram Bot Token
✔️ Access to Google Sheets API (OAuth2 credentials)
✔️ An OpenAI API Key with GPT-4o access
✔️ A Google Sheet structured as per the specification below
Your Google Sheet should have the following columns:
Column Name | Description |
---|---|
Task | Short task description |
Status | pending or done |
Created At | Date & time task was created (YYYY-MM-DD HH:mm:ss ) |
Due Date | (Optional) When task is due (YYYY-MM-DD HH:mm:ss ) |
Notes | (Optional) Additional details |
Important: The first row should be the header row with these exact column names.
Schedule Trigger
node) as desiredReady to stay organized with AI-powered task management?
Import this workflow, link your accounts, and your Telegram assistant is good to go! 🚀