Integrate Recruitee with Google Sheets Using Pabbly Connect

Learn how to integrate Recruitee with Google Sheets using Pabbly Connect to automate job applicant tracking. Step-by-step guide included. 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. Getting Started with Pabbly Connect for Job Applicant Tracking

To begin tracking job applicant details effectively, you will need to use Pabbly Connect. This platform allows you to automate the integration between Recruitee and Google Sheets, ensuring that every job application is recorded without manual input.

First, visit the Pabbly website by typing Pabbly.com in your browser. Navigate to the products section and select Pabbly Connect. If you are a new user, click on the ‘Sign up for free’ button to create your account. Existing users can log in directly to access their dashboard.

2. Creating a Workflow in Pabbly Connect

After logging into Pabbly Connect, you will need to create a new workflow. Click on the plus sign to create a new workflow and name it ‘Keep Track of Job Applicant Details in Google Sheets’. This name can be customized according to your preference.

In the workflow setup, you will see a trigger and action window. The trigger is an event that will start the workflow, and the action is what happens as a result. For our case, we want to set the trigger to Recruitee when a candidate is created. Follow these steps:

• Select Recruitee as the application.
• Choose ‘Candidate is created’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Next, head to your Recruitee account, navigate to settings, and select ‘Apps and Plugins’. Click on the ‘Webhooks’ option to create a new webhook. Paste the copied URL and select the event for when a candidate is created, then verify and create the webhook.

3. Capturing Applicant Details from Recruitee

With the webhook set up, it’s time to test the integration. You need to submit a job application through your Recruitee portal. For example, you can use the name ‘Adam Smith’ and provide the necessary details such as email and phone number.

Once the application is submitted, Pabbly Connect will capture the applicant’s details automatically. You can verify this by checking the response in the Pabbly Connect dashboard, where you will see all relevant information such as name, email, and phone number.

• Check the response for the captured details.
• Ensure all information is accurate and complete.

After confirming that the details are captured correctly, you can proceed to the next step of adding this information to Google Sheets.

4. Adding Job Applicant Details to Google Sheets

Now that you have captured the applicant’s details, the next step is to add this information to Google Sheets using Pabbly Connect. In the action step of your workflow, select Google Sheets as the application and choose the action event ‘Add New Row’.

Connect your Google account by selecting the appropriate account where your Google Sheets are located. Once connected, you will see a list of your spreadsheets. Choose the spreadsheet you created for job applications.

Select the spreadsheet named ‘Recruiting Job Applications’. Map the fields from Recruitee to the corresponding columns in Google Sheets. Ensure to include name, email, phone number, department, and title.

After mapping the fields, click on ‘Save and Send Test Request’ to ensure that the details are added to your Google Sheets correctly. You can check your Google Sheets to confirm that the new row was created successfully with all the applicant’s details.

5. Verifying Integration Success

To ensure that the integration is functioning correctly, you should perform a test by submitting another job application. This time, use a different applicant, for example, ‘Shikha Arya’ with her respective details.

Once the application is submitted, check your Google Sheets again. You should see the new applicant’s details added automatically. This confirms that Pabbly Connect is successfully integrating Recruitee with Google Sheets.

To summarize the integration process:

Created a webhook in Recruitee to capture candidate details. Used Pabbly Connect to map these details to Google Sheets. Verified that new applications appear in Google Sheets automatically.

This integration allows for seamless tracking of job applicants, saving time and reducing manual errors.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to integrate Recruitee with Google Sheets, enabling you to keep track of job applicant details effortlessly. By following the steps outlined, you can automate the process and ensure that every application is recorded accurately.

Utilizing Pabbly Connect not only simplifies your workflow but also enhances your recruitment process, making it more efficient and reliable.