The default Refresh Interval of the Google Spreadsheet Widget is 60 minutes. To use a different Refresh Interval you’ll need to provide your own API Key.
Step 1:
Generating an API Key requires that you create a Project on the Google Developer Console. You can use this wizard to both create a new Project, and generate an API Key.
- Agree to the Terms of Service. Select Yes, and then Agree and continue.
- Click Go to credentials.
- In the My Project Window, click on Credentials in the side menu, and then from the Create Credentials dropdown, select API Key.
Step 2:
That's all you need! Now you have your API Key!
Copy and paste the API Key into the API Key field on the Spreadsheet Widget Settings.
Once entered into the Widget Settings, you’ll be able to use a refresh rate other than 60.
The lowest refresh interval possible with the google spreadsheet widget is 10 minutes.