Introducing Google Sheets to Oviond

Google Sheets is a free web spreadsheet software offered by Google that is used at both personal and professional level for editing, organizing and analyzing different types of data. Here is how to use Google Sheets on Oviond.

Google Sheets is a free web spreadsheet software offered by Google that is used at both personal and professional level for editing, organizing, and analyzing different types of data. Google Sheets is part of the free Google Docs Editors suite that also includes tools such as Google Slides, Google Docs, Google Forms, and many more.

Google Sheets provides us with information pulled directly from a Google Sheet saved on your account, of which data can be visualized in various chart types including line charts, bar charts, area charts, and tables. Data from all of these report types can be viewed in dashboards and reports on Oviond.

frame_generic_light (46).png

Connecting Google Sheets On Oviond

Google Sheets connects to Oviond using your Google account login details (email address and password). This authentication only needs to be done once per Google account. Once you have connected the Google Sheets integration to one of your clients in Oviond, you will then be able to select which spreadsheet you wish to pull data for when creating a widget.

We have a comprehensive help center article that will answer all questions around the permissions, limitations, reconnecting, and possible error messages.

Data Available On Oviond For Google Sheets Widgets

In a slight deviation from how data is pulled for most of our other integrations, Google Sheets doesn’t make use of set metrics, data views, or dimensions. Instead, Oviond will be able to pull metrics directly as you have set them up in your Google Sheet columns, meaning that you will be using custom metrics in your widgets.

To help you understand the importance of structuring your data in order for it to be pulled into a reporting software, it may be useful to take a look at The Influence Of Big Data In Digital Marketing.

Using Google Sheets In Dashboards And Reports

Google Sheets can be created in dashboards and reports on Oviond and works seamlessly to neaten and pull directly into our reporting platform. We have designed the widget builder to be completely intuitive, offering you the ability to easily report on data displayed in Google Sheets, or reimagine it in the form of a graph or scorecard.

frame_generic_light (47).png

Templates Available For Google Sheets On Oviond

Because Google Sheets data in Oviond is based purely on Sheets in your Google Drive, it’s not possible to create templates for this integration. However, it is possible to create your own custom template if you wish to replicate a dashboard or report using the same Google Sheet.

Ready to create your own Google Sheets dashboards and reports now?

If you still have some questions about Google Sheets, please reach out to support.

Start Your 15-Day Free Trial Today

Discover the benefits of a customized digital marketing dashboard solution for your agency. Start your 15-day free trial today and see for yourself how Oviond can streamline your operations and enhance client satisfaction.