The Scenario
You're a safety officer at a utility company and your insurance carrier requires a monthly report on all lone worker check-in jobs — who worked alone, when they checked in and out, and whether every job ended with a confirmed safe status. Your carrier wants the data for the past 30 days, and they want it as a spreadsheet. Last month you exported it from SafetyCulture manually, reformatted the columns, removed the fields the carrier doesn't use, and emailed it in. It took longer than it should have.
The carrier's deadline is tomorrow.
The bad version:
- Log into SafetyCulture and navigate to the lone worker module.
- Set the date filter to the past 30 days and export the results.
- Open the CSV, find that it has 22 columns the carrier doesn't need, and start manually deleting them.
- Realize the time fields are in UTC and your carrier's template expects the local timezone — decide how you're going to handle that with no formula in mind.
A monthly report that requires manual column surgery and timezone math every time is a process in need of a different approach.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It fetches the lone worker job records directly from SafetyCulture and writes only the columns your carrier needs — in the right timezone.
Open the SheetXAI sidebar and paste this:
Fetch all SafetyCulture lone worker jobs from the past 30 days and write user_id, user_name, start_time, end_time, and status to my Google Sheet.
What You Get
- Every lone worker job from the past 30 days written to your sheet — one row per job.
- Columns for user_id, user_name, start_time, end_time, and job status.
- Only the columns you asked for — no 22-column export to clean up.
- Jobs with a non-safe ending status are included alongside their status value so your carrier sees the full picture.
What If the Data Is Not Quite Ready
Your carrier wants times in local timezone, not UTC
Fetch all SafetyCulture lone worker jobs from the past 30 days, convert start_time and end_time from UTC to [your-timezone, e.g. America/Chicago], and write user_name, start_time, end_time, and status to my Google Sheet.
You only want jobs with status 'finished'
List all SafetyCulture lone worker jobs with status 'finished' from the past 30 days and write user_name, start_time, end_time, and status to my sheet.
You want to flag any jobs that ended in an alarm or missed check-in
Fetch all SafetyCulture lone worker jobs from the past 30 days. Write user_name, start_time, end_time, and status to my sheet. Highlight in red any row where status is not 'finished'.
Full carrier report in one shot
Fetch all SafetyCulture lone worker jobs from the past 30 days. Convert start_time and end_time to [your-timezone]. Write user_name, start_time (local), end_time (local), and status to my sheet. Highlight in red any row where status is not 'finished'. At the top, write the total job count and the count of non-finished jobs.
The carrier gets the report tomorrow without an afternoon of column cleanup.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet — then ask it to pull your SafetyCulture lone worker jobs for the past month. When you're done, see how the same workflow handles exporting open corrective actions or check the SafetyCulture integration overview.