The Scenario
Every Monday morning, the QA manager at a regional facilities company sends a weekly inspection summary to the operations team. The summary shows every inspection completed or modified in the past seven days — template name, who conducted it, the site, and the score. For the last six months, building that summary meant exporting from SafetyCulture, cleaning up the CSV, and pasting it into a Google Sheet template before 9 AM.
Today is Monday. The export is 60 rows. The meeting is at 9.
The bad version:
- Log into SafetyCulture and navigate to the inspections module with a date filter for the past 7 days.
- Export the filtered results as a CSV.
- Open the CSV, discover that the column names don't match the summary template, and start renaming them.
- Find that three rows have null scores because the inspection was started but not fully completed — decide whether to include or exclude them, and make that decision again next week.
The QA summary is a recurring artifact, not a one-time report. Rebuilding it from scratch every Monday is a systems failure disguised as a process.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It pulls the past week's SafetyCulture inspections and writes them to your summary template — in the right columns, ready to share.
Open the SheetXAI sidebar and paste this:
Fetch all SafetyCulture inspections modified in the last 7 days and write inspection_id, template_name, conducted_by, site, score, and modified_date to my Google Sheet.
What You Get
- Every inspection modified in the past 7 days written to your sheet — one row per inspection.
- Columns for inspection_id, template_name, the name of who conducted it, the site, the score, and the modified_date.
- Null scores included as blank cells — so you can decide to filter them out or flag them without having to hunt for which rows they are.
What If the Data Is Not Quite Ready
You only want completed inspections, not in-progress ones
Fetch SafetyCulture inspections with status 'completed' and modified_date in the last 7 days. Write template_name, conducted_by, site, score, and modified_date to my Google Sheet.
You want the score as a percentage, not the raw number
Fetch all SafetyCulture inspections modified in the last 7 days, calculate the score as a percentage (score / max_score * 100), and write template_name, conducted_by, site, score_pct, and modified_date to my sheet.
You want to highlight inspections below 80%
Pull all SafetyCulture inspections modified in the last 7 days with template_name, conducted_by, site, score, and modified_date. Highlight in red any row where score is below 80.
Full weekly QA summary in one shot
Fetch all SafetyCulture inspections with status 'completed' and modified in the last 7 days. Write template_name, conducted_by, site, score (as a percentage of max_score), and modified_date to my sheet starting at row 2. Highlight in red any row where score_pct is below 80. Write the total inspection count to cell A1 and the average score_pct to cell B1.
The QA summary is ready before the meeting starts.
Try It
Get the 7-day free trial of SheetXAI and open your weekly inspection summary spreadsheet — then ask it to pull the past seven days from SafetyCulture. When you're done, see how the same workflow handles exporting open corrective actions or check the SafetyCulture integration overview.