All Collections
Integrations
How to integrate WeTrack with Google Looker Studio via Google Sheets
How to integrate WeTrack with Google Looker Studio via Google Sheets

Create customised dashboards for your organisation using Google Looker Studio

Rob Davison avatar
Written by Rob Davison
Updated over a week ago

Google Looker Studio is free software from Google which allows you to create customised 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

Important: When integrating WeTrack with Google Sheets/Google Looker Studio, please note that some of your data will leave the WeTrack hosting environment. WeTrack cannot assume responsibility for its privacy and security. We advise consulting with your data protection officer to ensure compliance with privacy regulations and safeguards.

These instructions make use of a 3rd party API which is not developed by WeTrack or Google. WeTrack cannot assume responsibility for any errors, issues, or data loss associated with its use.

Setting 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

  • Run Sheet Data from the Run Sheets Module

  • Jobs Checklist Items from the Control Module

  • Indicator Updates and their associated attributes from the Sustainability Module

Note: Data feeds can only be created by users with Account Admin permissions. Please ask the WeTrack Administrator in your organisation for help if you do not have permission.

In the settings area go to Account & Configuration -> Power BI Integrations, then click "Add Power BI Feed"

This will open a modal which will allow you to select the data you want to include in your new feed. The filter types available will depend on the type of data to be included.

Setup steps:

  1. Give the feed a name

  2. In the second row, select the type of data to include in the feed (Projects, Tasks, Incidents (including logs), or Run Sheets. You can only include one type of data in a single feed. To integrate multiple data types you will need to create multiple feeds.

  3. Select any filters you want to use for your data feed. If you leave a filter empty the data feed will be unfiltered and will include all items of that type

  4. Click Save when done. Don't worry, you can always come back and update these settings later.

Tip: Use filters to create a restricted data feed for specific users where they do not need access to all items. If you are creating a dashboard that uses data across multiple functions, you may find it easier to create an unfiltered data feed, then use the filtering options inside Google Looker Studio.

Linking 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 on "Show Credentials" for the feed which you have created. This will open the screen shown below.

  • Using a separate tab, in Google Drive create a new Google Sheet and name it accordingly

  • Go to "Extensions" -> "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"

Now we will copy and paste 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, hit "Save" then hit "Run." The data should now populate into your sheet.

Adding 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 then "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 tick the box for "Use first row as header" and also "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

Creating a new Looker Studio Report

  • In looker studio, click "Create" and then "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 fed from WeTrack.

Did this answer your question?