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 iAuditor 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.

This article shows you how to create a Zap to automatically export inspection data into a Google Sheets spreadsheet. If your organization uses Power Automate as the integration tool, you can create a flow that delivers an equivalent solution!

Before you begin

You must be on our Premium subscription in order to generate an iAuditor API token for the Zap.

Please note that this Zap does not support inspection questions that are within Logic fields and Repeat sections, as well as multiple-choice questions that have “multiple selection” enabled.

This Zap utilizes Google Sheets as the solution to store inspection data. Make sure you have a spreadsheet in your Google Sheets account with column headers created in advance, for each question’s response data you wish to export. If your organization does not use Google Sheets to store data, it can be interchanged with other connectors such as Microsoft Excel Online.

Please note, the data that gets exported is based on the inspections, which the account that generated the API token has access to. If you’re an administrator, learn how you can auto-share inspections to yourself or assign the “Data Access” permission to have visibility over all templates and inspections in your organization.

If you run into any errors or have any questions regarding the integration, please contact our customer support team for assistance.

1. Inspection Completion in iAuditor by SafetyCulture

  1. Log in to Zapier.
  2. Click “MAKE A ZAP” on the upper-left of the page.
  3. Search and select “iAuditor by SafetyCulture” under “1. When this happens …”.
  4. As inspection data differs between templates, you must filter by a specific template for this Zap. Select “Inspection Completion” from the list of events.
  5. Click “CONTINUE”.
  6. Select your iAuditor account from the dropdown menu. If this is your first Zap with iAuditor, click “+ Add a New Account” from the dropdown menu and add your iAuditor account to Zapier with an API token.
  7. Click “CONTINUE”.
  8. Click the dropdown menu to select the template. Please note that only the 20 most recently modified templates are shown. If the template you wish to use is not on the list, you can make a small modification in the Template Editor, then “Refresh Fields” to find the template. Click “CONTINUE” once you’ve selected the template.
  9. Click “Test trigger” and click “CONTINUE” once an inspection has been found.

2. Create Spreadsheet Row in Google Sheets

  1. Search and select “Google Sheets” under “2. Do this …”.
  2. Select “Create Spreadsheet Row” from the list of events.
  3. Click “CONTINUE”.
  4. Select your Google Sheets account from the dropdown menu. If this is your first Zap with Google Sheets, click “+ Add a New Account” from the dropdown menu, then sign in to Google and add it to Zapier.
  5. Click “CONTINUE”.
  6. Configure the following fields.
    Drive: Click the field and select the Google Drive where your spreadsheet resides.
    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 wish to export under “1. Inspection Completion in iAuditor by SafetyCulture”. You can search for the question label within the dropdown menu and select the items that contain “Responses”.
  7. Click “CONTINUE”.
  8. Click “TEST & CONTINUE”. This should create a spreadsheet row with the inspection data you specified.
  9. Turn on your Zap to start exporting inspection data to the Google Sheets spreadsheet. We recommend that you also name your Zap on the upper-left corner of the page.
Was this article helpful?

We love your feedback. Please tell us what you think.

Yes No
Care to share a bit more so we can continue to make improvements for you? Care to share a bit more so we can make this article even better for you? Thanks for your feedback!