The Scenario
You're the IT admin at a construction company and 80 new hires are starting on-site next Monday. HR sent you an export from the HRIS — first name, last name, email, and group assignment — and every one of those people needs a SafetyCulture account before their safety induction on day one. The people team already asked you about this twice this week, and it's now Thursday afternoon.
The bad version:
- Open SafetyCulture's user management panel and click "Invite user."
- Type in the first name, last name, email, and select the group for employee 1. Send.
- Repeat 79 more times, being careful not to assign anyone to the wrong group because the site groups have similar names.
- Discover that 12 of the email addresses in the HR export have a trailing space that caused silent failures, and you have no way to know which 12 without going through the list manually.
80 manual invite flows is most of a day. Monday is not a moving target.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your new-hire roster and through the built-in SafetyCulture integration runs the bulk user upsert job — then writes the job ID and any errors back to your sheet.
Open the SheetXAI sidebar and paste this:
Initialize a SafetyCulture users upsert job with all 80 rows from my 'New Hires' sheet (first_name, last_name, email, group), then start the job and write the job_id to cell A1.
What You Get
- A bulk user upsert job initialized with every row from your New Hires sheet.
- The job_id written to cell A1 so you can reference it if you need to check status later.
- Any rows with validation errors — malformed emails, unrecognized group names — surfaced before the job runs, not discovered after the fact.
What If the Data Is Not Quite Ready
Email addresses have trailing spaces
Trim all email addresses in column C, then initialize the SafetyCulture users upsert job with all rows and write the job_id to A1.
Group names in the sheet don't match SafetyCulture exactly
The HR export uses "Site A Workers" but SafetyCulture expects the group ID, not the display name.
Look up the SafetyCulture group ID for each group name in column D, write the resolved group_id to column E, then initialize the users upsert job using column E for the group field and write the job_id to A1.
You want to check job status after it runs
Check the status of SafetyCulture upsert job [job_id from A1] and write any per-user errors to column D alongside the email address they belong to.
Full new-hire onboarding pipeline in one shot
Trim email addresses in column C, look up SafetyCulture group IDs from the group names in column D and write them to column E, initialize a users upsert job with all 80 rows using first_name (A), last_name (B), email (C), and group_id (E), start the job, write the job_id to A1, wait for completion, and write any failed rows with their error message to a new sheet called 'Errors'.
80 users in SafetyCulture before the weekend.
Try It
Get the 7-day free trial of SheetXAI and open your new-hire roster spreadsheet — then ask it to run the SafetyCulture bulk user provisioning job. When you're done, see how the same workflow handles bulk-assigning permission sets or check the SafetyCulture integration overview.