The new Google Sheets widget is a powerful addition to the Fusion 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 the Google Sheet. 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 Fusion Signage)
1. Create a Google Cloud API project
Visit the Google Cloud APIs & Services.
Click Create Project, give it a name, then Create.
At the top, click Enable APIs and Services.
Search for Google Sheets API and click Enable.
After it loads, click Create Credentials.
Select Application Data and click Next.
Enter a descriptive Service Account ID (more than 6 characters, starts with lowercase).
Skip optional fields and click Done.
2. Generate API key
Go to Credentials under APIs & Services.
Click +Create Credentials > API Key.
Make note of the API Key — you’ll need this for Fusion Signage.
3. Create and share your Google Sheet
Open Google Sheets, create a new sheet or use an existing one.
Copy the spreadsheet ID from the URL (between
/d/and/edit).Click Share in the top right.
Change General Access to Anyone with the link and set role to Editor.
Share the link with relevant team members – they can update data without needing a Fusion Signage login.
Handy hint – this setup enables multiple users (e.g. store managers) to update info like menus or prices in the shared sheet without editing anything else in the design.
Adding the Google Sheets widget in Fusion Signage
Log in to the Fusion Signage Portal.
Open your design or create a new one.
In the left toolbar, click Dynamic Widgets > Google Sheets.
Click Google Sheet Config at the top.
Enter your API Key and Spreadsheet ID.
Fill in the Sheet Name, Cell Column, and Row to display that specific cell's data.
Use the font style and border options in the toolbar to customise 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
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.) – not the webpage.Host your images on free platforms (like Imgur or Google Drive with proper sharing permissions) for safety and reliability.
Steps to add images:
Paste the image URL into a cell in your Google Sheet.
In Fusion Signage, add the Google Sheets Widget.
Enter the API Key and Spreadsheet ID.
Input the Cell Column and Row where your image URL is.
Click Image Settings and toggle Display URL as Image On.
