- Integrations
- Zapier
- Zapier: Create custom inspection reports on Google Docs
Zapier: Create custom inspection reports on Google Docs
Learn how to create a Zap to automatically create custom inspection reports on Google Docs.
Google Docs templates allow you to use the same document multiple times instead of building your whole document from scratch. Using integration tools such as Zapier, you can automatically create inspection reports from a Google Docs template with SafetyCulture inspection data. This not only allows you to add custom formatting in the form of fonts, colors, and headings but also saves you time when creating standardized documentation within your organization.
Take note
This Zap utilizes Google Docs to create custom reports. Make sure you have a Google Docs template created in advance. Keep in mind that you need to prepare each field you want to populate with SafetyCulture data in the format of "{{FieldName}}", using two curly brackets to wrap a single word. We recommend that you use words that can be referred to when creating the Zap, as shown in the following example:
Data that populates the custom reports are 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.
This Zap utilizes Google Docs to create custom reports. Make sure you have a Google Docs template created in advance.
This Zap does not support media attachments, inspection questions that are within:
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 Document from Template in Google Docs
Search and select Google Docs under "2. Action".
Click the "Action Event" dropdown menu and select Create Document from Template.
Click Continue.
Select your Google Docs account from the dropdown menu. If this is your first Zap with Google Docs, click Sign in to Google Docs or 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:
Template Document: Click the field and select the Google Docs template you've created.
New Document Name: Click the field and specify the document name. You can use inspection details from the dropdown menu to create a naming convention. For example, "[1. Inspection title]".
Folder For New Document: Click the field and specify the subfolder you want to save custom reports to.
Sharing Preference: Click the field and select the access level you want to provide. You can choose from view, edit, and view/comment.
Unused Fields Preference: Click the field to select whether you want to keep the format texts, such as "{{FieldName}}", if no inspection data is available.
Field Name: The fields you prepared in the Google Docs template will become available. Click each field and select the inspection data you want to populate, under "Inspection Completion in SafetyCulture". You can search for the question label within the dropdown menu and select the items that contain "Responses".
You should see something that resembles the following example:
Click Continue.
Click Test & continue. This should create a Google Docs document with the specified fields populated.
Publish your Zap to start creating custom inspection reports on Google Docs. 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.