How to add Google Sheets data to business dashboard

Use Octoboard integration with Google Sheets for your online business dashboard - new possibilities for Octoboard users. Try it now for free!
Octoboard MarketingAnalytics Blog
OCTOBOARD: How to add Google Sheets data to business dashboard

How to add Google Sheets data to business dashboard

Google Sheets in Octoboard

With Octoboard you can display your Google Sheets content in a business performance dashboard and combine it with other data sources such as Web Analytics, Paid Advertising, Sales of Finance.

Automate all your marketing reports and use our free Open AI connection to capture new data trends with Octoboard.

In Octoboard you can connect to any Google Sheets document and show your data in graphs, pie charts and tables. We support the following data types:

  • Single numeric value displays (with optional historic value tracking)
  • Data ranges - displayed in graphs
  • Category data - displayed in pie charts, tables or funnels.

Here is how new Google Sheets integration works in Octoboard.

How to add your Google Sheets data to a dashboard?

Access Google Sheets wizard pressing ADD METRIC button and selecting "CUSTOM DATA" tab.

Google Sheets data

2. Choose your Google Sheets File

  • Select your Google account or add a new account
  • Provide your Google account login details
  • Select a Google Sheets document
Google Sheets document selection - Octoboard wizard

3. Select data range and data visualisation


With our multiple options to visualize your data, there are always many ways to look at your data.

Your data from Google Sheets can be presented differently

Google Sheets data visualisation in Octoboard

You can also switch (change) presentation of widgets in the dashboard - use "SWITCH" menu item. Select your data first and visualize any time later. A video How-to on configuring your widget after you add it in a dashboard is here.

Automate all your marketing reports and use our free Open AI connection to capture new data trends with Octoboard.

Benefits of using Octoboard’s Google Sheets dashboard:

  • You can combine data from Google Sheets with your performance metrics from over 50 business data sources
  • Every member of your team can have access to it
  • You keep your team focused on performance figures
  • Easy to use by team members - no IT support required
  • Octoboard dashboards are free for most uses, premium plans start from just 15 USD

Start using your cloud data to grow sales, save cost and retain clients
Automate all your marketing reports and use our free Open AI connection to capture new data trends with Octoboard.
How to enable cross-channel PPC analytics with Octoboard
Your marketing Data Hub
Power all your marketing analytics, reporting and data warehouse systems - from data aggregation and cleaning to data visualisation and exports.
Build marketing data hub with octoboard
Business features include
Your marketing Data Hub
Connect PPC data sources
Clean and transform data
Export to external systems
Secure Data Warehouse access
Automated reporting
White label client portal
ChatGPT data insights
OCTOBOARD: Improve roas with advanced ppc analytics
Improve Your ROAS with Advanced PPC Analytics: A Quick Guide to Cross-Channel Reporting
Unlock the potential of your PPC campaigns with cross-channel reporting. Learn how the Octoboard platform can transform your ROAS through data-driven PPC analytics.
PPC Analytics | 15-06-2023
OCTOBOARD: Ecommerce performance metrics in automated reports
Mastering SaaS Reporting: Key Ecommerce Metrics, MRR, and Automated Insights
Supercharge your SaaS performance reporting with actionable insights from key ecommerce metrics and MRR. Discover how automating your reporting process can drive growth and optimize revenue generation for your SaaS startup.
E-Commerce Analytics | 13-06-2023
OCTOBOARD: How to use your Stripe finance metrics
How to use your Stripe finance metrics?
Tips on how to use Octoboard dashboards to monitor your finance and billing metrics for Stripe. Use it now for free!
E-Commerce Analytics | 07-05-2022
OCTOBOARD: Facebook social media dashboard
Social Media Dashboard for Facebook Released
Explore our guide on utilizing the Facebook Marketing Dashboard for effective marketing strategies. Gain insights on essential metrics and practical tips to improve your brand's online presence and engagement.
Marketing Reports | 01-05-2022
OCTOBOARD: How to use WordPress data in dashboards and marketing reports
How to add WordPress data to marketing agency report
WordPress generates data for marketing agencies and individual bloggers. Here is how you can use Octoboard to analyze WordPress data.
Marketing Reports | 16-01-2022
OCTOBOARD: QuickBooks template for business
QuickBooks Overview template for business
Octoboard launches QuickBooks Overview template where all the essential metrics are combined for you to easily access your finances online.
Marketing Reports | 14-01-2022
OCTOBOARD: How to use SendGrid data in Startup dashboard
How to use SendGrid data in Startup dashboard
Start using the metrics to successfully manage your SendGrid email marketing campaign. It's simple and free with Octoboard!
Marketing Reports | 04-01-2022
OCTOBOARD: MailChimp metrics
How to improve your MailChimp email marketing campaign - top metrics to use
Try out Octoboard's free dashboard and templates to improve MailChimp email marketing campaign using visualised all-in-one-place metrics.
Marketing Reports | 03-01-2022
OCTOBOARD: Twitter social media dashboard
Social Media Dashboard for Twitter Released
Octoboard adds Twitter Digital Media Dashboard to its Free Social suite. Use dashboard metrics to monitor your social network activity.
Marketing Reports | 02-01-2022