How to Schedule Telegram Messages from Google Sheets Using Pabbly Connect

Learn how to automate the scheduling of Telegram messages from Google Sheets using Pabbly Connect. Step-by-step guide with detailed instructions. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Telegram Automation

To schedule Telegram messages from Google Sheets, you need to access Pabbly Connect. Start by visiting the Pabbly Connect homepage by typing ‘Pabbly.com/connect’ in your browser. Here, you will find options to sign in or sign up for free.

If you are new to Pabbly Connect, click on the ‘Sign up for free’ button. This will allow you to create a new account and explore the platform with 100 free tasks each month. If you already have an account, simply sign in to access your dashboard.

2. Creating a Workflow in Pabbly Connect

Once you are signed in, you will be taken to the Pabbly Connect dashboard. To create a new workflow, click on the ‘Create Workflow’ button in the top right corner. A dialog box will appear, prompting you to name your workflow. using Pabbly Connect

• Name your workflow (e.g., ‘Schedule Telegram Messages from Google Sheets’).
• Select a folder to save your workflow, if desired.
• Click on ‘Create’ to proceed.

After creating the workflow, two windows will open for setting up the trigger and action. The trigger defines when the automation occurs, while the action specifies what happens in response. In this case, we will use the ‘Schedule by Pabbly’ feature as our trigger.

3. Setting Up the Schedule Trigger

In the trigger application, select ‘Schedule by Pabbly’. This feature allows you to set a specific time for your automation to run. For this example, choose to trigger the workflow daily at a specific time, such as 5:15 PM. using Pabbly Connect

• Select the frequency of the trigger (e.g., daily).
• Specify the time for the trigger to activate.
• Click ‘Save’ to finalize the trigger setup.

After saving, your schedule is now set, and the workflow will trigger automatically at the specified time each day.

4. Fetching Current Date from Google Sheets

Next, you need to fetch the current date to use in your Google Sheets lookup. Click on the ‘Add Action Step’ button and select ‘Date Time Formatter by Pabbly’. Choose the option to fetch the current date. using Pabbly Connect

Once selected, click ‘Connect’ and choose the desired date format (e.g., YYYY-MM-DD). After that, click ‘Save and Send Test Request’ to confirm that you have successfully fetched the current date. This date will be used to look up relevant data in your Google Sheets.

5. Integrating Google Sheets with Pabbly Connect

Now, you will integrate Google Sheets with Pabbly Connect. Click on ‘Add Action Step’ again and select ‘Google Sheets’. For the action event, choose ‘Lookup Spreadsheet Row’. Connect your Google Sheets account by clicking on ‘Add New Connection’ and follow the prompts to sign in.

Select the spreadsheet containing your data. Specify the lookup column (e.g., column C for date and time). Map the current date as the lookup value.

After mapping the date and saving the action, Pabbly Connect will fetch the relevant data from your Google Sheets.

Conclusion: Sending Messages to Telegram Channel

Finally, to send the message to your Telegram channel, click on ‘Add Action Step’ and select ‘Telegram Bot’. Choose the action event ‘Send a Text Message’. Connect your Telegram bot by entering the API token generated from BotFather.

Once connected, specify the chat ID and compose the message using the data fetched from Google Sheets. Click ‘Save and Send Test Request’ to confirm that the message is sent successfully. With these steps, you have fully automated the process of scheduling Telegram messages from Google Sheets using Pabbly Connect.