January 22, 2026

Telegram + Google Sheets: never miss renewals

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Subscription renewals have a nasty habit of showing up at the worst time. One missed date turns into a surprise charge, an awkward “why is this on the card?” moment, and a scramble to cancel something you did not even want anymore.

This hits marketing leads managing tool sprawl, but small business owners and agency ops feel it too. With Telegram renewals automation, you get a simple system that checks your sheet every morning and nudges you before money leaves your account.

You will see how the workflow tracks subscriptions in Google Sheets, sends Telegram reminders, and even lets you update records by chatting with a bot. No more “I’ll remember.”

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Telegram + Google Sheets: never miss renewals

Click to explore

flowchart LR

    subgraph sg0["Telegram Message Received Flow"]
        direction LR
        n0@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n1@{ icon: "mdi:memory", form: "rounded", label: "Window Buffer Memory", pos: "b", h: 48 }
        n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Format Response", pos: "b", h: 48 }
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Send Telegram Response"]
        n7@{ icon: "mdi:database", form: "rounded", label: "Get row(s) in sheet in Googl..", pos: "b", h: 48 }
        n8@{ icon: "mdi:wrench", form: "rounded", label: "Calculator", pos: "b", h: 48 }
        n9@{ icon: "mdi:wrench", form: "rounded", label: "SerpAPI", pos: "b", h: 48 }
        n14@{ icon: "mdi:robot", form: "rounded", label: "Smart Bill Manager", pos: "b", h: 48 }
        n15@{ icon: "mdi:database", form: "rounded", label: "Append or update row in shee..", pos: "b", h: 48 }
        n16["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Telegram Message Received"]
        n17["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Send a chat action"]
        n9 -.-> n14
        n8 -.-> n14
        n2 --> n3
        n0 -.-> n14
        n14 --> n2
        n1 -.-> n14
        n16 --> n14
        n16 --> n17
        n7 -.-> n14
        n15 -.-> n14
    end

    subgraph sg1["Daily 8AM Check Flow"]
        direction LR
        n4@{ icon: "mdi:play-circle", form: "rounded", label: "Daily 8AM Check", pos: "b", h: 48 }
        n5@{ icon: "mdi:database", form: "rounded", label: "Read Subscriptions", pos: "b", h: 48 }
        n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Any Subscriptions Due?", pos: "b", h: 48 }
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Send Telegram Response1"]
        n11@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Execute workf..", pos: "b", h: 48 }
        n12@{ icon: "mdi:robot", form: "rounded", label: "Message a model", pos: "b", h: 48 }
        n13@{ icon: "mdi:cog", form: "rounded", label: "Aggregate", pos: "b", h: 48 }
        n13 --> n12
        n4 --> n5
        n12 --> n10
        n5 --> n6
        n6 --> n13
        n11 --> n5
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n16,n4,n11 trigger
    class n14,n12 ai
    class n0 aiModel
    class n8,n9 ai
    class n1 ai
    class n6 decision
    class n7,n15,n5 database
    classDef customIcon fill:none,stroke:none
    class n3,n16,n17,n10 customIcon

The Problem: Subscription renewals get missed (and it costs you)

Most teams track subscriptions in the messiest way possible: a few receipts in email, a card statement, maybe a spreadsheet that was “temporary” six months ago. Then renewals arrive. Somebody pays for another month of a tool no one uses, or worse, a critical service lapses because the card changed and nobody noticed. The real cost isn’t just the charge. It’s the mental load of constantly remembering dates, chasing invoices, and asking “who owns this?” when finance flags it.

It adds up fast. Here’s where it breaks down in real life:

You spend about 30 minutes hunting renewal dates every time budgeting comes up.
Manual reminders live in someone’s calendar, so coverage disappears when that person is out.
Sheet updates happen late (or never), which means your “monthly tools cost” is always a guess.
When a renewal is missed, the cleanup takes longer than the tracking ever should have.

The Solution: Daily Google Sheets checks + Telegram reminders (with chat-based updates)

