Telegram assistant for Gmail, Calendar, Drive and Sheets

Telegram assistant for Gmail, Calendar, Drive and Sheets

An n8n workflow. Write to a Telegram bot in plain words. An AI agent on gpt-4o-mini picks a tool: it sends Gmail, adds
a Google Calendar event, searches Google through SerpApi or reaches Drive and Sheets, then answers in the chat.

What is inside

• workflow.json: the workflow as n8n exports it, 11 nodes. It holds no credential and nothing from its author's
  accounts.
• README.md: these notes.

Before you start

• An n8n instance that Telegram can reach over HTTPS, on n8n Cloud or your own server.
• A Telegram bot token from BotFather.
• An OpenAI API key.
• A SerpApi API key.
• A Google account, with OAuth2 credentials in n8n for Gmail, Google Calendar, Google Drive and Google Sheets.

Set it up

1. In n8n, create a workflow, open its menu and choose Import from File. Pick workflow.json.
2. Add a Telegram API credential with the bot token and select it in Telegram Trigger and Telegram.
3. Add an OpenAI credential and select it in OpenAI Chat Model.
4. Add a SerpApi credential with your key and select it in SerpAPI.
5. Add a Google OAuth2 credential for each of the four Google tools and select it in that tool.
6. Finish Google Calendar, Google Drive and Google Sheets as "Three tools to finish" below explains.
7. In Telegram Trigger, limit the bot to your own chat or user ID (below).
8. Save and press Publish. The trigger listens only while the workflow is published. Then message the bot.

How it works

Telegram Trigger passes the message's text to Jarvis AI Agent. The agent runs on gpt-4o-mini with a system message
that lists its tools. It decides which tool to call, and its answer goes back to the same chat through Telegram.
Simple Memory keeps the last five exchanges, and Think gives the agent a place to reason before it picks a tool.

| Tool | What the file sets | What the model fills in |
|---|---|---|
| Gmail | Send a message, as HTML | To, Subject, Message |
| Google Calendar | Create an event | The calendar's ID |
| Google Drive | Upload a file to the root of My Drive | Nothing |
| Google Sheets | Get Row(s) | The spreadsheet's ID and the sheet's ID |
| SerpAPI | A Google search | The search words |
| Think | A note the agent writes to itself | The thought |

Three tools to finish

The system message promises more than three of the tools are set to do. Each was left on its node's defaults:

• Google Calendar creates an event that starts now and ends an hour later, with no title, because only the calendar
  is left to the model. Open the node, press Let the model define this parameter beside Start and beside End, then add
  Summary under Additional Fields and do the same. For your main calendar the ID is usually your Gmail address, and you
  can type it in instead of leaving it to the model.
• Google Drive is set to Upload, which needs a file in the run. A text message carries none, so the call fails.
  Nothing here sends a file back to the chat either, so a Download would stop at n8n. Switch the node to File/Folder
  and Search, and the agent can find a file by name and tell you what it found.
• Google Sheets is set to Get Row(s), so it reads a sheet but cannot add to it. Switch it to Append Row and let the
  model fill the columns. The model needs the spreadsheet's ID and the sheet's numeric ID: name them in your message or
  type them into the node.

Keep the bot to yourself

The trigger answers every chat that finds the bot, and the agent sends mail from your Gmail. Under Telegram Trigger's
Additional Fields, Restrict to Chat IDs or Restrict to User IDs limits it to you. To find your ID, message the bot once
while you test the workflow and read message.from.id in the trigger's output.

Change the result

• Tone and rules: the system message of Jarvis AI Agent.
• The model: OpenAI Chat Model, set to gpt-4o-mini.
• How much it remembers: Context Window Length in Simple Memory, five exchanges unless you set it.
• Separate memories: Simple Memory uses the fixed key ww, so every chat shares one history. Set the key to
  {{ $('Telegram Trigger').item.json.message.chat.id }} to give each chat its own.
• The email's footer: Gmail keeps n8n's default of adding a line that says n8n sent the email. Turn off Append n8n
  Attribution under its Options.

Good to know

• No confirmation: the agent sends email and writes events the moment it decides to, without asking you first.
• Text only: the agent reads message.text, so a photo, a file or a voice note reaches it with no words.
• Long answers: Telegram takes up to 4,096 characters a message, and a longer answer fails at Telegram.
• Costs: each message is at least one gpt-4o-mini call, and each search counts against your SerpApi plan.
• Where the data goes: your messages and what the tools return go to OpenAI, and the search words go to SerpApi.
• The original copy: one pattern in Google Calendar had lost a backslash, (?:.[a-zA-Z0-9-]+) where
  (?:\.[a-zA-Z0-9-]+) was meant. This one has it back.