Subscription tracker & reminders with GPT-4 nano, Telegram & Google Sheets
Needs changesWhat this workflow does
This AI workflow has 18 nodes and runs on Telegram events (message) (plus 2 other triggers). Along the way it connects OpenAI Chat Model, Telegram, Google Sheets and SerpApi (Google Search) and 1 more.
How it runs
Trigger: On Telegram events (message) (plus 2 other triggers).
- Smart Bill Manager (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 4 tools (SerpAPI, Calculator, Get row(s) in sheet in Google Sheets, Append or update row in sheet in Google Sheets); memory: Window Buffer Memory
- Send a chat action (Telegram): send chat action
- Read Subscriptions (Google Sheets): uses Google Sheets
- Format Response (Edit Fields (Set)): sets 1 field: response
- Any Subscriptions Due? (If): checks a condition and branches into true / false
- Send Telegram Response (Telegram): uses Telegram
- Aggregate: combines items into one
- Message a model (OpenAI): uses OpenAI
- Send Telegram Response (Telegram): uses Telegram
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- SerpApi (Google Search) in SerpAPI: no direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| SerpApi (Google Search) SerpAPI | No direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node |
Nodes used (15)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Edit Fields (Set)
n8n-nodes-base.set - Telegram
n8n-nodes-base.telegram - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - SerpApi (Google Search)
@n8n/n8n-nodes-langchain.toolSerpApi - Manual Trigger
n8n-nodes-base.manualTrigger - OpenAI
@n8n/n8n-nodes-langchain.openAi - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - Telegram Trigger
n8n-nodes-base.telegramTrigger
From the author
This workflow manages subscription billing reminders and data updates via Telegram. It runs daily at 8:00 AM to check for upcoming due subscriptions, formats relevant information, and sends reminders to users. It also processes user messages for subscription…