How to Send Job Alert SMS to Contacts in Google Sheets Using Pabbly Connect

Learn how to integrate Google Sheets with Twilio to send job alert SMS using Pabbly Connect. Step-by-step guide for recruiters and HR departments. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Job Alerts

To automate sending job alerts via SMS, the first step is to set up Pabbly Connect. This platform serves as the integration hub connecting Google Sheets and Twilio. Start by signing up for a free account on the Pabbly Connect website and access the dashboard.

Once logged in, click on the ‘Create Workflow’ button. Name your workflow appropriately, such as ‘Job Alerts via SMS’. This naming helps in identifying the automation later. The workflow consists of two main components: the trigger and the action.

2. Integrating JotForm with Pabbly Connect

Next, you will set up the trigger using JotForm, which collects job listing data. In Pabbly Connect, select JotForm as the trigger application and choose the ‘New Response’ event. This event will activate the workflow whenever a new job listing is created.

• Search for JotForm in the trigger application.
• Select the trigger event ‘New Response’.
• Copy the webhook URL provided by Pabbly Connect.

In JotForm, navigate to your form settings and integrate the copied webhook URL. This connection allows JotForm to send data to Pabbly Connect whenever a new job listing is submitted.

3. Fetching Candidate Data from Google Sheets

Now that JotForm is integrated, the next step is to retrieve candidate data from Google Sheets using Pabbly Connect. Select Google Sheets as the action application and choose the ‘Lookup Spreadsheet Rows’ event. This action will search for candidates based on their desired job location.

Connect your Google account, then select the spreadsheet and sheet containing candidate data. Specify the lookup column (e.g., column D for locations) and map the job location from the JotForm response. This will filter out candidates who want to work in the specified location.

4. Sending SMS Alerts via Twilio

After fetching candidate data, the next step is to send SMS alerts using Twilio through Pabbly Connect. Add a new action step and select Twilio as the application. Choose the ‘Send SMS’ action event to configure the SMS message that will be sent to candidates.

• Enter your Twilio Account SID and Auth Token to connect.
• Compose the SMS message, including details like job title and description.
• Map the recipient’s phone number from the candidate data.

Once set up, every time a job listing is created, the relevant candidates will receive an SMS alert automatically, streamlining the recruitment process.

5. Testing and Launching the Workflow

Finally, it’s essential to test your workflow in Pabbly Connect to ensure everything functions correctly. Trigger a test by submitting a new job listing through JotForm and check if the SMS alerts are sent to the correct candidates in Bhopal.

If the test is successful, you can officially launch the workflow. This automation will now run seamlessly, sending job alerts to candidates who want to work in the specified location without any manual intervention.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate sending job alert SMS to candidates using Google Sheets and Twilio. This integration simplifies the recruitment process, ensuring timely notifications for candidates looking for jobs in their desired locations.