The Rise Google Spreadsheet Widget requires the following settings:
1- The Google Spreadsheet file must be in a Google Drive folder that is Shared
2- Select 'Automatically republish when changes are made' as shown below
3- The spreadsheet file must be 'Published to the Web' as shown in the screenshot
4- When you configure the Rise Google Spreadsheet Widget, you are required to click on the Google Drive link in the Widget configuration, to select a spreadsheet.
5- Note: If logged into the Rise Vision editor with firstname.lastname@example.org, and your Google Drive/email is email@example.com, then you must have your spreadsheet SHARED with firstname.lastname@example.org.