Google Looker Studio is free software from Google which allows you to create customized dashboards and reports. This integration allows you to create a live data link between Looker Studio and WeTrack via Google Sheets, which can be updated at regularly scheduled intervals. At present a direct integration using the HTTP method provided by WeTrack is not available in Looker Studio.
In this article:
- Set up a Data Feed
- Link WeTrack to Google Sheets
- Add the Google Sheet as a data source in Google Looker Studio
- Create a new Looker Studio Report
Set up a Data Feed
WeTrack allows you to set up multiple data feeds. Each data feed can be custom filtered to provide a discrete data set to the end user. Data feeds can be established for:
- Incidents and Logs from the Control Module
- Projects and Tasks/Milestones from the Planning Module
- Jobs Checklist Items from the Control Module
- Incident Checklist Items from the Control Module
- Indicator Updates and their associated attributes from the Sustainability Module
- Risks and Actions from the Risk Module
To set up the data feed:
- Go to Settings > Account & Configuration > PowerBI Integrations and select Add PowerBI Feed or Add. The Add PowerBI Feed modal opens.
- In the Title field, name the feed.
- Select the type of data to include in the feed. You can only include one type of data in a single feed. To integrate multiple data types, create multiple feeds.
- In the remaining fields, select any filters to use for the data feed. If you leave a filter empty, the data feed will be unfiltered and will include all items of that type
- Click Save. The feed can be updated as needed once created.
Link WeTrack to Google Sheets
Once you have set up the data feed you can complete the connection between WeTrack and Google Sheets. The data in Google Sheets will form the data source for your Looker Studio report.
- If not open already, click Show Credentials for the feed which you have created. The PowerBI Integration Details modal opens.
- Using a separate tab, create a new Google Sheet in Google Drive and name it accordingly.
- Go to Extensions >Add-ons > Get add-ons.
- Search for API Connector (Direct link here).
- Click Install when prompted.
- Return to your Google Sheet. You may need to reload the page.
- Go to Extensions > API Connector > Manage Connections.
- When API Connector Opens, click Create Requests.
- Add the data from the WeTrack Power BI Integration Details page to API Connector:
- Copy the URL and paste it into the Request URL field in API Connector.
- Copy the Header Parameters field and paste it into the Key field under Headers.
- Copy the Credentials value and paste it into the Value field under Headers.
- Select cell A1 in your sheet, then in the Output Settings Section, select the Set Current button. You may need to click this more than once.
- In the Save and Run Request section, give this feed a name, click Save then click Run. The data should now populate into your sheet.
Add the Google Sheet as a data source in Google Looker Studio
Once the link is created between WeTrack and Google Sheets, you can now create the link between the sheet and Looker Studio.
- In Google Looker Studio, click Create and select Data source.
- Select Google Sheets from the list of possible data connectors. The Google Sheet should be in your Google account or shared with you.
- Select the sheet that you linked with WeTrack. Make sure to select Use first row as header and Include Hidden and Filtered Cells.
Your data is now connected between WeTrack and Google Looker Studio. To refresh the data, in API Connector you can manually request a refresh, or you can set a schedule. We suggest a refresh rate of no more than once an hour to ensure system performance
Create a new Looker Studio Report
To create a new report, in Looker Studio, click Create and select Report. When the data source selector opens, click My Data Sources and then select the new data source you've created in the steps above. From here, you will be able to create a report using your data feed from WeTrack.