Integrate Campus Drive Notifications Using Pabbly Connect and Google Sheets

Learn how to automate Campus Drive notifications via Telegram using Pabbly Connect and Google Sheets in this detailed tutorial. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To begin the integration process, access Pabbly Connect by visiting the Pabbly website. If you don’t have an account, you can sign up for free, which takes only a couple of minutes. Once logged in, you will be directed to the dashboard where you can create workflows.

Click on the ‘Access Now’ button under Pabbly Connect to enter the dashboard. Here, you can manage your workflows, create new ones, and organize them into folders for better management. This platform is essential for connecting your Google Sheets with Telegram.

2. Creating a Workflow in Pabbly Connect

To create a new workflow in Pabbly Connect, click on the ‘Create Workflow’ button. A pop-up will appear asking you to name your workflow. Name it according to your objective, such as ‘Campus Drive Notification to Students on Telegram.’ Select the folder where you want to save it and click ‘Create’.

• Click on the ‘Create Workflow’ button.
• Name your workflow appropriately.
• Select the desired folder and click ‘Create’.

Once your workflow is created, you will see two boxes: Trigger and Action. The Trigger will be Google Sheets, which initiates the workflow whenever a new row is added or updated. This is the first step in automating notifications for Campus Drives.

3. Setting Up the Trigger with Google Sheets

In this step, you will set up the trigger for your workflow using Pabbly Connect. Select Google Sheets as your trigger application and choose the trigger event as ‘New or Updated Spreadsheet Row.’ This will activate the workflow whenever a new entry is made in your Google Sheet.

Next, you will need to connect your Google Sheets to Pabbly Connect. This is done using a webhook URL provided by Pabbly. Copy the webhook URL and follow these steps:

• Open your Google Sheet and go to Extensions > Add-ons > Get Add-ons.
• Search for Pabbly Connect Webhook and install it.
• Set up the extension by pasting the webhook URL into the initial setup.

Configure the trigger column in your Google Sheet, which should be the last column where data is entered. Test the connection to ensure it’s working correctly.

4. Setting Up the Action with Telegram

After successfully setting up the trigger, the next step is to configure the action in Pabbly Connect. Select Telegram as your action application and choose the action event as ‘Send a Text Message or Reply.’ This action will send notifications to your Telegram group based on the data from Google Sheets.

To connect Telegram with Pabbly Connect, you will need a bot token. Create a new bot in Telegram using the BotFather, and copy the token provided. Paste this token in the Pabbly Connect interface to establish the connection.

Create a new bot in Telegram using BotFather. Copy the bot token and paste it into Pabbly Connect. Set up the chat ID by creating a group and adding your bot as an admin.

Once the Telegram bot is connected, configure the message format by mapping the relevant fields from Google Sheets to your message in Telegram. This ensures that the notifications are personalized and informative.

5. Testing the Integration and Finalizing

With both the trigger and action set up in Pabbly Connect, it’s time to test the integration. Add a new row in your Google Sheet with details of a Campus Drive, including the company name, date, time, and position. Once you save this entry, the workflow should trigger automatically.

Check your Telegram group to verify that the notification has been sent successfully. The message should include all the details you’ve mapped from Google Sheets. If everything works as expected, your integration is successfully set up!

Add a new row in Google Sheets with Campus Drive details. Verify the message sent in your Telegram group. Adjust any settings if necessary for future notifications.

This integration allows for seamless communication with students regarding Campus Drives, ensuring they receive timely updates automatically.

Conclusion

In this tutorial, we demonstrated how to automate Campus Drive notifications using Pabbly Connect and Google Sheets. By following these steps, you can efficiently notify students via Telegram whenever new details are added, streamlining your communication process.