Companies often wish to import KPA EHS data into their own dashboards or databases. This is made possible through the KPA EHS API.
In this example, we’ll share how to automatically sync KPA EHS data into a Google Sheets document.
Now use the token and form id to create a url: (learn more)
So in this example, we’ll add in our token and form id to get:
Open that URL in a browser tab. It should download a spreadsheet of your 1000 most recent responses for that form.
Now create a new Google Sheets document and highlight the top-left cell.
Paste in this formula:
This formula imports the CSV data from your URL. The spreadsheet should now have a bunch of data.
Now you’ve imported data for right now, but what if new form responses come in?
In Google Sheets, go to File > Spreadsheet Settings > Calculation > Recalculation
That setting lets you choose how often the data will refresh.