---
title: Google Sheets Integration
description: Learn how to connect Google Sheets to CommBox Signage to create dynamic content that updates automatically. Ideal for menus, pricing, schedules, and multi-location displays.
---

[Skip to content](https://support.commbox.com.au/knowledge/google-sheets-integration#main-content)

English

Show submenu for translations

[Log a ticket](https://support.commbox.com.au/knowledge/kb-tickets/new?hsLang=en) [Customer portal](https://support.commbox.com.au/portal?hsLang=en)

[![CBOX Final Logo RGB 02-1](https://support.commbox.com.au/hs-fs/hubfs/Logos/CBOX%20Final%20Logo%20RGB%2002-1.png?width=300&height=60&name=CBOX%20Final%20Logo%20RGB%2002-1.png)](https://www.commbox.com.au/)

- [Knowledge Base](https://support.commbox.com.au/knowledge)
- [System Status](https://commbox.betteruptime.com/)
- [Training Hub](https://www.commbox.com.au/training-hub)
- [My Tickets](https://support.commbox.com.au/portal)

Open main navigation

Close main navigation

- [Knowledge Base](https://support.commbox.com.au/knowledge)
- [System Status](https://commbox.betteruptime.com/)
- [Training Hub](https://www.commbox.com.au/training-hub)
- [My Tickets](https://support.commbox.com.au/portal)
- English
  
  Show submenu for translations
- [Log a ticket](https://support.commbox.com.au/knowledge/kb-tickets/new)
- [Customer portal](https://support.commbox.com.au/portal)
- [Book Training Now](https://www.commbox.com.au/book-training)

[Book Training Now](https://www.commbox.com.au/book-training)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://support.commbox.com.au/knowledge?hsLang=en)
2. [CommBox Signage](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en)
3. [Google API](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#google-api)

# Google Sheets Integration

The new Google Sheets widget is a powerful addition to the **CommBox Signage Designer** – available for customers with an Advanced or Pro Licence. It allows you to connect a Google Sheets document directly to your content, making updates quick and effortless from Google Sheets. Perfect for menus, pricing, schedules, or any dynamic data.

 Key Benefits

- Update multiple designs simultaneously without re-publishing.
- Link your Google Sheets data to specific areas on your screens.
- Fully customisable text and display styles to maintain your branding.

 Setup Steps (Outside CommBox Signage)

### 1. Create a Google Cloud API Project

1. Visit the Google Cloud APIs & Services.
2. Click **Create Project**, give it a name, then click **Create**.
3. At the top, click **Enable APIs and Services**.
4. Search for **Google Sheets API** and click **Enable**.
5. After it loads, click **Create Credentials**.
6. Select **Application Data** and click **Next**.
7. Enter a descriptive **Service Account ID** (more than 6 characters, starts with lowercase).
8. Skip optional fields and click **Done**.

### 2. Generate an API Key

1. Go to **Credentials** under APIs & Services.
2. Click **+ Create Credentials** \> **API Key**.
3. Make note of the API Key — you'll need this for **CommBox Signage**.

### 3. Create and Share Your Google Sheet

1. Open Google Sheets and create a new sheet or use an existing one.
2. Copy the spreadsheet ID from the URL (between `/d/` and `/edit`).
3. Click **Share** in the top right.
4. Change **General Access** to **Anyone with the link** and set the role to **Editor**.
5. Share the link with relevant team members – they can update data without needing a **CommBox Signage** login.

**Handy Hint:** This setup enables multiple users (for example, store managers) to update information such as menus or prices in the shared sheet without editing anything else in the design.

 Adding the Google Sheets Widget in CommBox Signage

1. Log in to the **CommBox Signage Portal**.
2. Open your design or create a new one.
3. In the left toolbar, click **Dynamic Widgets \> Google Sheets**.
4. Click **Google Sheet Config** at the top.
5. Enter your **API Key** and **Spreadsheet ID**.
6. Fill in the **Sheet Name**, **Cell Column**, and **Row** to display that specific cell's data.
7. Use the font styling and border options in the toolbar to customise the appearance.

 Dynamic Content Management

- Copy and paste the widget to display different cells or sheets.
- Change the sheet name or cell reference to pull diverse data points.
- The widget automatically updates every 15 minutes. Use the refresh button for quicker updates.

 Adding Images via Google Sheets

You can upload images directly into your Google Sheet. However, these images do not cache on the device once the design is sent to the screen. This means that every time the design loads, it will need to download the images.

If you experience issues with images not loading correctly, you can:

- Limit the number of images, or reduce image sizes, if you do not have a fast internet connection.
- Increase the duration of the design when adding it to a playlist to give images time to load.
- Ensure the screen has a stable network connection so it can download the images in real time.

Alternatively, add the images directly into the design instead of loading them from Google Sheets.

### Requirements

- The image URL must be publicly accessible (hosted on a public image site).
- It must link directly to the image file (ending in `.jpg`, `.png`, `.gif`, etc.) and not to a webpage.
- Host your images on trusted platforms (such as Imgur or Google Drive with appropriate sharing permissions) for safety and reliability.

### Steps to Add Images

1. Paste the image URL into a cell in your Google Sheet.
2. In **CommBox Signage**, add the **Google Sheets Widget**.
3. Enter the **API Key** and **Spreadsheet ID**.
4. Input the **Cell Column** and **Row** where your image URL is stored.
5. Click **Image Settings** and toggle **Display URL as Image** to **On**.

 Google Sheets Metadata Update

Our Google Sheets Integration has been upgraded to simplify multi-location designs. Previously, users had to create separate designs for identical layouts with varying data (for example, the same menu with different prices), which was time-consuming.

 Overview of Metadata for Google Sheets

Metadata allows users to override the **Sheet Name** for each screen without duplicating designs.

By creating one design with the Google Sheets widget, you can publish it across hundreds of screens, with each screen displaying unique data based on its assigned metadata (tab name).

### Setup Steps

#### Create Google Sheets

Set up a Google Sheet with multiple tabs for each variation while maintaining consistent cell structures. Name tabs clearly, as these names will be used as metadata.

#### Design Creation

Use the Google Sheets widget in **CommBox Signage**. The initial **Sheet Name** is for preview purposes only; metadata will override it when published.

#### Add Metadata

Navigate to:

**Deploy → Screen Name → Screen Configuration**

Enter the exact tab name for each screen. Accuracy is essential for the override to work correctly.

#### Publish

After configuration, publish your design. Metadata will ensure each screen displays the correct data values.

 Benefits of This Update

- Saves time by allowing one design to serve multiple locations.
- Reduces errors by eliminating the need for duplicate designs.
- Improves scalability by enabling deployment to hundreds of screens with unique data.

- [General CommBox Product Information](https://support.commbox.com.au/knowledge/general-commbox-product-information?hsLang=en#main-content)

    - [FAQ](https://support.commbox.com.au/knowledge/general-commbox-product-information?hsLang=en#faq)
    - [How to](https://support.commbox.com.au/knowledge/general-commbox-product-information?hsLang=en#how-to)
    - [Compatability](https://support.commbox.com.au/knowledge/general-commbox-product-information?hsLang=en#compatability)
    - [Troubleshooting](https://support.commbox.com.au/knowledge/general-commbox-product-information?hsLang=en#troubleshooting)
    - [User Guides](https://support.commbox.com.au/knowledge/general-commbox-product-information?hsLang=en#user-guides)
- [CommBox Classic S5](https://support.commbox.com.au/knowledge/commbox-classic-s5?hsLang=en#main-content)

    - [Get Started](https://support.commbox.com.au/knowledge/commbox-classic-s5?hsLang=en#get-started)
    - [Firmware Releases](https://support.commbox.com.au/knowledge/commbox-classic-s5?hsLang=en#firmware-releases)
    - [How To](https://support.commbox.com.au/knowledge/commbox-classic-s5?hsLang=en#how-to)
    - [Troubleshooting](https://support.commbox.com.au/knowledge/commbox-classic-s5?hsLang=en#troubleshooting)
    - [Known Issues](https://support.commbox.com.au/knowledge/commbox-classic-s5?hsLang=en#known-issues)
- [CommBox Classic S4](https://support.commbox.com.au/knowledge/commbox-classic-s4?hsLang=en#main-content)

    - [Get Started](https://support.commbox.com.au/knowledge/commbox-classic-s4?hsLang=en#get-started)
    - [How to](https://support.commbox.com.au/knowledge/commbox-classic-s4?hsLang=en#how-to)
    - [Troubleshooting](https://support.commbox.com.au/knowledge/commbox-classic-s4?hsLang=en#troubleshooting)
    - [Firmware Releases](https://support.commbox.com.au/knowledge/commbox-classic-s4?hsLang=en#firmware-releases)
    - [Known Issues](https://support.commbox.com.au/knowledge/commbox-classic-s4?hsLang=en#known-issues)
- [CommBox Classic V3 & V3X](https://support.commbox.com.au/knowledge/commbox-classic-v3-v3x?hsLang=en#main-content)

    - [Firmware Release](https://support.commbox.com.au/knowledge/commbox-classic-v3-v3x?hsLang=en#firmware-release)
    - [How to](https://support.commbox.com.au/knowledge/commbox-classic-v3-v3x?hsLang=en#how-to)
    - [User Guide](https://support.commbox.com.au/knowledge/commbox-classic-v3-v3x?hsLang=en#user-guide)
    - [Troubleshooting](https://support.commbox.com.au/knowledge/commbox-classic-v3-v3x?hsLang=en#troubleshooting)
    - [Known Issues](https://support.commbox.com.au/knowledge/commbox-classic-v3-v3x?hsLang=en#known-issues)
- [CommBox Neo](https://support.commbox.com.au/knowledge/commbox-neo?hsLang=en#main-content)

    - [How to](https://support.commbox.com.au/knowledge/commbox-neo?hsLang=en#how-to)
    - [Troubleshooting](https://support.commbox.com.au/knowledge/commbox-neo?hsLang=en#troubleshooting)
- [CommBox Atom](https://support.commbox.com.au/knowledge/commbox-atom?hsLang=en#main-content)

    - [Get Started](https://support.commbox.com.au/knowledge/commbox-atom?hsLang=en#get-started)
    - [Firmware Releases](https://support.commbox.com.au/knowledge/commbox-atom?hsLang=en#firmware-releases)
    - [How to](https://support.commbox.com.au/knowledge/commbox-atom?hsLang=en#how-to)
    - [User Guide](https://support.commbox.com.au/knowledge/commbox-atom?hsLang=en#user-guide)
    - [Troubleshooting](https://support.commbox.com.au/knowledge/commbox-atom?hsLang=en#troubleshooting)
- [CommBox Display](https://support.commbox.com.au/knowledge/commbox-display?hsLang=en#main-content)

    - [Commercial Displays V4](https://support.commbox.com.au/knowledge/commbox-display?hsLang=en#commercial-displays-v4)
    - [Meeting Room Display](https://support.commbox.com.au/knowledge/commbox-display?hsLang=en#meeting-room-display)
    - [Intelligent Display](https://support.commbox.com.au/knowledge/commbox-display?hsLang=en#intelligent-display)
    - [Meeting Room Display Gen 2](https://support.commbox.com.au/knowledge/commbox-display?hsLang=en#meeting-room-display-gen-2)
    - [Intelligent Display Gen 2](https://support.commbox.com.au/knowledge/commbox-display?hsLang=en#intelligent-display-gen-2)
- [CommBox OS](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#main-content)

    - [CommBox OS Apps, Tools and Bundles](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-os-apps-tools-and-bundles)
    - [CommBox OS Exp](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-os-exp)
    - [CommBox OS Accounts](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-os-accounts)
    - [CommBox OS Exp Autofill](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-os-exp-autofill)
    - [CommBox AI](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-ai)
    - [CommBox Store](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-store)
    - [CommBox Connect](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-connect)
    - [CommBox Connect powered by Airserver](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-connect-powered-by-airserver)
    - [CommBox Connect powered by EShare](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#commbox-connect-powered-by-eshare)
    - [Phonemes App](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#phonemes-app)
    - [Planner App](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#planner-app)
    - [Posters App](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#posters-app)
    - [Quotes App](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#quotes-app)
    - [Reveal App](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#reveal-app)
    - [Rewards App](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#rewards-app)
    - [Spinner App](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#spinner-app)
    - [Timer App](https://support.commbox.com.au/knowledge/commbox-os?hsLang=en#timer-app)
- [CommBox Signage](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#main-content)

    - [Signage Player](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#signage-player)
    - [Designer and Templates](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#designer-and-templates)
    - [Settings](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#settings)
    - [SSO](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#sso)
    - [Screens](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#screens)
    - [Manage](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#manage)
    - [Integrations](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#integrations)
    - [Google API](https://support.commbox.com.au/knowledge/commbox-signage?hsLang=en#google-api)
- [CommBox Horizon](https://support.commbox.com.au/knowledge/commbox-horizon?hsLang=en#main-content)

    - [How to](https://support.commbox.com.au/knowledge/commbox-horizon?hsLang=en#how-to)
- [CommBox Manage](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#main-content)

    - [Device Enrolment & Management](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#device-enrolment-management)
    - [Admin & Customisation](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#admin-customisation)
    - [Updating](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#updating)
    - [Credits & Licensing](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#credits-licensing)
    - [Support & Maintenance](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#support-maintenance)
    - [Groups & Tags](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#groups-tags)
    - [Messaging & Remote Access](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#messaging-remote-access)
    - [Overview](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#overview)
    - [Network & Security](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#network-security)
    - [Trial & Downloads](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#trial-downloads)
    - [User Guide](https://support.commbox.com.au/knowledge/commbox-manage?hsLang=en#user-guide)
- [CommBox LED](https://support.commbox.com.au/knowledge/commbox-led?hsLang=en#main-content)

    - [CommBox LED Board - Gen 1](https://support.commbox.com.au/knowledge/commbox-led?hsLang=en#commbox-led-board-gen-1)
    - [CommBox LED Board - Gen 2](https://support.commbox.com.au/knowledge/commbox-led?hsLang=en#commbox-led-board-gen-2)
- [CommBox Accessories](https://support.commbox.com.au/knowledge/commbox-accessories?hsLang=en#main-content)

    - [Soundbar](https://support.commbox.com.au/knowledge/commbox-accessories?hsLang=en#soundbar)
    - [InstallMate](https://support.commbox.com.au/knowledge/commbox-accessories?hsLang=en#installmate)
    - [OPS (Mini PC's)](https://support.commbox.com.au/knowledge/commbox-accessories?hsLang=en#ops-mini-pcs)
- [Karter AV Furniture](https://support.commbox.com.au/knowledge/karter-av-furniture?hsLang=en#main-content)

    - [Combi](https://support.commbox.com.au/knowledge/karter-av-furniture?hsLang=en#combi)
    - [Elegance](https://support.commbox.com.au/knowledge/karter-av-furniture?hsLang=en#elegance)
    - [Urban](https://support.commbox.com.au/knowledge/karter-av-furniture?hsLang=en#urban)
    - [Invisible In-Wall Bracket](https://support.commbox.com.au/knowledge/karter-av-furniture?hsLang=en#invisible-in-wall-bracket)
    - [Tilt](https://support.commbox.com.au/knowledge/karter-av-furniture?hsLang=en#tilt)
    - [Dash](https://support.commbox.com.au/knowledge/karter-av-furniture?hsLang=en#dash)
    - [Easel](https://support.commbox.com.au/knowledge/karter-av-furniture?hsLang=en#easel)
- [Older CommBox Products](https://support.commbox.com.au/knowledge/older-commbox-products?hsLang=en#main-content)

    - [Pulse](https://support.commbox.com.au/knowledge/older-commbox-products?hsLang=en#pulse)
    - [Joey](https://support.commbox.com.au/knowledge/older-commbox-products?hsLang=en#joey)
- [CommBox](https://support.commbox.com.au/knowledge/commbox?hsLang=en#main-content)

    - [Customer Success](https://support.commbox.com.au/knowledge/commbox?hsLang=en#customer-success)

[![Chill listening crop-3](https://support.commbox.com.au/hs-fs/hubfs/CBOX%20Final%20Logo%20RGB%2001-2.png?width=119&height=24&name=CBOX%20Final%20Logo%20RGB%2001-2.png "Chill listening crop-3")](http://commbox.com.au)

32A/6 Jubilee Ave, Warriewood NSW 2102 Australia

+61 2 99756001

<https://www.facebook.com/CommBoxTech> <https://www.instagram.com/commboxaus> [mailto:sales@commbox.com.au](mailto:sales@commbox.com.au) <https://www.linkedin.com/company/commbox/> <https://www.youtube.com/channel/UC04w9Hs4SonT5bIhkosKzrQ>

Copyright © 2025, CommBox