How to Change/Edit the Google Sheet in ScreenScape Sheets App

There are two ways of using Google Sheets:

1 – Use one of our pre-styled Google Sheets App powered templates.

2 – Create a Sheets powered template yourself from scratch (We covered that in this blog post)

Changing the Sheet in the app (within a Sheets powered template)

1 – Give Permission: You will need to give permission for ScreenScape to connect to your Google Account (when you first open a Sheets powered template a pop-up will show up). Enter your Google credentials into the pop-up to get started. Sometimes this pop-up is blocked by Google. We recommend you disable pop-up blocking on screenscape.com, you can read this article to learn how to allow pop-ups for “certain” sites in Chrome.

 2 – Locate the Sheet in layers tray to make edits to the sheet: Click on: drop-down arrow on Sheets App in the layer tray

3 – Click on: Edit settings

4 – Copy the URL, and paste it into your browser

5 – Making edits to the sheet: Once you have the Sheet open you will notice it is “View Only”. To be able to edit you need to make a copy

6 – To make a copy go to: File – Make a Copy. Give the new sheet a unique name. (The Sheet is now saved into your Google account)

7 – Now you will be able to make edits

8 – After you are done adding your information, copy the URL of the Sheet

9 – Paste it back into the same place the original sheet was located

10 – See the results: Now that we are back in ScreenScape editor you will see that the changes you made are now live. Picture yourself changing multiple screens in the nick of time with these simple steps 🙂

Changing the Sheet in the app (starting from scratch)

1 – Give Permission: You will need to give permission to ScreenScape to connect to your Google Account (when you first open the app a pop-up will show up). Enter your Google credentials into the pop-up to get started. Sometimes this pop-up is blocked by Google. We recommend you disable pop-up blocking on screenscape.com, you can read this article to learn how to allow pop-ups for “certain” sites in Chrome.

2 – Adding your own Sheet: Click on: drop-down arrow on Sheets App layer

3 – Click: Edit settings

4 – Paste the URL of your Google Sheet in the field that is underneath Google Sheets URL or ID

5 – Style the data: Your Google Sheet will now be in the editor. Style it like you would style any text layer. To make changes to the data go back to your Sheet and make the changes, it’s as simple as that 🙂

Have fun creating content with the powerful Sheets App!