Turn Telegram sales signals into a Sheet check
When a Telegram message reports a specific sales signal, Notis can search a defined Sheet column and aggregate its matching data.
Trigger
New Message Received
Triggered when your bot receives a new message in a private chat, group, or supergroup. To receive every message in a group, Privacy Mode must be disabled for the bot in BotFather.
Action
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Why this helps
A sales update can prompt a manual spreadsheet check that breaks the flow of the work in front of you.
- Run a focused check on matching spreadsheet rows when a signal arrives.
- Reduce the time spent navigating to the right data for a quick status answer.
- Make recurring operational questions easier to trigger from chat.
Setup
Build it in a few focused steps.
- 1Connect Telegram and Google Super once through the portal, with a populated spreadsheet and the relevant columns available.
- 2Create an automation in the portal or ask Notis in plain language.
- 3Describe in one instruction which sales signals should prompt the aggregate and what spreadsheet data to examine.
- 4Select New Message Received as the trigger and choose a channel for run reports.
- 5Send one signal that matches known data and review the aggregate result.
Questions about this workflow
Does this update the spreadsheet?
No. The action searches for rows matching a column value and performs a mathematical operation on another column.
What needs to be prepared first?
The spreadsheet should have the relevant matching and calculation columns populated.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Telegram to Google Super. A trigger fires from one place; an action lands in another.
Telegram triggers
Google Super actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Enrichment
Adds an enrichment at a specified position in a defined album.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add file sharing preference
Modifies sharing permissions for an existing google drive file, granting a specified role to a user, group, domain, or 'anyone'.
New Message Received
Triggered when your bot receives a new message in a private chat, group, or supergroup. To receive every message in a group, Privacy Mode must be disabled for the bot in BotFather.
Modify email labels
Adds and/or removes specified gmail labels for a message; ensure `message id` and all `label ids` are valid (use 'listlabels' for custom label ids).
New Channel Post
Triggered when a new post is published to a channel where your bot is an administrator.
Add or remove to customer list
Addorremovetocustomerlist tool will add a contact to a customer list in google ads. note: it takes 6 to 12 hours for changes to be reflected in the customer list.
Callback Query Received
Triggered when a user taps an inline keyboard button attached to one of your bot's messages.
Add Sheet to Spreadsheet
Adds a new sheet (worksheet) to a spreadsheet. use this tool to create a new tab within an existing google sheet, optionally specifying its title, index, size, and other properties.
Message Edited
Triggered when a message in a chat your bot can see is edited by its sender.
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
New Chat Member
Triggered when a new member joins a group or supergroup the bot belongs to, including when the bot itself is added.
Append Dimension
Tool to append new rows or columns to a sheet, increasing its size. use when you need to add empty rows or columns to an existing sheet.
Batch Add Media Items
Adds one or more media items to an album in google photos.
Connect any two apps with Notis in the middle.
Telegram and Google Super, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Google Super.