Step 2: Modify and upload main file
Now, we need to open the PHP file and give it the link to your Google Doc. Open the index.php file as plain text by using Notepad (PC) or TextEdit (Apple). When you open the file, you should be able to read the code clearly (even if you can't quite understand it). You should see something like this at the top:
Look for "CONFIGURATION OPTIONS." Just below the explanation, you'll see $feedName= followed by two tick marks. Paste the link you created in the last step in between these ticks. It should look like this when complete:
Note: the Google Docs CMS zip contains a file called test1.xml. This how the Google Docs RSS is formatted and can be used as a test or offline data source.
Now, there are a few modifications you can do to the pages to change how it functions.
1) Images can be displayed from your host or an external source. If you are familiar with FTP and can upload images yourself, leave the ticks after $externalHost= empty. Simply upload images to the /images directory and enter just the file name into the Google Doc. You can see this at work in cell G1 of the starter spreadsheet. If you don't have easy access to your web host, enter "yes" between the ticks and use direct image URLs in the Google Docs. You can upload your images to Photobucket or Flickr and display them using direct links.
2) The file is set up to display a header logo. Just place an image in the /images directory and put the file name here in between the ticks after $headLogo=. The image will be centered on the page and there is no size limit. This header will link to your home page.
3) The file can display three different pieces of information in the footer automatically, if desired: the email of the Google Doc author ($showAuthor), the date the last update was made on the Google Doc ($showUpdate), and the name of the Google Doc sheet ($showSheetName). To display this information, leave the default "yes" in between the ticks; to disable these, delete the "yes."
Once you've made these changes and saved the file, you're ready to go. Just upload this to a directory on your web host and you're ready to go. Since this file has a common name and is loaded automatically, make sure you're not copying over an existing file with the same name. If you're unfamiliar with FTP, ask for help!
Now, type the address of the file into your browser and you should see a page appear with the test spreadsheet information:
If you see the message "Invalid feed!" that means you put published the document incorrectly or the link is invalid. Check it and try again.