Before you begin working with a custom control interface in a Google Sheet, please make sure you have made your copy of the provided example spreadsheet. This is crucial so that you can be the owner of the spreadsheet and have full control over editing, adding, and deleting content. Learn how to do this by clicking here
Generate the token
To control your graphics through a custom control interface, it is imperative to generate a token for the Graphics Package that requires control. Detailed instructions for generating the token can be found in this article.
Replace the token
Copy the token from your graphics package.
In the spreadsheet go to the Settings tab >> replace the token.
Update Script permissions
Go to the Control tab, and try to update the score
An Authorization Required pop-up comes up. Click on OK
Choose the account
Click on Advance >> Go to API controls
Allow Access
After completing these steps you will be able to update the score and the other data from the spreadsheet.
Watch the video below to see all the steps mentioned, along with additional details:
To complete the setup of the remote control interface, refer to one of these articles, depending on the sport you are using, to familiarize yourself with the control interface and learn about additional settings: