Google Sheets

google sheets integration the 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 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 are experiencing issues with images not loading correctly, you can limit the number of images, or the size of your images, loaded in this way if you don't have a quick internet connection increase the duration of the design when adding it to a playlist to give the 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 into the design directly as opposed to 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 ) – 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