SlideRocket tables can be linked to Google Spreadsheets, with the table automatically populated with the most up-to-date information in the spreadsheet. There are 2 options for linking a table to a Google Spreadsheet:

• Google Apps Spreadsheet list (Google Apps users only)
• Public URL Link (all users)

Before a SlideRocket table can be linked to a Google Spreadsheet the spreadsheet must first be Published as a web page.

This document covers

• Uploading a File to Create a Google Apps Spreadsheet
• Publishing a Google Spreadsheet as a Web Page
• Linking a Table to a Google Spreadsheet Using the Publish URL Link
• Linking a Table to a Google Spreadsheet Using the Google Apps Spreadsheet List

Uploading a File to Create a Google Apps Spreadsheet

1. Log in to Google Docs
2. Click Upload button 
3. Select Files...
4. Find spreadsheet on computer
5. Click Open
6. Choose preferred Upload settings for Google Docs
7. Click Start upload

Publishing a Google Spreadsheet as a Web Page

1. Open spreadsheet in Google Docs
2. Click File
3. Select Publish to the Web...
4. Check Automatically republish when changes are made
5. Click Start publishing
6. Copy and paste link to public data into SlideRocket
7. Click Close

ADVANCED NOTE: Formatting from the Google Doc is not preserved. The SlideRocket theme’s default style for tables will be applied instead.

Linking a Table to a Google Spreadsheet Using the Publish URL Link

Before the Google Spreadsheet can be linked to a SlideRocket table, the spreadsheet must first be published as a web page. For instructions on how to publish a Google Spreadsheet to a website click here.

1. Open presentation in Presentation Editor
2. Select table to link to Google Spreadsheet
3. Click Element-Specific Properties tab 
4. Click Link to Google Spreadsheet... 
5. Paste the spreadsheet publish URL 
6. Check Keep this table synchronized with the Google spreadsheet to have table automatically update when Google spreadsheet is updated
7. Click Ok

ADVANCED NOTES:

• Google has a 5- to 10-minute delay before publishing changes so updates made to a spreadsheet will not appear in SlideRocket immediately
• If the table is not set to automatically synchronize with the spreadsheet, the table can be manually synchronized by clicking Refresh Google Spreadsheet in the menu to the right
• Tables can be linked to Google Spreadsheets with up to 20 columns and 20 rows
• The formatting of the SlideRocket table will revert to the default for that theme every time the table is synchronized to the Google spreadsheet

Linking a Table to a Google Spreadsheet Using the Google Apps Spreadsheet List

Before the Google Spreadsheet can be linked to a SlideRocket table, the spreadsheet must first be published as a web page. For instructions on how to publish a Google Spreadsheet to a website click here.

1. Open presentation in Presentation Editor
2. Select table to link to Google Spreadsheet
3. Click Element-Specific Properties tab 
4. Click Link to Google Spreadsheet...
5. Select spreadsheet from list
6. Click Ok

ADVANCED NOTES: 

• All spreadsheets you have access to will appear in this list whether they are published or not
• Google has a 5- to 10-minute delay before publishing changes so updates made to a spreadsheet will not appear in SlideRocket immediately
• If the table is not set to automatically synchronize with the spreadsheet, the table can be manually synchronized by clicking Refresh Google Spreadsheet in the menu to the right
• Tables can be linked to Google Spreadsheets with up to 20 columns and 20 rows
• The formatting of the SlideRocket table will revert to the default for that theme every time the table is synchronized to the Google spreadsheet