The Scenario
You are an HR coordinator at a fast-growing startup. Twenty-five new hires start next Monday. Their details are in a Google Sheet — first name, last name, email, start date, department, and job title — entered by the recruiting team over the last two weeks.
Payroll runs on Friday. Every one of those 25 people needs to exist in Gusto before the payroll cutoff. It is Tuesday.
The slow version:
- Open Gusto
- Click "Add employee"
- Type in the first name, last name, email, start date, department, title
- Save
- Click "Add employee" again
- Repeat twenty-five times
- Make a typo on employee 14 that you only catch when payroll bounces
- You spend your Tuesday afternoon doing data entry instead of anything else.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your hiring sheet and creates every employee in Gusto without you opening the Gusto UI once.
Open the SheetXAI sidebar and type:
Create a new Gusto employee for every row in this sheet — columns A through F are first name, last name, email, start date, department, and job title. Write "Created" or any error back into column G for each row.
SheetXAI iterates through all 25 rows, calls Gusto's API for each new hire, and writes a status back into column G. You see at a glance which ones went through and which ones hit an error.
What You Get
Twenty-five Gusto employee records created, with a status column in the sheet showing the result for each:
- "Created" — the employee exists in Gusto and is ready for payroll onboarding
- Error message — if a row had a missing field or a formatting problem, you see the specific issue so you can fix and re-run just that row
You did not open the Gusto UI once. You did not type a name, click a save button, or tab between fields twenty-five times.
The status column also serves as your audit trail. When your VP of HR asks if all 25 people are in the system, you look at column G. Every "Created" row is confirmed.
What If the Data Is Not Quite Ready
Hiring data from recruiting teams is rarely perfectly formatted. SheetXAI handles the cleanup and the creation in the same prompt.
When some start dates are formatted inconsistently
Some rows have "2026-06-01," others have "June 1, 2026," and two have "6/1/26."
Before creating the Gusto employees, normalize all start dates in column D to ISO format (YYYY-MM-DD). Then create a new Gusto employee for every row in the sheet using columns A through F, and write "Created" or the error into column G.
When some rows are missing a department
Seven rows have the department field blank because it was not confirmed yet.
For rows where column E (department) is blank, skip the Gusto employee creation and write "SKIPPED — department missing" in column G. For all other rows, create the Gusto employee and write "Created" or the error into column G.
When you need to confirm uniqueness before creating
The recruiting team may have entered some names twice across different sheets that were merged.
Before creating Gusto employees, check column B (last name) and column C (email) for duplicates within this sheet. Write "DUPLICATE" in column G for any duplicate row. Then create Gusto employees only for the non-duplicate rows and write "Created" or the error into column G.
When you also need to write back the Gusto employee ID
Your HRIS system requires the Gusto UUID for each new hire as soon as they are created.
Create a new Gusto employee for every row in this sheet using columns A through F. Write the Gusto employee UUID back into column G and "Created" or the error into column H. If creation fails for any row, leave column G blank and write the error to column H.
The pattern: the cleanup and the creation happen in one pass. You do not run a separate deduplication step, then fix dates, then create employees. You describe the whole thing and SheetXAI does it.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with your next batch of new hire data, then ask it to create the employees in Gusto. The Gusto integration is included in every SheetXAI plan. For related workflows, see how to export the full employee roster for an HR audit or the Gusto in Google Sheets overview.