Skip to main content
Data: Plotting Activity Dashboards via Google Looker Studio (formerly Data Studio)

We have given unprecedented data access to our users - first through downloading CSV files in-app, and now via a Google Sheets integration.

Jelmer Tiete avatar
Written by Jelmer Tiete
Updated over a year ago

In this tutorial, you will learn how to create a custom Dashboard in Google Looker Studio (formerly known as Google Data Studio) to visualize your pet's data.

The steps to set up your custom report

We show details below; scroll to view all steps in sequence.

  1. Install the Google Sheets Extension

  2. Create Google Spreadsheet

  3. Add the spreadsheet as a Looker Studio Data Source

  4. Make your own copy of our template dashboard

  5. Customize your report

Details for each step

1. Install the Google Sheets Extension

Go to Google Workspace Marketplace and install the FluentPet Auto-Updater extension.

2. Create the Google Spreadsheet

  • After Installing the extension, create a new Spreadsheet in Google Sheets and click on Extensions > FluentPet Auto-Updater> Show Sidebar

  • Log In to your FluentPet account

    • Click the "Log In" button upon opening the extension sidebar. A pop-up window will appear, you will need to log onto your FluentPet account.

  • Initial Data Import

    • Once authorized, press "Update Now" to begin your first data import. This action fetches your recorded button presses and imports them into your Google Sheet.

  • Automatic Hourly Updates

    • Make sure to enable the "Enable hourly auto-updates" by checking the box next to it. This ensures your sheet is automatically updated with new button press data every hour.

3. Add the spreadsheet as a Looker Studio Data Source

  • Select Google Sheets as data source

  • Look for your FluentPet spreadsheet, here we named it "My fluentPet interactions".

  • On the top right corner, click CONNECT.

The data source is created!

4. Make a copy of the template dashboard and connect it to your data source

  • Open our example dashboard.

  • Click the 3 vertical dots in the top right corner. Then click“Make a copy”.

  • It will ask you for three new data sources -as the first one, select the recently created data source. Then click Copy Report

    Your report should now be up and running!

5. Customize your report

  1. Enter Edit mode.

  2. In the toolbar, click Theme and layout.

  3. At the top of the panel, click Customize.

  4. Use the settings in the Edit theme panel to customize the theme.

  5. You can choose background color, fonts, and text color.

Troubleshooting

  • I cannot install the Extension

    Make sure Javascript is enabled in your web browser.

Did this answer your question?