Automate Telegram Photo and Video Sharing with Pabbly Connect and Google Sheets

Learn how to automatically send multiple photos and videos on Telegram using Pabbly Connect and Google Sheets. Step-by-step guide included! 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. Setting Up Pabbly Connect for Google Sheets and Telegram Integration

To start sending multiple photos and videos on Telegram automatically, you need to set up Pabbly Connect. Begin by logging into the Pabbly website at Pabbly.com. If you are a new user, click on the ‘Sign Up Free’ button to create your account. Existing users can simply sign in to access Pabbly Connect.

Once logged in, navigate to the dashboard and create a new workflow. Click the plus sign to create a workflow and name it, for example, ‘Share Album on Telegram Channel from Google Sheets’. This name will help you identify the workflow later. Now, you will see a trigger window and an action window to set up your automation.

2. Configuring Google Sheets as the Trigger in Pabbly Connect

In this step, you will configure Google Sheets as the trigger application in Pabbly Connect. Open the trigger window and select Google Sheets as the application. Then, choose the trigger event as ‘New or Updated Spreadsheet Row’. This means that every time a new row is added or an existing row is updated in your Google Sheet, it will trigger the workflow.

• Copy the webhook URL provided by Pabbly Connect.
• Open your Google Sheet and navigate to Extensions > Add-ons > Get Add-ons.
• Search for ‘Pabbly Connect Webhooks’ and install it.

After installation, refresh your Google Sheet. Go back to Extensions > Pabbly Connect Webhooks > Initial Setup. Paste the copied webhook URL and set the trigger column to the final data column where you will add photo and video URLs. Click on ‘Send Test’ to ensure the setup is successful, then click ‘Submit’.

3. Setting Up Telegram as the Action in Pabbly Connect

After configuring Google Sheets, the next step is to set up Telegram as the action application in Pabbly Connect. In the action window, select Telegram and choose the action event ‘Send an Album’. Click on ‘Connect’ and then ‘Add New Connection’. You will need a token from the Telegram BotFather to establish this connection.

To get the token, open Telegram and search for ‘BotFather’. Start a chat and type ‘/newbot’ to create a new bot. Follow the prompts to name your bot and set a username. After creation, BotFather will provide you with a token. Copy this token and paste it into Pabbly Connect to connect your bot.

4. Configuring the Album Settings in Pabbly Connect

Now that Telegram is connected, you need to configure the settings for the album you want to send. In Pabbly Connect, you will need to provide the chat ID of the group or channel where you want to send the album. To find the chat ID, add your bot to the desired group and retrieve the chat ID from the group URL.

Next, you will specify the media type. The media type must be either ‘photo’ or ‘video’, and you need to ensure that at least two items are included. For example, if you have both photo and video URLs, you will format them as ‘photo, video’. Map the media URLs from your Google Sheet into Pabbly Connect by selecting the appropriate fields from the trigger response.

• Map the line item caption for the album.
• Ensure the media URLs are formatted correctly with commas separating them.
• Click on ‘Save and Send Test Request’ to check if the album is sent successfully.

Once you receive a successful response, your setup is complete. The album will automatically be shared on Telegram whenever you add new URLs to your Google Sheet.

5. Testing the Integration in Real-Time

To ensure everything is working correctly, perform a real-time test of your integration. Go back to your Google Sheet and add a new row with the title and URLs for photos or videos. For example, enter ‘Group 2’ as the title and add the video URLs formatted as ‘video, video’. This action will trigger Pabbly Connect to send the album to your Telegram channel.

Check your Telegram channel to see if the album has been shared successfully. You should see the title and all the media included in the album. This confirms that your automation is functioning as intended. If any issues arise, revisit the steps in Pabbly Connect to ensure all configurations are correct.

In conclusion, utilizing Pabbly Connect to automate the sharing of photos and videos on Telegram from Google Sheets streamlines your workflow and enhances your efficiency. This integration allows for seamless communication and sharing, making it a valuable tool for any user.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to send multiple photos and videos on Telegram automatically through Google Sheets. This integration simplifies the process of sharing media and enhances productivity.