Manage personal data with multiple GPT-4o AI agents: Gmail, Tasks & Finance on Telegram
## Overview
Automate your personal productivity with this intelligent n8n workflow that integrates **Telegram**, **Google Sheets**, and **OpenAI (GPT-4o)**. This system uses multiple AI agents to manage work hours, tasks, finances, and emails—all through natural language commands sent via Telegram. Every action is synced to Google Sheets for persistent, structured data storage.
---
## What This Template Does
This automation system deploys several specialized AI agents:
- **📊 Work Hours Analyzer**: Analyzes work logs from Google Sheets, calculates total hours by workplace, and generates detailed monthly reports in Arabic.
- **🛠️ Work Tracking Agent**: Handles start/end work commands, calculates total hours, and updates Google Sheets.
- **📋 Task Manager Agent**: Manages to-do lists—adding, listing, updating, completing, and deleting tasks—with real-time sync to Google Sheets.
- **💰 Finance Agent**: Tracks income and expenses in multiple currencies, summarizes daily financial activity, and maintains a full transaction history.
- **📧 Email Analysis Agent**: Processes incoming Gmail messages, generates AI-powered summaries in Arabic with priority, sentiment, and recommended actions.
- **📅 Monthly Report Generator**: Automatically triggers at the start of each month to compile a professional PDF report of work hours and sends it to a Telegram topic.
---
## Prerequisites & Setup
### Required Accounts & API Keys
Before setup, ensure you have:
1. **Telegram Bot Token** – from @BotFather
2. **OpenAI API Key** – with access to `gpt-4o-mini` or `gpt-3.5-turbo`
3. **Google Sheets API** – OAuth2 credentials enabled
4. **Gmail Account (Optional)** – for email analysis
5. **n8n Instance** – self-hosted or cloud
---
### Google Sheets Structure
Create a Google Sheet with the following sheets and columns:
#### Sheet: `work`
- Date
- start at
- end at
- place
- note
- Total hours
#### Sheet: `task`
- Task
- Status
- Created At
- Due Date
- Notes
#### Sheet: `Expenses`
- id
- Amount
- Currency
- Note
- Type (debit/credit)
- Date
- Time
#### Sheet: `email`
- name
- email
---
## Step-by-Step Setup
### Step 1: Import the Workflow
1. In n8n, go to **Workflows > Import from file**
2. Upload the JSON template
3. Open the canvas and verify all nodes are connected
### Step 2: Configure Credentials
1. **Telegram**: Add your bot token under "Telegram account"
2. **OpenAI**: Enter your API key in "OpenAi account"
3. **Google Sheets**: Connect using OAuth2 under "Google Sheets account"
4. **Gmail (Optional)**: Set up if using email analysis
### Step 3: Link Google Sheets
1. Share your Google Sheet with the service account email (if using service account)
2. Copy the **Document ID** from the sheet URL
3. Update all Google Sheets nodes with the correct sheet names and IDs
4. Ensure column names match exactly
### Step 4: Set Up Telegram
1. Start a chat with your bot
2. Use `/start` to initialize
3. Ensure `chatId` and `message_thread_id` in Telegram nodes match your group/topic
4. Test sending a message like "Start work at the factory"
### Step 5: Test the Agents
Try these sample commands via Telegram:
- "Start work at the factory" → Logs start time
- "Finished work" → Logs end time and calculates hours
- "Add task: pay the bill" → Adds a new task
- "How much did I spend today?" → Shows today’s expenses
- "Send last month's report" → Triggers monthly PDF report (on the first of the month)
---
## Key Features
### Smart Work Tracking
- Automatic time calculation
- Query by date, place, or period
- Real-time Google Sheets sync
### Task Management
- Add, list, update, complete, delete tasks
- Friendly, conversational responses
- Daily summaries of completed and upcoming tasks
### Financial Tracking
- Supports multiple currencies (JOD, USD, ILS, etc.)
- Daily income/expense summaries
- Full transaction history
- Arabic-language responses
### Email Intelligence
- AI-powered email summaries
- Priority, sentiment, and action recommendations
- Plain-text output in Arabic
- No JSON or code blocks
### Automated Monthly Reports
- Triggered on the 1st of each month
- Generates detailed work hour reports by workplace
- Outputs clean, formatted PDF
- Sends directly to Telegram topic
---
## Customization Options
### Modify AI Prompts
Edit the `systemMessage` in any AI agent node to:
- Change tone (formal, friendly, concise)
- Add new response formats
- Support additional commands or languages
### Extend Functionality
- Add **daily reminders** using Schedule Trigger
- Implement **budget alerts** when expenses exceed a threshold
- Add **weekly summaries** for tasks or work hours
- Support **multi-currency conversion**
### Enhance Telegram Interaction
- Add **inline buttons** for quick actions
- Create **shortcuts** like `/work`, `/tasks`, `/finance`
- Use **message_thread_id** to organize topics
---
## Troubleshooting
| Issue | Solution |
|------|----------|
| Bot not responding | Check webhook URL, bot token, and `chatId` |
| Google Sheets not updating | Verify OAuth2 permissions and sheet sharing |
| AI not understanding commands | Review prompt clarity and test input phrasing |
| Monthly report not sending | Confirm `Schedule Trigger` timezone and execution time |
---
## Benefits
✅ **Full automation** with minimal user input
📱 **Control everything from Telegram**
📊 **Data stored securely in Google Sheets**
📄 **Professional PDF reports generated automatically**
💬 **Natural, friendly Arabic responses**
🔁 **Seamless sync across all components**
This template transforms personal productivity by combining AI intelligence with powerful automation—turning simple Telegram messages into structured data, actionable insights, and professional reports.
