- Integrations
- Zapier
- Zapier: Export inspection data to Google Sheets spreadsheets
Zapier: Export inspection data to Google Sheets spreadsheets
Learn how to create a Zap to automatically export inspection data into a Google Sheets spreadsheet.
As one of the most used spreadsheets applications, Google Sheets offers a wide range of functionalities to help people analyze and visualize data. Using integration tools such as Zapier, you can automatically export your SafetyCulture inspection data to populate a Google Sheets spreadsheet, so your team can access the latest information captured by your frontline users at any time and analyze the data with ease.
If your organization uses Power Automate as the integration tool, you can create a flow that delivers an equivalent solution!
Take note
This Zap utilizes Google Sheets as the solution to store inspection data. It can be interchanged with other connectors such as Microsoft Excel Online.
The data that gets exported is based on the inspections your account has access to. Learn how to give yourself inspection access by creating access rules or assigning the "Override permissions: View all data" permission.
You will need to create a Google Sheets spreadsheet beforehand with column headers for the action data you want to export. For each header, label each response you want to export.
This Zap does not support the following inspection questions:
Questions within logic fields.
Questions within repeat sections.
Multiple-choice questions that have "multiple selection" enabled.
If you're a part of multiple organizations, please contact our customer support team for assistance in connecting Zapier to the correct SafetyCulture organization.
Please note that our customer support team can only provide limited help for single sign-on, user provisioning, and integrations via third-party platforms such as Power Automate, Power BI, and Zapier. If your organization is on the Enterprise Plan, please contact your customer success manager for assistance.
1. Inspection Completed in SafetyCulture
Click Create Zap on the upper-left of the page.
Search and select SafetyCulture under "1. Trigger".
Click the "Trigger Event" dropdown menu and select Inspection Completed.
Click Continue.
Select your SafetyCulture account from the dropdown menu. If this is your first Zap with SafetyCulture, click Sign in to SafetyCulture and then add your SafetyCulture account to Zapier by logging in.
Click Continue.
Click the dropdown menu to select the template. Please note that only the 20 most recently modified templates are shown. If the template you want to use is not on the list, select the Custom tab from the dropdown menu and enter the template's unique identifier in the text field.
Click Test trigger and click Continue once an inspection has been found.
2. Create Spreadsheet Row in Google Sheets
In "2. Action", search and select Google Sheets.
Click the "Action Event" dropdown menu and select Create Spreadsheet Row.
Click Continue.
Select your Google Sheets account from the dropdown menu. If this is your first Zap with Google Sheets, click
Connect a new account from the dropdown menu, then sign in to Google and add it to Zapier.Click Continue.
Configure the following fields:
Drive: Click the field and select the Google Drive where your spreadsheet is stored.
Spreadsheet: Click the field and select the spreadsheet file.
Worksheet: Click the field and specify the worksheet.
Column Name: The column headers you prepared in the Google Sheets spreadsheet will appear as fields to populate. Click each field and select the inspection data you want to export under "Inspection Completion in SafetyCulture". You can search for the question label within the dropdown menu and select the items that contain "Responses".
Click Continue.
Click Test & continue. This should create a spreadsheet row with the inspection data you specified.
Publish your Zap to start exporting inspection data to the Google Sheets spreadsheet. We also recommend that you name your Zap on the upper-left corner of the page.
Was this page helpful?
Thank you for letting us know.