Google sheets permissions

There are no permission limitations when connecting Google Sheets with Oviond. The spreadsheet doesn’t need to be shareable in order to pull data into Oviond.

Connecting Google Sheets to Oviond

To connect your Google Sheets account to Oviond, you need to have login credentials to a Google Account that has access to the spreadsheet.

Follow the instructions to connect Google Sheets to Oviond:

  1. Open Oviond and navigate to the client you wish to connect Google Sheets to.

  2. Click on Google Sheets.

  3. Enter a name for the authentication and click Next.

  4. An authentication pop-up will appear. Click the Google Account you wish to connect and then click Allow.

  5. Click the Google Sheets default account and click Save.

NOTE: There will only be a default account listed, as there is only one account that will ever be connected to that one email address.

Configuring your Google sheet to pull data into Oviond

Oviond will pull data from a Google Sheet according to its columns. The first row of every column will be the metric you can select on Oviond under the measures drop-down list.

If you are looking to pull data for clicks and impressions over time, you will need three columns. The first row of each column will read DATE, CLICK, IMPRESSION.

With our Google Sheets integration, what you see on Google Sheets is what you will be presented with on Oviond, either in a table or chart according to the exact data that appears on the sheet.

Creating a Google Sheets widget on Oviond

When you create a widget for Google Sheets on Oviond, it will first ask you to select the spreadsheet that you want to pull data from. You can search the spreadsheet by name or scroll down the drop-down list in the widget builder.

Once you have selected the spreadsheet, the next step is to select the sheet you want to pull data from. Once again, you can either search for the sheet by typing in the name or scroll down the drop-down list in the widget builder.

The last selection is to select your metrics. Once again, the metrics will be listed according to what is on the first row of your columns. If you would like to pull a trend over time, make sure to select the metric DATE first.

Once you have selected all the metrics you would like to report on, you can choose your chart type and create your widget!

Google Sheets date ranges

At this stage, you are not able to format the date on the Google Sheets Integration. You can either type the date or days out in Column 1 of your spreadsheet, or you can pull the data by numbers. If you are interested in a dynamic date range on Oviond, please visit our roadmap to up vote that feature here.

However, if you make any changes to your sheet and would like that data to reflect in your widget on Oviond, you can use the refresh icon to refresh the data that is getting pulled through from your reports or dashboards.

If you would like to add an entirely new column of data onto your Oviond charts and tables, you would need to edit the widget to specify the new set of data you would like to pull through.


Displaying column totals for Google Sheets on an Oviond table chart type

It is possible to display totals for data from Google Sheets.

NB! You need to make sure that your Google Sheets data is correctly formatted, e.g. columns containing numbers are formatted as numbers, columns containing percentages are formatted as percentages etc

Click on the widget containing the Google Sheets table, from the widget setup slide over toggle "Show Totals" switch

Searching and filtering columns in an Oviond table chart type

It is possible to filter, sort and search on a table chart where Google Sheets is your data source.

NB! You need to make sure that your Google Sheets data is correctly formatted, e.g. columns containing numbers are formatted as numbers, columns containing percentages are formatted as percentages etc

Did this answer your question?