ManualTrigger Automate

ManualTrigger Automate streamlines communication by integrating Telegram and Google Sheets, allowing users to send batch messages after retrieving data. Triggered manually, it processes up to 30 entries at a time, ensuring timely updates with a 30-second wait between actions. This workflow enhances efficiency and simplifies data management.

7/8/2025
5 nodes
Simple
manualsimpletelegramgooglesheetssplitinbatcheswaitcommunicationbot
Categories:
Communication & MessagingManual TriggeredSimple WorkflowData Processing & Analysis
Integrations:
TelegramGoogleSheetsSplitInBatchesWait

Target Audience

  • Business Owners: Looking to automate communication with clients via Telegram.
    - Marketing Teams: Need to send batch messages to a large audience efficiently.
    - Data Analysts: Want to extract data from Google Sheets and notify team members about updates.
    - Developers: Interested in integrating various tools and services for streamlined workflows.
    - Freelancers: Seeking to manage client communications and project updates seamlessly.

    • Problem Solved

  • Automates the process of sending messages to clients or users on Telegram, which saves time and reduces manual effort.
    - Efficiently manages large lists by splitting them into batches of 30, ensuring that messages are sent without overwhelming the platform.
    - Integrates with Google Sheets to pull data dynamically, allowing for real-time updates and notifications.

    • Workflow Steps

  • Step 1: The workflow is manually triggered by clicking 'execute'.
    - Step 2: It retrieves data from a specified range in Google Sheets (Column A).
    - Step 3: The data is then split into manageable batches of 30 using the SplitInBatches node.
    - Step 4: After a 30-second wait, the workflow proceeds to send a Hello message to each chat ID obtained from the batches using the Telegram integration.
    - Step 5: Each message is sent sequentially, ensuring that users are informed without overloading the Telegram service.

    • Customization Guide

  • Change Message Content: Modify the text parameter in the Telegram node to customize the message.
    - Adjust Batch Size: Alter the batchSize parameter in the SplitInBatches node to fit your needs, whether you want smaller or larger batches.
    - Update Google Sheets Range: Change the range in the Google Sheets node to specify a different column or range of data.
    - Modify Wait Duration: Adjust the amount in the Wait1 node to increase or decrease the waiting time before sending messages.
    - Integrate Additional Nodes: Add more nodes to the workflow to include additional functionalities, such as logging or error handling.