How to Send Campus Drive Notification using Google Sheets & Telegram

Learn how to send Campus Drive notifications using Google Sheets and Telegram with Pabbly Connect. Follow our detailed guide for seamless integration. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start sending Campus Drive notifications, you first need to access Pabbly Connect. This platform is essential for integrating Google Sheets and Telegram seamlessly.

Begin by visiting the Pabbly website. If you don’t have an account, you can sign up for free, which will give you access to 100 tasks every month. Once logged in, navigate to the dashboard where you can create new workflows.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a new workflow in Pabbly Connect to automate notifications. Click on the ‘Create Workflow’ button and name it to reflect its purpose, such as ‘Send Campus Drive Notification’.

• Select the folder where you want to save your workflow.
• Set up the trigger and action boxes on the workflow page.

After naming your workflow, proceed to set the trigger application as Google Sheets. This will allow you to receive updates whenever a new entry is made in your spreadsheet.

3. Setting Up Google Sheets as a Trigger

Now, configure Google Sheets to act as the trigger in your Pabbly Connect workflow. Select the trigger event as ‘New or Updated Spreadsheet Row’. This ensures that any new entry in your Google Sheet will initiate the workflow.

To connect Google Sheets with Pabbly Connect, you will need to copy the provided webhook URL. Open your Google Sheets, navigate to Extensions, and then to Add-ons to install the Pabbly Connect Webhook add-on if you haven’t done so already.

• Paste the webhook URL in the setup window of the add-on.
• Specify the trigger column where data will be added.

Once done, test the setup to confirm that data can be sent successfully from Google Sheets to Pabbly Connect.

4. Connecting Telegram as an Action

After successfully setting up Google Sheets, the next step is to configure Telegram as the action in your Pabbly Connect workflow. Select Telegram as your action application and choose the action event ‘Send a Text Message’.

To connect Telegram with Pabbly Connect, you will need to create a Telegram bot using BotFather. Generate a token for your bot and paste it into the connection settings in Pabbly Connect.

Create a group in Telegram and add your bot as a member. Promote your bot to admin to enable it to send messages.

Once your bot is connected, you will need to provide the chat ID of your group and configure the message content using data mapped from Google Sheets.

5. Testing the Integration

With both Google Sheets and Telegram configured, you can now test the integration in Pabbly Connect. Add a new row in your Google Sheet with details of a Campus Drive.

Once you fill out the new row, the data should automatically trigger a message sent to your Telegram group. This message will include all relevant details about the Campus Drive, such as the company name, position, date, and time.

Check your Telegram group to confirm that the message has been sent successfully. If everything is set up correctly, you should see the notification appear in your group.

Conclusion

In this tutorial, we explored how to send Campus Drive notifications using Google Sheets and Telegram through Pabbly Connect. By following these steps, you can automate notifications efficiently and keep your community informed about new opportunities.