The Scenario
The ISO auditor arrives next week. Your training coordinator got a message from the compliance team at 4 PM asking for a sheet showing every employee's completion status across the five mandatory training courses — 120 employees, five courses, 600 rows of data. Someone tried pulling this manually during last year's audit and it took two days because SafetyCulture's UI doesn't export multi-course completion matrices cleanly.
This year the audit is Tuesday.
The bad version:
- Open SafetyCulture's training module and navigate to the first mandatory course.
- Export the completion list, open it in Google Sheets, and manually match it to the employee roster.
- Repeat for the other four courses, then try to join five separate sheets into one coherent matrix using VLOOKUP and a prayer.
Joining five exports manually is a half-day task even for someone fast at spreadsheets. The auditor doesn't care how long it took.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the training data from SafetyCulture across all courses at once and writes the completion matrix to your sheet — one row per employee-course combination.
Open the SheetXAI sidebar and paste this:
List all training course progress entries from SafetyCulture and populate my Google Sheet — one row per user-course combination — with columns for user name, course title, status, and date completed.
What You Get
- One row per employee-course pair across every training course in SafetyCulture.
- Columns for user_name, course_title, completion_status, and completion_date.
- Incomplete or not-started entries included with their status, so the auditor sees the full picture — not just the completions.
- A flat sheet that's ready to sort by employee name or filter by status with no further manipulation.
What If the Data Is Not Quite Ready
You only need the five mandatory courses, not all courses
Fetch SafetyCulture training progress for courses [course_id_1], [course_id_2], [course_id_3], [course_id_4], and [course_id_5] and write user_name, course_title, completion_status, and completion_date to my sheet — one row per user-course pair.
You want to flag employees who haven't completed all five
Pull training completion for the five mandatory courses, write one row per user-course pair with user_name, course_title, and status, then highlight in yellow any user_name where at least one of the five courses shows a non-completed status.
You need completion date in a specific format for the audit report
Fetch training completions for all mandatory courses and write completion_date in YYYY-MM-DD format — not the timestamp format SafetyCulture returns. Populate user_name, course_title, status, and formatted completion_date.
Full ISO audit prep in one shot
Fetch SafetyCulture training progress for the five mandatory courses, write one row per user-course combination with user_name, course_title, status, and completion_date in YYYY-MM-DD, highlight rows where status is not 'completed' in yellow, and at the top of the sheet write the total number of non-compliant user-course pairs.
The auditor gets a clean sheet instead of five exports duct-taped together.
Try It
Get the 7-day free trial of SheetXAI and open your training tracking spreadsheet — then ask it to pull the full completion matrix from SafetyCulture. When you're done, see how the same workflow handles exporting lesson attempt scores or check the SafetyCulture integration overview.