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 email@example.com, and your Google Drive/email is firstname.lastname@example.org, then you must have your spreadsheet SHARED with email@example.com.