Skip to main content

Use Zapier to export new revealed applicant information to a Google Sheet

Use Zapier to export new revealed applicant information to a Google Sheet

New to Zapier? Learn about Zapier and how it can help you export revealed applicant information in About Zapier.

Follow these steps to set up a Zap to automatically export revealed applicants' application information or application data to a Google Sheet.

If you are using the free Zapier plan, your Zap will run every 15 minutes. When the Zap runs, if there is new applicant data to export, that run will count as a task. You are allotted 100 tasks per month in the free Zapier plan.

Zapier also has additional levels of service if you need features beyond the free plan. See the Zapier website for details.

Before you begin

  • If you don't already have a Zapier account, you can create one while setting up your Zap.

  • You must have at least one revealed applicant in SimplyHired before you can set up your Zap.

To set up your Zap, you can follow the steps outlined below, or you can view this quick video tutorial:

Set up the Zap

1. Create your Google Sheet

  1. In order to use Zapier to export applicant data from SimplyHired to Google Sheets, you must first set up a Google Sheet to receive the information. Create a Google Sheet in your default Google Drive location (recommended). You can name it anything you want.

  2. Add column headers (also called fields), to a worksheet in the Google Sheet file. You should add a field for every piece of applicant data you want to export from SimplyHired. The fields in Google Sheets can be named anything you want.

    Available fields from SimplyHired include the following:

    • First Name

    • Last Name

    • Email

    • Phone Number

    • Job Title

    • Link to Resume

    • City

    • State

    • Id

    • Job ID

    • Application ID

    • Cover Letter

    • Started

    • Created At

    • Updated At

    • Hash

    Example Google Sheet file

    Example Google Sheet showing several fields: first name, last name, email, phone number, city, state, job title, and job ID.

2. Select the Zap to use

[ Back to top ]

  1. Sign in to SimplyHired, and in the upper-right corner, select your name > Settings.

  2. Select Integrations, and then select Zapier Integrations.

    Settings > Integrations page in SimplyHired, showing the Zapier Google Sheets integration

  3. Select Use this Zap for the Zap that you want to create. In this case, you will select the button for the row Create Google Sheets rows for new SimplyHired applications.

3. Sign in to Zapier (or sign up if needed)

[ Back to top ]

  1. Sign in to Zapier, or sign up if needed.

    Zapier sign-in page

  2. After signing in or signing up, select Get Started to continue.

    Zapier Get Started page

4. Connect Zapier and SimplyHired

[ Back to top ]

  1. Select  Connect to connect Zapier and your SimplyHired account.

    Zapier Connect Your Account to SimplyHired page

  2. Type your SimplyHired credentials and select Yes, Continue.

    Zapier dialog box asking permission to allow Zapier to access your SimplyHired account

    After your SimplyHired credentials have been verified, the successful connection is shown with a green check mark.

    Connect Your SimplyHired account confirmation screen with a green check mark

  3. Select Next. Zapier verifies the connection to SimplyHired, and this screen will display and then disappear after a few moments.

    Getting Data from SimplyHired screen that is displayed for a short time then disappears

5. Connect your Google Sheets account

[ Back to top ]

  1. Choose which Google account you want to use. If you want to use the account listed, select Next to proceed to the next screen.

    Otherwise, select Connect a new account to select and connect to a different Google account.

    Connect your Google Sheets account screen showing the default Google account to use for this Zap

  2. If selecting a different Google account: choose the Google account you want to use and select Allow.

    Choose a Google account screen and permission for Zapier to access your Google Account screen

  3. Select the Google Drive destination that houses the Google Sheet you created in Step 1, then select Next.

    Select the Google Drive destination for the Google Sheet

  4. Select the Google Sheet file from Step 1 as well as the worksheet to use.

    1. Select the Google Sheet, then select Next. You may need to select Refresh list.

      Select the Google Sheet (image shows three Google Sheets available to be selected)

    2. From the Google Sheet file from Step 1, select the worksheet to which you want to export applicant data, then select Next.

      Select the Worksheet in the Google Sheet (image shows Sheet1 which is the default sheet)

  5. Zapier reads the fields in the worksheet you specified in Step 1. If Zapier doesn't find fields in the worksheet, a message informs you of this. Add fields and select Try again.

    Message informing the user if there are not any column headers in the worksheet

6. Map fields from SimplyHired into Google Sheets

[ Back to top ]

  1. The next screen will show you a list of all of the fields in your Google Sheet worksheet. Select the fields in your Google Sheet that you want to be included in your Zap to receive applicant information, then select Next.

    List of all the fields in your Google Sheet. Select fields to include in your Zap.

  2. On the next screen you'll map each field in your Google Sheet to a corresponding field from SimplyHired. Click in the gray box below each field shown to select the corresponding SimplyHired field.

    Map fields from SimplyHired into Google Sheets

    Select a SimplyHired field for each field displayed. When you are done, your Zap will look something like this:

    Your Zap with fields mapped from SimplyHIred into Google Sheets

  3. Select Next when ready.

7. Test the action and turn on the Zap

[ Back to top ]

  1. Select Send test. After verifying that the test was successful in your Google Sheet file, select Next to turn on the Zap and start processing.

    Let's test out this Zap screen with a Send Test button

    Let's test out this Zap screen showing a link to the spreadsheet results

  2. On the final step, you can review your Zap settings. If you would like to make edits to any of the settings you just completed, select the Edit button. Otherwise, select Turn on Zap.

    Review and turn on your Zap screen showing the Turn on Zap button

    Your Zap is on screen showing the View your Spreadsheet row button and the Manage your Zap button

 

Last updated: May 10, 2022
© 2022 SH Inc. All rights reserved.

Articles in this section

Was this article helpful?
0 out of 0 found this helpful