This n8n workflow turns your Google Sheet into a living subscription system, with Telegram doing the nagging for you. Every day at 8:00 AM, it pulls your subscription list from Google Sheets, checks what’s coming due, formats the key details (service name, amount, due date, owner, notes), and sends a clean reminder message in Telegram. On top of that, it handles inbound Telegram messages so you can add, update, or look up subscription info by typing normally. The AI layer (OpenAI model + an agent with short-term memory) translates your message into a structured update, then upserts the right row back into Google Sheets.

The workflow starts with a morning schedule trigger that scans your sheet automatically. When something is due soon, it compiles the relevant rows and sends Telegram alerts. If you message the bot (“add Canva renewal on the 3rd, $15, marketing card”), it interprets the request and updates the sheet without you opening a tab.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It checks your Google Sheets subscription list every morning at 8:00 AM.
It detects upcoming renewals using simple due-date logic before you’re charged.
It sends formatted Telegram reminders so you don’t need to open the sheet.
It lets you manage subscriptions through Telegram messages, then writes updates back to Google Sheets.

Save about 5 hours a week you’d spend tracking, confirming, and reminding.
Fewer surprise charges, because renewal dates stop living “in someone’s head.”
Cleaner data for budgeting, since the sheet stays current without nagging people.
Fewer manual entry mistakes, especially on dates and amounts.
Room to scale your subscription list without adding admin work.

Example: What This Looks Like

Say you manage 25 active subscriptions. Manually, even a quick weekly check can take about 10 minutes per subscription to confirm dates, owners, and amounts, which is roughly 4 hours a week once you include context switching. With this workflow, the daily scan and reminder run in under a minute, and updates happen in a single Telegram message that takes maybe 30 seconds. That’s how teams get back around 5 hours weekly, without “getting better at spreadsheets.”

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for your subscription database.
Telegram bot to send reminders and accept commands.
OpenAI API key (get it from your OpenAI dashboard).

Skill level: Intermediate. You’ll connect accounts, paste a few credentials, and test with real Telegram messages.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A daily schedule kicks things off. At 8:00 AM, n8n runs automatically and pulls your subscription rows from Google Sheets. You can also run it manually if you’re testing.

Upcoming renewals get identified. An “upcoming dues” check filters the list down to the subscriptions that need attention soon, then compiles those rows into a message-friendly payload.

AI helps with human messages. If you DM the bot to add or change a subscription, the AI agent uses an OpenAI chat model plus session memory to understand intent, calculate or validate fields when needed, and prepare a clean update.

Telegram gets the final output. For reminders, it sends an alert to Telegram. For management requests, it replies with confirmation and writes the upsert back into Google Sheets so your source of truth stays accurate.

You can easily modify reminder timing to match your billing cycle based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Schedule Trigger

Set the daily trigger that checks the subscription sheet for upcoming dues and builds the reminder message.

Add the Morning Schedule Trigger node.
Set the schedule rule to the cron expression 0 8 * * * to run at 8:00 AM daily.
Connect Morning Schedule Trigger to Retrieve Subscription Sheet.
Optionally keep Manual Start Trigger connected to Retrieve Subscription Sheet for testing.

Step 2: Connect Google Sheets

Configure all Google Sheets nodes that read, look up, and update subscription data.

