Back to Breezy HR in Google Sheets
SheetXAI logo
Breezy HR logo
Breezy HR · Google Sheets Guide

Bulk Import Sourced Candidates Into Breezy HR From a Google Sheet

2026-05-14
5 min read

The Scenario

Your sourcing contractor delivered the list on Friday afternoon — 80 candidates for the Senior Engineer role, all in a Google Sheet: first name, last name, email, LinkedIn headline. The position's been open for six weeks. The hiring manager wants to start reviewing by Monday morning.

That means the records need to be in Breezy HR by end of day Friday.

The bad version:

  • Open Breezy HR, navigate to the Senior Engineer position, click "Add Candidate," paste the first candidate's name, email, headline, save.
  • Repeat 79 more times. Each one takes two minutes. That's two and a half hours of data entry for work that's already done.
  • Midway through, realize the LinkedIn URL column wasn't mapped anywhere in Breezy HR, so half the records are missing it and you have to decide whether to go back and add them manually.

That contractor invoice is sitting in your inbox and you're spending your Friday afternoon as a human import button. The hiring manager wants to start reviewing candidates — not wait for you to finish entering them.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sourcing data and talks to Breezy HR's API directly, so instead of opening the ATS 80 times you just describe what you want once.

Create a Breezy HR sourced candidate for every row in the "Sourcing" tab — use column A for first name, column B for last name, column C for email, column D for headline — and add them all to position ID abc123. Write the result (created / error) back into column E.

What You Get

  • 80 Breezy HR candidate records created under the Senior Engineer position, with first name, last name, email, and headline populated.
  • Column E filled with a status for each row: "created" for successes, an error message (e.g., "duplicate email") for any that didn't go through.
  • Records show "Sourced" as the entry stage, matching Breezy HR's default for externally added candidates.
  • The hiring manager can open the Breezy HR pipeline Monday morning and all 80 candidates are waiting.

What If the Data Is Not Quite Ready

The name column has full names instead of split first/last

The "Sourcing" tab has full names in column A, not split. Split each value on the first space — treat everything before the space as first name, everything after as last name — then create the Breezy HR candidate record using those values. Write results into column E.

Some rows are missing an email address

For every row in the "Sourcing" tab, skip any row where column C is blank or doesn't contain an "@" symbol. Create Breezy HR candidates only for rows with a valid email. Write "skipped — no email" into column E for the rows you skip.

The sourcing sheet spans two tabs for two different positions

The "Sourcing — Engineering" tab should go to position ID abc123 and the "Sourcing — Product" tab should go to position ID def456. Create Breezy HR candidates from both tabs using the same column structure (A: first name, B: last name, C: email, D: headline). Write results into column E on each tab.

Clean duplicates, validate emails, and import in one shot

Before creating any Breezy HR candidates, deduplicate the "Sourcing" tab on column C (email). For any email that appears more than once, keep the first row and mark the rest "duplicate" in column E. Then skip any row where the email doesn't contain "@" and a dot — mark those "invalid email" in column E. For all remaining rows, create a sourced candidate in Breezy HR under position ID abc123 and write the result into column E.

The pattern: cleaning and importing in a single instruction means you don't hand a broken file to an ATS and debug the errors afterward.

Try It

Get the 7-day free trial of SheetXAI and open any Google Sheet where your sourcing team drops candidate research, then ask it to push the whole list into Breezy HR at once. You can also look at how to export a full candidate pipeline to a sheet or bulk advance pipeline stages.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more