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.

Create cross-channel PPC reports. Monitor your ad spend across all platforms 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.

Build marketing reports and keep track of your SEO and keywords rankings 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. Save time and retain clients 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: The ultimate guide to successful email marketing on woocommerce
The Ultimate Guide to Successful Email Marketing for WooCommerce stores
Learn how to boost engagement and drive sales with effective email marketing strategies for WooCommerce stores. Use Octoboard Email marketing software to increase WooCommerce sales and manage Shopping cart abandonment.
E-Commerce Analytics | 16-05-2024
OCTOBOARD: Effective email marketing for saas businesses that use stripe billing
Effective Email marketing for SaaS businesses that use Stripe billing
Complete overview of the Email Marketing for SaaS companies that use Stripe as payment engine. Read this Stripe - Email Marketing integration tutorial to effectively manage your Email Marketing campaigns with Octoboard.
E-Commerce Analytics | 13-05-2024
OCTOBOARD: Mastering cross channel ppc advertising analytics
Mastering Cross-Channel PPC Advertising Analytics: Top Metrics for Google Ads, Facebook Ads, Tiktok, Snapchat, Criteo reporting
Uncover the power of Cross-Channel Reporting in optimizing your paid advertising efforts across multiple platforms. How to use paid advertising analytics platforms such as Octoboard to build multi-channel PPC reports.
PPC Analytics | 25-04-2024
OCTOBOARD: Maximizing ecommerce performance
Using E-commerce data analytics platform: Analyzing Stripe and WooCommerce data
Discover how E-commerce Analytics can boost your online business performance with insights from E-commerce analytics platform such as Octoboard that use Stripe and WooCommerce data.
E-Commerce Analytics | 10-04-2024
OCTOBOARD: How to automate seo reports
How to automate SEO reports for marketing agency clients
Tailor your SEO reports to meet the unique needs and preferences of each client effectively. Learn about the essential metrics that should be included in your SEO reports for optimal marketing performance tracking.
Marketing Reports | 31-03-2024
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: 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: 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