Automation library · Scheduling

Manage tasks, email & calendar with OpenAI and Gmail

Started by an incoming Telegram message, and works across Gmail, Google Calendar, Google Sheets and Telegram. It puts OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 27 steps, 1 branch: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAIRetrieval

27 stepsLarge: read it before trusting it with anything live
1Branch: places the flow splits
0Loops or waits
4Services it connects to

The flow

Starts it 2Model 4Logic 7Service 14

The steps in the order they run, from what starts it.

  1. 1Read Unread EmailsGmail ToolService
  2. 2Send EmailGmail ToolService
  3. 3Create Calendar EventGoogle Calendar ToolService
  4. 4Read Calendar EventsGoogle Calendar ToolService
  5. 5Delete Calendar EventGoogle Calendar ToolService
  6. 6Read Task SheetGoogle Sheets ToolService
  7. 7Add New TaskGoogle Sheets ToolService
  8. 8Update Task StatusGoogle Sheets ToolService
  9. 9Conversation MemoryMemory Buffer WindowModel
  10. 1030-Minute Reminder TimerSchedule triggerStarts it
  11. 11OpenAI Language ModelLm Chat Open AiModel
  12. 12Telegram Bot TriggerTelegram triggerStarts it
  13. 13AI Personal AssistantAgentModel
  14. 14Read Task DataGoogle SheetsService
  15. 15Store User Chat IDCodeLogic
  16. 16Prevent Duplicate ResponsesCodeLogic
  17. 17Filter Due TasksCodeLogic
  18. 18Route Text or Voice MessagesSwitchLogic
  19. 19Send Response to UserTelegramService
  20. 20Format Reminder MessageCodeLogic
  21. 21Extract Text MessageSetLogic
  22. 22Get Voice File from TelegramTelegramService
  23. 23Send Task ReminderTelegramService
  24. 24Merge Text and Voice InputSetLogic
  25. 25Download Voice FileHttp RequestService
  26. 26Mark Reminder SentGoogle SheetsService
  27. 27Transcribe Voice to TextOpen AiModel

How it's built

Starts on
An incoming Telegram message
Steps
27, with 1 branch
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Calendar, Google Sheets, Telegram
Model
OpenAI
Retrieval
Answers are drawn from documents you supply, not from the model alone

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Calendar, Google Sheets and Telegram accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an incoming Telegram message.

Does it use AI?

Yes. It calls OpenAI. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 27 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 27 steps before you point it at anything that matters.