Need a neat way to display your spreadsheets straight to your screens? With our free Google Sheets App, you can link your Google account easily to your screens to display spreadsheets that update as changes are made. This means you can create a live display without having to upload and publish each file/edit. Instead, when you update your Google Sheets, your edits will automatically be synced straight to your screens.

Whether you want to show spreadsheets or graphs, this tool will help you to keep your screens looking slick. Perfect for meeting rooms, offices, and more! Google Sheets is an effortless and easy solution to show your numbers on your screen network. With both Google Sheets and Fugo being cloud-based you can access your slides from any computer at any time too!

The Google Sheets App is perfect for business use and a neat way to display revenues, targets, and much more! Your screens will even update without having to stop playback

So whether you want to edit a sheet slightly or add a new spreadsheet to your showreel, your changes will be synced seamlessly and quickly. Just like they should be!

When it comes to displaying your Google Sheets on digital signage screens, it's important to choose the right view type that suits your needs. Our integration has two primary methods to present your Google Sheets: Public and PDF. Each method has its unique advantages and considerations.
​

The Public view type is designed for Google Sheets that are made publicly available. This method embeds the sheet directly into the display, providing a live and interactive view of your data. Changes made to the sheet are reflected in real-time, and so are always fully accurate.
​

Using the Public view is ideal for scenarios where you need to share live data without any restrictions. However, it's important to ensure that your sheet is set to public access, as restricted sheets won't be viewable in this mode.
​
If your organization restricts "Sharing outside of ..." then this view type will not work, as the sheet must be public.
​

The PDF view type converts your Google Sheet into a static PDF page which is updated every couple minutes. The PDF view is especially advantageous when your organization restricts public sharing of content.
​

The PDF view provides more control over the formatting, allowing you to customize the orientation, scale, gridlines and margins. Another upside is that the sheet will be cached on the player, so offline playback will work.

1.1 Log into your Fugo Account. If you don’t have an account yet, you can start your 14-day free trial here.

1.2 Click Apps in the top navigation bar to get to our app store.

1.3 Scroll to find the Google Sheets app in the store. To find it even faster, you can search for it via the search bar at the top of the store.

1.4 Click Try App to create a new playlist with the app.

1.5 A window will appear prompting you to choose the screen, channel, or existing playlist where you'd like to publish this app instance. If you don't have a Screen or Channel created, you can create one now from the prompt. You can also create a new playlist if you have no existing playlists or want to create a new playlist with this app instance.

​1.6 Next, a window will open where you can customize the app’s settings.

​1.7 First, click Sign in in order to give Fugo access to your Google account.

1.8 This will open a new pop window asking you to sign in to your Google account and authorize Fugo to access your files. Click Allow in the bottom right-hand corner.

1.9 You are now verified and ready to use the app! Click Select Item to begin.

​1.10 You can scroll through your files to select the one you want to display. You can also search for it by name in the search bar at the top.

​1.11 After you've selected your sheet, set the View Type that most appropriate for you. Don't worry - if one of the views doesn't work for you, we'll display a warning.

1.12 Each View Type has various formatting options so you can get your Google Sheet exactly as you want it.

1.13 When you’re all done, click Save Changes in the bottom right corner.

To continue on to publishing instructions from here, you can skip to section 3: build out your playlist.

2.1 Click Studio in the top navigation bar. Then click Create in Studio to start a new design.

2.2 This will open up a blank canvas for you to start adding content to! To add the Google Sheets app, either scroll to find it in the Apps menu to the right or search for it to find it faster.

2.3 Drag and drop the app onto your canvas from the menu. Or simply click on it and it will be added to your current slide.

2.4 You can drag the sizing handles of the app around to change the size. Make it smaller so you can split your screen and add other content, or make it full screen - that’s totally up to you!

2.5 Customizing the Google Sheets app settings works the same way in the design studio - all settings will be found in the panel to the left. To bring up the panel, click on the app from the canvas.

You can sign in, choose your sheet, and continue to customize your content however you wish in the studio! Add media from one of our integrations, add stickers, use frames to create unique media stylings. Add slides with extra or duplicate content. You can even split your screen into zones!

2.6 When you’re satisfied with how your content looks, click Save and Close. This will close out the design studio. To publish this content, you’ll need to add it to a playlist, which we’ll cover in the next section.

Note: If you want to add content you created in the studio to a playlist. You’ll need to navigate to the Playlists page by clicking Playlists in the top navigation bar and Create Playlist to start a new playlist.

3.1 Give your playlist a name (we suggest making it something relevant to distinguish it from other playlists later on down the road.)

3.2 Click Select Screens to choose where to publish your playlist.

3.3 You can also add more content to your playlist by clicking Add More Content and choosing other apps, uploading media, or from the content that you created in the studio.

I want to add the content I created in section 2 above, so I'm going to find it by clicking Studio Content and searching for it in my content library.

3.4 When you've selected all the content items you want to add to this playlist, click Add Items in the bottom right corner.

3.5 Finally, you can change the schedule of your content by setting the start and end date and clicking Week Schedule to edit the days and times your content will run.

3.5 Once you’re all done setting up the playlist, click Publish in the bottom right-hand corner of the screen to publish or schedule your content.

3.6 If you don’t want to publish just yet, you can click Finish Later and come back to your playlist at any time.

And there you have it! If you find yourself still scratching your head, you can contact our team for help any time at support@fugo.ai.