Getting Started With Google Sheets On Oviond
updated 4 months ago
Connecting a new integration can often be stressful. How do you know if your account is set up correctly when you're working with so many different platforms? Sometimes something as simple as a permission level can prevent you from connecting that integration to Oviond. In this article, we will be helping you understand how to get started with Google Sheets on Oviond.
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:
On Oviond, select the Google Sheets icon on the Integration page
Authenticate the integration using your Google Account login credentials
Select the Default Google Sheets Account listed in the drop-down list and click on 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. There is no option to format the date on the Google Sheets Integration at this stage. You can either type the date or days out, or you can pull the data by numbers. If you are interested in a dynamic date range on Oviond, please visit our roadmap to upvote that feature here.
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 upvote 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.
Google Sheets Limitations On Oviond
The current system Oviond uses requires numbers to draw charts. Any number that contains “,” or “$” is treated as a string.
Please check this document to understand the types of data configurations that are accepted for charts and tables on Oviond.
NOTE: Oviond format any number greater than 999 with commas.
If you have any further questions or run into any issues, please contact support.