Watch Step By Step Video Tutorial Below





1. Setting Up Pabbly Connect for Resume Processing

To begin the process of turning hundreds of resumes into an AI-powered shortlist automatically, you first need to access Pabbly Connect. This platform allows you to integrate various applications seamlessly, starting with Google Drive.

Once logged into Pabbly Connect, navigate to the workflow page where you will see options to add a trigger and an action. The trigger will be set to Google Drive, and the action will involve OpenAI to extract resume details.

2. Creating a Trigger in Google Drive with Pabbly Connect

In this step, you will set up a trigger that activates whenever a new resume is uploaded to your Google Drive. Select Google Drive as your trigger application in Pabbly Connect and choose the event ‘New File in a Specific Folder’.

  • Click on ‘Connect’ to link your Google Drive account.
  • Grant permissions by signing in with your Google account.
  • Select the folder where your resumes are stored.

After setting up the trigger, save the configuration. This allows Pabbly Connect to monitor the designated folder for new resumes, ensuring automation starts as soon as a file is uploaded.

3. Extracting Data from Resumes Using OpenAI

Once the trigger is set, the next step is to extract data from the uploaded resumes using OpenAI. In Pabbly Connect, add a new action step and select OpenAI as your action application.

Set the action event to ‘Generate Structured JSON Schema’. You will need to create an API token from OpenAI, which you will enter in Pabbly Connect. This token allows the integration to access OpenAI’s capabilities for extracting relevant data from resumes.

  • Enter a prompt to generate a JSON schema for the resume fields.
  • Specify the fields you want to extract, such as full name, email, and skills.
  • Save and test the request to confirm data extraction.

This process will allow you to receive structured data from the resumes, which can be mapped to your Google Sheets in the next step.

4. Mapping Extracted Data to Google Sheets

In this section, you will map the extracted data from OpenAI to Google Sheets using Pabbly Connect. Add another action step and select Google Sheets as your action application.

Choose the event ‘Add New Row’ to insert the extracted data into your spreadsheet. Connect your Google Sheets account and select the spreadsheet where you want the data to be stored.

  • Map the fields from the OpenAI response to the corresponding columns in your Google Sheets.
  • Ensure all relevant fields such as name, email, and skills are included.
  • Save and send a test request to verify the integration.

After completing this mapping, your Google Sheets will automatically populate with the extracted resume data, facilitating a streamlined hiring process.

5. Creating a Shortlist Filter in Pabbly Connect

To finalize your automation, you can create a filter step in Pabbly Connect to shortlist candidates based on specific criteria. This can be set up after the Google Sheets action.

For example, you can filter candidates who have more than a specified number of years of experience. This helps in automatically sorting out candidates who do not meet your hiring criteria.

  • Add a filter step after the Google Sheets action.
  • Set conditions for filtering candidates, such as years of experience.
  • Notify HR or send emails to shortlisted candidates.

This filter can enhance your hiring process by ensuring only qualified candidates are considered, making the integration through Pabbly Connect even more effective.

Conclusion

In this tutorial, we explored how to automate the process of turning hundreds of resumes into an AI-powered shortlist using Pabbly Connect. By integrating Google Drive and OpenAI, you can efficiently manage candidate data and streamline your hiring process.