How to use Google Sheets metadata

our google sheets integration just got an upgrade! previously, customers using the integration across multiple locations had to create separate designs for each – even though the cell layout was identical the only differences were the data values (like same menu, different prices) this meant duplicating the design and updating the sheet name for every one a bit too time consuming! to solve this, we’ve introduced metadata for google sheets similar to what we use for pos integrations like redcat and task what is metadata for google sheets? metadata allows you to override the sheet name for each screen without creating multiple designs create one design using the google sheets widget in the designer publish it to hundreds of screens each screen displays different data from your google sheet based on its metadata (tab name) please note in order to see the metadata under deploy → screen name → configure screen, you will first need to have a design saved with a google sheet widget in it this is to avoid the metadata field from appearing for everyone create your design with the google sheet widget in it first, save it, then add your metadata at the end how does it work? 1\ set up your google sheet create a google sheet with multiple sheets (tabs) – one for each variation name each sheet clearly and consistently these names will be used in fusion signage metadata keep the same cell structure across all sheets (same rows and columns for menus, prices, and so on) empty cells are fine – they simply won’t display in the design tabs at the bottom might be named store 1, store 2, store 3 these names will be entered as metadata for each screen 2\ create your design configure the google sheets widget in fusion signage ( click here to see how https //support fusionsignage com au/using fusion signage/google sheets ) enter any sheet name during design – it’s just for preview purposes when published, the metadata will override this value automatically please note the sheet name you set during design does not affect the final display if metadata is applied 3\ add metadata to your screens go to deploy → screen name → screen configuration enter the exact sheet name (tab name) as it appears in your google sheet including any spaces or capital letters for each screen accuracy matters if the name doesn’t match exactly, the override won’t work 4\ publish publish your design as usual the widget’s sheet name will be overridden by metadata, and each screen will show the correct cell values why this is a cool update saves time, one design for multiple locations reduce mistakes, no need to duplicate and manually update designs scale with ease, deploy to hundreds of screens with unique data looking for something else? we can’t wait to hear about it reach out to our sunshiney support and we'll be in touch in a flash