How to Import Interviews Data from Lever into Google Sheets

using Coefficient google-sheets Add-in (500k+ users)

Easily import your Lever Interviews data into Google Sheets using Coefficient to track candidate progress and manage your interview schedule effectively.

“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”

5 star rating coeff g2 badge

Bringing your Lever Interviews data into Google Sheets allows you to closely track candidate progress through the interview stages and manage schedules easily.

Stop relying on manual updates that can fall behind quickly.

Learn how to quickly import your Interviews data from Lever into Google Sheets using Coefficient in this simple guide.

TLDR

  • Step 1:

    Step 1. Install Coefficient in Google Sheets and connect your Lever account.

  • Step 2:

    Step 2. Select Import from Objects and choose the Interviews object.

  • Step 3:

    Step 3. Pick the interview details you want and import the data to your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your interview data updated automatically.

block:step-by-step

Here’s how to pull your Lever interview data directly into Google Sheets with Coefficient.

Step 1: Install Coefficient and Connect to Lever

Open Google Sheets > Extensions > Add-ons > Get add-ons > Install Coefficient from Google Workspace Marketplace

Once Coefficient is installed, open it from the Extensions menu. Click “”Import from…”” and select Lever. Follow the prompts to connect your Lever account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Select Your Object

In the Coefficient sidebar, choose “”Import from Objects””.

Browse the list of Lever objects and select “”Interviews””.

Various integration options like Excel, Gmail, CSV, and Connect Any API under the Other category.

Step 3: Configure and Import Data

Refine the data you’re importing. Select specific columns like candidate name, interviewer, date, time, and status. Apply filters based on date ranges or specific candidates if needed.

Click the “”Import”” button, and your Lever interviews data will appear in your Google Sheet.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Step 4: (Optional) Set Up Auto-Refresh

Keep your interview tracking sheet current by setting up auto-refresh for your import.

In the Coefficient sidebar for your import configuration, toggle on “”Auto Refresh””. Choose a schedule (like hourly or daily) to automatically update the interview data. You can also set up email notifications.

Available Lever Objects

  • Feedback
  • Feedback Templates
  • Interviews
  • Notes
  • Opportunities
  • Panels
  • Postings
  • Profile Forms
  • Profile Form Templates
  • Requisitions
  • Requisition Fields
  • Users

block:related-resources:

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies