Inspection Spreadsheet Reporting
Create a live spreadsheet with inspection data that updates every time an inspection is performed.
Setup
From the Zapier dashboard home screen, click create new Zap https://zapier.com/app/zaps
Search for and select Record360 from the trigger search bar.
Select Inspection Created from the Event dropdown
Click “continue”
From here, you’ll be prompted to log in to Record360. Simply use your Record360 username and password to authenticate
Click “test trigger”
Click “continue with selected record”
From the action search dropdown, search for and select your spreadsheet program of choice. Here, I’ll use Google Sheets.
From the action event dropdown, select “create spreadsheet row”. This will allow you to create a row for every inspection that is created in Record360. Then press “continue”.
You may be prompted to log in to google, or another spreadsheet software of your choosing
From here, you’ll need to select which spreadsheet you’d like to send data to. If you already have one, then select it from the dropdown. If not, you’ll need to create a spreadsheet first before continuing.
The headers on your spreadsheet will automatically pull into Zapier, so that you can map fields from Record360 into your spreadsheet. Select the inspection data field from the dropdown that you’d like to map to the column on your spreadsheet. This is quite flexible, but here’s an example you might use. When you’re ready, click “continue”.
From here, you’ll need to test your action, to make sure it’s working properly.
If the test is successful, you’re ready to publish your Zap! Once you publish, data will start to populate into your spreadsheet as inspections are completed in your account.
Congratulations, you’ve just automated your reporting process with Record360 and Zapier!
Extra Credit
Let’s say you only want to create reports for inspections with damage. You can achieve this by using Zapier filters, and adding a condition to only create spreadsheet rows in Google Sheets if the inspection has damage. Here are the steps for setting that up:
From your Zap, click the + icon between your trigger and your action to add a new step.
From the right hand side, click “Filter”.
From the filter dropdowns, set your conditions. In this example, we’re only going to send records to Google sheets if the “Damage” field exactly matches “True”.
When you’re ready, press “continue” to test your filter, and then hit “publish” to save your changes!