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.

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

   

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.

   

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.

   

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

   

4. Connect Zapier and SimplyHired

[ Back to top ]

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

   

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

   

   After your SimplyHired credentials have been verified, the successful connection is shown 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.

   

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.

   

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

   

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

   

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

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

      

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

      

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.

   

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, and then select Next.

   

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.

   

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

   

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.

   

   

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.