Google Sheets App Guide

Learn how to set up Fugo’s Google Sheets app to make publishing and auto-updating awesome content from your Google account super easy!

Sarah avatar
Written by Sarah
Updated over a week ago
How to share Google Sheets spreadsheets on office TV screens with Fugo's Google Sheets widget for digital signage!

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!

Here’s how to get started

Note: there are two ways to add content with Fugo - via our playlist builder and in our design studio. We’ll cover the steps for both methods in each section.

1. Using the playlist builder

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 Authorize in the right-hand settings panel 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 Your files will now display in the right-hand panel of the app’s settings.

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 Duration for it (this determines how long your doc will display.)

1.12 Next, you can select which Sheet from your file you want to display. You can even select a certain Cell Range if you don't want to display the entire sheet.

1.13 You can increase or decrease the Zoom as well if you want a closer or further look at your spreadsheet data.

1.14 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. Using the Design Studio

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.

3. Build out your playlist

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.

Did this answer your question?