Effortless Integration: Adding Google Sheets Spreadsheets to Information Screens

How to use the Google Sheets App

This guide describes how to insert a Google Sheets spreadsheet on an information screen.
This guide works with spreadsheets that are online in Google Sheets.

Find the code for the desired Google Sheets spreadsheet.

1. Log in to Google Drive in a browser, and open the desired Google Sheets spreadsheet.


2. Click on File.

Google Sheets interface with 'File' tab selected and cell A1 containing text.


3. Hover over Share and select Publish to the web.
Google Sheets 'File' menu open showing 'Share' and 'Publish to the web' options.



4. Click Publish, and click OK in the popup window.
Google Sheets 'Publish to the web' dialog box with 'Embed' tab selected and 'Publish' button visible.


 

5. Copy the Integrationcode.

Embed code for Google Sheets document provided for website integration.



Now, the code needs to be inserted into the Google Sheets app.

1. Insert the Google Sheets app into your design, and paste the code into the integration code field.

Digital signage content management system with a widget to input URL for a Google Sheets document


Now the Google Sheets spreadsheet is inserted into the design. If you make changes to the spreadsheet online, those changes will also be displayed on the information screen.

Digital signage interface with an embedded Google Sheets document displayed for content editing.