Open Retrieve Subscription Sheet and select the spreadsheet [YOUR_ID] and sheet Dashboard.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Subscription Sheet.
Open Lookup Sheet Rows and confirm the filters use the AI expressions, such as {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values0_Value', ``, 'string') }} for the Bill Name lookup.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Lookup Sheet Rows.
Open Upsert Sheet Records and confirm Operation is set to appendOrUpdate, spreadsheet [YOUR_ID], and sheet Raw Data.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Upsert Sheet Records.

⚠️ Common Pitfall: Replace all [YOUR_ID] placeholders with your actual Google Sheet document ID and the correct sheet names, or the workflow will return empty data.

Step 3: Build the Due-Date Filtering and Aggregation Path

Filter rows that are due soon, aggregate them, and generate a structured prompt for Telegram alerts.

In Check Upcoming Dues, set the condition to Due In ≤ 3 using {{ $('Retrieve Subscription Sheet').item.json['Due In'] }}.
Connect Retrieve Subscription Sheet → Check Upcoming Dues → Compile Items.
In Compile Items, set Aggregate to aggregateAllItemData.
Connect Compile Items to Compose Model Prompt.
In Compose Model Prompt, keep JSON Output enabled and ensure the user message content uses {{ JSON.stringify($json.data) }}.
Credential Required: Connect your openAiApi credentials in Compose Model Prompt.

Step 4: Configure the Telegram Alert Output

Send the AI-generated reminder message to Telegram when dues are coming soon.

Connect Compose Model Prompt to Send Telegram Alert.
In Send Telegram Alert, set Text to {{ $json.message.content.message }}.
Set Chat ID to your recipient or group ID using {{ '[YOUR_ID]' }}.
Credential Required: Connect your telegramApi credentials in Send Telegram Alert.

⚠️ Common Pitfall: Replace [YOUR_ID] with the correct Telegram chat ID, or the alert will fail.

Step 5: Set Up the Telegram Conversation Flow

Handle incoming Telegram messages and reply with structured subscription management responses.

Add Telegram Incoming Message and configure it to listen for message updates.
Credential Required: Connect your telegramApi credentials in Telegram Incoming Message.
Confirm the parallel execution: Telegram Incoming Message outputs to both Subscription AI Manager and Telegram Typing Action in parallel.
In Telegram Typing Action, set Operation to sendChatAction and Chat ID to {{ $('Telegram Incoming Message').item.json.message.chat.id }}.
Credential Required: Connect your telegramApi credentials in Telegram Typing Action.

Step 6: Set Up the AI Orchestration and Tools

Configure the AI agent, language model, memory, and tools that interpret messages and update Google Sheets.

Open Subscription AI Manager and set Text to {{ $json.message.text }} with Prompt Type set to define.
Ensure AI Chat Engine is connected as the language model for Subscription AI Manager and uses the model gpt-4.1-nano.
Credential Required: Connect your openAiApi credentials in AI Chat Engine (credentials are added to the parent language model node, not the agent).
Attach Session Memory Window to Subscription AI Manager and keep the session key {{ $('Telegram Incoming Message').item.json.message.from.id }} for user-specific memory.
Connect the AI tools: Lookup Sheet Rows, Upsert Sheet Records, Math Utility, and Search Web Tool as AI tools for Subscription AI Manager.
Credential Required: Connect your serpApi credentials in Search Web Tool (tool credentials are configured on the tool node, but used by the parent agent).

AI tool nodes like Session Memory Window, Lookup Sheet Rows, Math Utility, Search Web Tool, and Upsert Sheet Records operate under Subscription AI Manager. Ensure the agent is connected to these tools so it can call them during conversations.

Step 7: Configure the Telegram Reply Output

Shape the AI response and send it back to the user in Telegram.

Connect Subscription AI Manager to Shape Reply Payload.
In Shape Reply Payload, set the response field to {{ $json.output }}.
Connect Shape Reply Payload to Dispatch Telegram Reply.
In Dispatch Telegram Reply, set Text to {{ $json.response }} and Chat ID to {{ $('Telegram Incoming Message').item.json.message.chat.id }}.
Credential Required: Connect your telegramApi credentials in Dispatch Telegram Reply.

Step 8: Test and Activate Your Workflow

Validate that both the scheduled reminders and the Telegram conversation flow work end-to-end.

Click Execute Workflow and use Manual Start Trigger to simulate a scheduled run.
Confirm that Retrieve Subscription Sheet returns rows, Check Upcoming Dues filters items, and Send Telegram Alert posts a formatted message.
Send a message to your bot to trigger Telegram Incoming Message and verify that Telegram Typing Action shows typing while Dispatch Telegram Reply responds.
Check that Upsert Sheet Records updates your Raw Data sheet when you provide complete subscription details.
When satisfied, toggle the workflow to Active to run on schedule and respond to Telegram messages in production.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the Google connection in n8n Credentials and your Google account’s app access first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Telegram renewals automation?

About 30 minutes if your Google Sheet and Telegram bot are ready.

Do I need coding skills to automate Telegram renewals?

No. You’ll mostly connect accounts and paste in a few keys. The workflow already handles the logic and message formatting.

Is n8n free to use for this Telegram renewals workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs, which are usually a few cents for typical chat-based updates.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Telegram renewals workflow for different reminder windows?

Yes, but do it intentionally. You’ll adjust the due-date logic in the “Check Upcoming Dues” part of the workflow, then tweak the message template used before “Send Telegram Alert.” Common changes include sending reminders 7 days before renewal, adding a second “day before” follow-up, and routing certain subscriptions to a different Telegram chat (like finance vs. marketing).

Why is my Google Sheets connection failing in this workflow?

Most of the time it’s expired OAuth access or the wrong Google account connected. Reconnect the Google Sheets credential in n8n, then confirm the spreadsheet is shared with that account. Also check that the Sheets API is enabled for the project if you’re using your own OAuth setup. If it only fails when the list grows, you may be hitting rate limits, so reduce how often you read the entire sheet or filter earlier.

How many subscriptions can this Telegram renewals automation handle?

Plenty for a typical small business: hundreds of rows in Google Sheets is normal. On n8n Cloud, the limit is usually your monthly executions (Starter plans are fine for daily checks plus a steady trickle of chat updates). If you self-host, there’s no execution cap, so it mostly comes down to your server and Google API quotas.

Is this Telegram renewals automation better than using Zapier or Make?

Often, yes, because this isn’t just “if row matches, then send message.” You’re mixing scheduled checks, conditional logic, and a conversational AI agent that can interpret messy human instructions. n8n handles that kind of branching cleanly, and self-hosting removes the anxiety of per-task pricing when usage grows. Zapier or Make can still work if you want a basic reminder and nothing else. If you’re on the fence, Talk to an automation expert and describe your subscription volume and who needs the reminders.

Once this is running, renewals stop being a surprise and start being a decision. Set it up, let Telegram do the nudging, and keep your budget honest.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"meta": {
"instanceId": "a7e96e0c275de3c39fc971ac5e26ebbebfdc469e791c135571dae29bf3a03410",
"templateId": null,
"templateCredsSetupCompleted": null
},
"id": null,
"versionId": null,
"name": "Automated Subscription Assistant Flow",
"nodes": [
{
"id": "flowpast-topbar-7885",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1208,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "918d0148-72d9-422b-8244-0fdd0ce8952e",
"name": "AI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"notes": "",
"position": [
802,
120
],
"parameters": {
"model": "gpt-4.1-nano",
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "e2e40de5-fa69-4e31-b01d-9e08121de5d8",
"name": "Session Memory Window",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"notes": "",
"position": [
590,
140
],
"parameters": {
"sessionKey": "={{ $('Telegram Incoming Message').item.json.message.from.id }}",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "59e67ec9-c85a-4cc3-a48b-df60516ee52c",
"name": "Shape Reply Payload",
"type": "n8n-nodes-base.set",
"notes": "",
"position": [
536,
196
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "cc903946-9e57-402a-bf4e-a001c17c4776",
"name": "response",
"type": "string",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e44c63e1-2f8b-4047-8588-5d58a7a44b52",
"name": "Dispatch Telegram Reply",
"type": "n8n-nodes-base.telegram",
"notes": "",
"position": [
338,
178
],
"webhookId": "9fa4f7c8-c8ee-413c-a7af-0910c4732a43",
"parameters": {
"text": "={{ $json.response }}",
"chatId": "={{ $('Telegram Incoming Message').item.json.message.chat.id }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "f79cf394-4029-48a9-8e04-abcbf436691f",
"name": "Morning Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "",
"position": [
1108,
540
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 8 * * *"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "f7f610d1-4e3d-4855-848a-3adcf7af7dda",
"name": "Retrieve Subscription Sheet",
"type": "n8n-nodes-base.googleSheets",
"notes": "",
"position": [
872,
612
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Dashboard"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Bill Manager AI"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.4
},
{
"id": "5e533f04-197e-4969-977e-b72d4bd45d44",
"name": "Check Upcoming Dues",
"type": "n8n-nodes-base.if",
"notes": "",
"position": [
676,
644
],
"parameters": {
"options": {
"looseTypeValidation": true
},
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "c1a1e734-3e9c-4b1a-9c8e-5f4f3f2f1f0f",
"operator": {
"type": "number",
"operation": "lte"
},
"leftValue": "={{ $('Retrieve Subscription Sheet').item.json['Due In'] }}",
"rightValue": 3
}
]
}
},
"typeVersion": 2
},
{
"id": "b8c19d79-609e-4ab7-84c2-e35fefea7e9c",
"name": "Lookup Sheet Rows",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
944,
150
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values0_Value', ``, 'string') }}",
"lookupColumn": "Bill Name"
},
{
"lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values1_Value', ``, 'string') }}",
"lookupColumn": "Billing Cycle"
},
{
"lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values3_Value', ``, 'string') }}",
"lookupColumn": "Due In"
},
{
"lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values4_Value', ``, 'string') }}",
"lookupColumn": "Status"
},
{
"lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values5_Value', ``, 'string') }}",
"lookupColumn": "Card Used (Last 4 Digits)"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Dashboard"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Bill Manager AI"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "23e6fb89-4afa-4868-990c-e85224ae4ae3",
"name": "Math Utility",
"type": "@n8n/n8n-nodes-langchain.toolCalculator",
"position": [
678,
384
],
"parameters": [],
"typeVersion": 1
},
{
"id": "7c61599e-8eac-4e12-8cf6-cb9e8804db2f",
"name": "Search Web Tool",
"type": "@n8n/n8n-nodes-langchain.toolSerpApi",
"position": [
882,
400
],
"parameters": {
"options": []
},
"credentials": {
"serpApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "0e583a94-c150-499e-8de9-9820eb22840e",
"name": "Send Telegram Alert",
"type": "n8n-nodes-base.telegram",
"notes": "",
"position": [
0,
624
],
"webhookId": "9fa4f7c8-c8ee-413c-a7af-0910c4732a43",
"parameters": {
"text": "={{ $json.message.content.message }}",
"chatId": "={{ '[YOUR_ID]' }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "a46a906d-7c7d-4f19-ae69-68dd38f8c29a",
"name": "Manual Start Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
1062,
686
],
"parameters": [],
"typeVersion": 1
},
{
"id": "40ca68c5-2970-4d93-ba93-2f2b3f28e413",
"name": "Compose Model Prompt",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
282,
636
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-nano",
"cachedResultName": "GPT-4.1-NANO"
},
"options": [],
"messages": {
"values": [
{
"role": "system",
"content": "=You are a subscription reminder assistant. Format the following subscription bills into a clear, concise Telegram message.\n\nInclude:\n- Total number of bills due\n- Each bill's name, amount in Peso, plan type, and exact due date\n- Use emojis for better readability\n- Keep it under 400 characters for Telegram\n\nFormat example:\n\ud83d\udea8 BILLS DUE SOON (3 bills)\n\n\ud83d\udcb3 Netflix Pro - \u20b1890.45\n\ud83d\udcc5 Due: Jan 26, 2025 (2 days)\n\n\ud83c\udfb5 Spotify Premium - \u20b1556.45  \n\ud83d\udcc5 Due: Jan 28, 2025 (4 days)\n\nMake it urgent but friendly."
},
{
"content": "={{ JSON.stringify($json.data) }}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "d7152ed6-db29-4f59-ad94-2552dc9cb951",
"name": "Compile Items",
"type": "n8n-nodes-base.aggregate",
"position": [
476,
620
],
"parameters": {
"options": [],
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "13f93efc-89ca-4e5a-8175-69ac8a811d03",
"name": "Subscription AI Manager",
"type": "@n8n/n8n-nodes-langchain.agent",
"notes": "",
"position": [
744,
220
],
"parameters": {
"text": "={{ $json.message.text }}",
"options": {
"systemMessage": "=ROLE: Smart Bill Manager\nYou are an efficient subscription billing assistant that collects complete information in a single interaction to save tokens and time.\n\nCORE DATA REQUIREMENTS (Collect ALL 6 fields)\nWhen a user mentions ANY subscription/bill, immediately extract and collect:\n\n1. Bill Name: Extract service name only (e.g., \"YouTube\" from \"YouTube Premium\")\n2. Amount: ONLY convert if NOT in USD. USD amounts go directly through.\n3. Plan: Extract plan/tier (e.g., \"Premium\", \"Family\", \"Pro\", \"Basic\")\n4. Start Date: When subscription began (YYYY-MM-DD format)\n5. Billing Cycle: \"Monthly\", \"Yearly\", or \"Weekly\"\n\nOPTIONAL:\n6. Status: Always  to \"Active\" unless user specifies \"Inactive\"\n7. Card Used: Only collect if user mentions (last 4 digits)\n\nCRITICAL RULES\n\nCurrency Conversion (SMART LOGIC)\n- IF amount contains \"$\" OR \"USD\" \u2192 Use directly, NO search needed\n- IF amount contains \u20b1, \u20ac, \u00a3, \u00a5, etc. \u2192 THEN search for conversion\n- Examples:\n  \u2705 \"$15.99\" \u2192 Use directly as \"$15.99\"\n  \u2705 \"15.99 USD\" \u2192 Use directly as \"$15.99\"\n  \ud83d\udd0d \"\u20b1189\" \u2192 Search \"189 PHP to USD\" \u2192 \"$3.45\"\n  \ud83d\udd0d \"\u20ac12\" \u2192 Search \"12 EUR to USD\" \u2192 \"$13.20\"\n\nEfficient Data Collection\n- Extract ALL available information from first message\n- Only ask for missing required fields\n- If user provides partial info, intelligently extract what you can and ask for the rest\n\nBill Name Intelligence\n- Extract service name from plan names:\n  - \"YouTube Premium\" \u2192 Bill Name: \"YouTube\", Plan: \"Premium\"\n  - \"Netflix Family Plan\" \u2192 Bill Name: \"Netflix\", Plan: \"Family\"\n  - \"Spotify Free\" \u2192 Bill Name: \"Spotify\", Plan: \"Free\"\n\nCONVERSATION EXAMPLES\n\nInput: \"$15.99/mo. Next due 13 of august. Youtube premium plan\"\n\nYour Response:\n\u2705 **YouTube Premium - Ready to Add!**\n\nFrom your message, I have:\n\u2705 Bill Name: YouTube\n\u2705 Plan: Premium  \n\u2705 Amount: $15.99 (already in USD)\n\u2705 Billing Cycle: Monthly (from \"/mo\")\n\nI need 2 more details:\n\u2753 **Start Date**: When did you first subscribe? (YYYY-MM-DD)\n\u2753 **Status**: Active or Inactive? (I'll assume Active)\n\nOnce you provide the start date, I'll add it immediately!\n\nInput: \"\u20b1189/mo. Next due 13 of august. Youtube premium plan\"\n\nYour Response:\nI'll add YouTube Premium! Let me convert that amount first.\n\n[Use search: \"189 PHP to USD\"]\n\n\u2705 **YouTube Premium - Ready to Add!**\n\nFrom your message, I have:\n\u2705 Bill Name: YouTube\n\u2705 Plan: Premium  \n\u2705 Amount: $3.45 (converted from \u20b1189)\n\u2705 Billing Cycle: Monthly (from \"/mo\")\n\nI need 2 more details:\n\u2753 **Start Date**: When did you first subscribe? (YYYY-MM-DD)\n\u2753 **Status**: Active or Inactive? (I'll assume Active)\n\nPOST-UPDATE BEHAVIOR\nAfter EVERY successful addition/update, automatically show the 3 nearest due dates from their subscription list.\n\nSEARCH TOOL USAGE\nUse search ONLY for:\n- Non-USD currency conversions: \"189 PHP to USD converter\"\n- Pricing verification: \"YouTube Premium price 2025 USD\" (only if needed)\n- Plan confirmation: \"Netflix plans and pricing 2025\" (only if needed)\n\nERROR PREVENTION\n- Never search if amount is already in USD (contains $ or USD)\n- Never save incomplete records\n- Always confirm plan extraction is correct\n- Default Status to \"Active\" unless specified\n- Extract maximum data from first message to minimize back-and-forth"
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "917cc8ab-4bd5-4873-8ef0-8c7179477bb5",
"name": "Upsert Sheet Records",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
520,
377
],
"parameters": {
"columns": {
"value": {
"Plan": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Plan', ``, 'string') }}",
"Amount": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Amount', ``, 'string') }}",
"Status": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Status', ``, 'string') }}",
"Bill Name": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Bill_Name__using_to_match_', ``, 'string') }}",
"Start Date": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start_Date', ``, 'string') }}",
"Last Updated": "={{ $now }}",
"Billing Cycle": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Billing_Cycle', ``, 'string') }}",
"Card Used (Last 4 Digits)": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Card_Used__Last_4_Digits_', ``, 'string') }}"
},
"schema": [
{
"id": "Bill Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Bill Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Amount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Plan",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Start Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Start Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Cycle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Billing Cycle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Card Used (Last 4 Digits)",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Card Used (Last 4 Digits)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Updated",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Last Updated",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Bill Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Raw Data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Bill Manager AI"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "87cd5ea3-b04f-4552-b6d3-25f30993d06d",
"name": "Telegram Incoming Message",
"type": "n8n-nodes-base.telegramTrigger",
"notes": "",
"position": [
1100,
272
],
"webhookId": "66f2a19c-e4c4-4f19-9764-75d0d60d1ae1",
"parameters": {
"updates": [
"message"
],
"additionalFields": []
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "7481fe8f-508c-459a-8f2e-5f14ff0d191c",
"name": "Telegram Typing Action",
"type": "n8n-nodes-base.telegram",
"position": [
956,
334
],
"webhookId": "58d810d6-194e-4db5-b1bf-c5187edb7479",
"parameters": {
"chatId": "={{ $('Telegram Incoming Message').item.json.message.chat.id }}",
"operation": "sendChatAction"
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
}
],
"pinData": [],
"connections": {
"Search Web Tool": {
"ai_tool": [
[
{
"node": "Subscription AI Manager",
"type": "ai_tool",
"index": 0
}
]
]
},
"Compile Items": {
"main": [
[
{
"node": "Compose Model Prompt",
"type": "main",
"index": 0
}
]
]
},
"Math Utility": {
"ai_tool": [
[
{
"node": "Subscription AI Manager",
"type": "ai_tool",
"index": 0
}
]
]
},
"Morning Schedule Trigger": {
"main": [
[
{
"node": "Retrieve Subscription Sheet",
"type": "main",
"index": 0
}
]
]
},
"Shape Reply Payload": {
"main": [
[
{
"node": "Dispatch Telegram Reply",
"type": "main",
"index": 0
}
]
]
},
"Compose Model Prompt": {
"main": [
[
{
"node": "Send Telegram Alert",
"type": "main",
"index": 0
}
]
]
},
"AI Chat Engine": {
"ai_languageModel": [
[
{
"node": "Subscription AI Manager",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Retrieve Subscription Sheet": {
"main": [
[
{
"node": "Check Upcoming Dues",
"type": "main",
"index": 0
}
]
]
},
"Subscription AI Manager": {
"main": [
[
{
"node": "Shape Reply Payload",
"type": "main",
"index": 0
}
]
]
},
"Session Memory Window": {
"ai_memory": [
[
{
"node": "Subscription AI Manager",
"type": "ai_memory",
"index": 0
}
]
]
},
"Check Upcoming Dues": {
"main": [
[
{
"node": "Compile Items",
"type": "main",
"index": 0
}
],
[]
]
},
"Telegram Incoming Message": {
"main": [
[
{
"node": "Subscription AI Manager",
"type": "main",
"index": 0
},
{
"node": "Telegram Typing Action",
"type": "main",
"index": 0
}
]
]
},
"Lookup Sheet Rows": {
"ai_tool": [
[
{
"node": "Subscription AI Manager",
"type": "ai_tool",
"index": 0
}
]
]
},
"Manual Start Trigger": {
"main": [
[
{
"node": "Retrieve Subscription Sheet",
"type": "main",
"index": 0
}
]
]
},
"Upsert Sheet Records": {
"ai_tool": [
[
{
"node": "Subscription AI Manager",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}