< Warning >
I recommend you to get extra Google account only for public.
Because if you follow my procedure, your Gmail address will be on public XML file.
< Can I put adsense codes on HTML on Google Drive? >
The answer is NO. I found the important information on Google Product Forums below.
Can I place adsense codes (ads) in my google drive every doucement?
You can not place adsense codes on any documents in Google Drive. Please be careful.
< New solution on 2014/07/07 >
I wrote the post Get new version of Google Spreadsheets as JSONP. If you want to use new version of Google Spreadsheets to generate dynamic web pages instead of the old version, please read that post.
< Updated on 2014/04/26 >
Please use Anyfile Notepad or any other text editor apps for Google Drive on Google Web Store instead of Drive Notepad. Because Drive Notepad was removed from store.
< Updated on 2014/05/12 >
Hey! Drive Notepad is back to Google Web Store!
< Recommendation >
I recommend you to install “Drive Notepad”. It’s an extension for Google Drive. When you install Drive Notepad, you need Chrome. But after connecting Drive Notepad to Google Drive, Chrome is not required. You can use Drive Notepad on any browsers.
< For updating contents from Spreadsheet >
You need to use “Google Spreadsheet version 1”. Because “version 2” doesn’t support CSV and XML sharing yet. ( I wrote this post in April 19 2014. ) If you normally generate new spreadsheet today, it’s automatically be version 2.
Google explained new spreadsheet on “Check out the new Google Sheets“.
I worried about CSV and XML sharing will not support in version 2. So I checked also “Unsupported features in the new Google Sheets“. But this function isn’t listed on that page. Yep … not listed … but nobody is sure when Google change their mind….
Can you agree this situation? LOL
Let’s access https://g.co/oldsheets to generate a spreadsheet in version 1.
It’s my sample.
It’s only one sheet. It has header, 3 cols and 2 rows.
( I’m going to generate imgur image web site. )
< Let’s make it public >
Follow the pic below.
Select “Publish to the web” and push “Start publishing”.
See “Get a link to the published data” section.
You can get your spreadsheet as Web page, HTML, CSV, TXT, PDF, ATOM, RSS, XLS and ODS.
If you want to sync spreadsheet to your website, you should choose CSV, ATOM or RSS. These are easy format for syncing. When you choose one of them, you can find the function to select column and row. This function can make file size per request smaller.
If you choose CSV, before selecting range, please select a target sheet. Sample is like the pic below.
In my sample, “A1” is header. I want to get 5 rows maximum. So I set the range “A2:A6”.
< Is it difficult? >
This script is compatible with CSV, ATOM and RSS formats. It’s only URI generator. It doesn’t have parser. If you choose ATOM or RSS, you can use jQuery as a parser.
Please use “generateGoogleDriveUri.min.js” like below.
< Add index.html and Drive Notepad setting >
After you add Drive Notepad on Chrome, you can find “Text Document” on create menu of your Google Drive.
If it’s your first time to use Drive Notepad, you will be asked like below.
Push “Login and/or grant app permissions…” and accept the question below.
Please change file name to “index.html”. After saving the file, close the tab.
Please change setting about “Manage apps”.
Please check “Use by default” of Drive Notepad row.
After that, you can use Drive Notepad like the other apps on Google Drive.
< Change sharing settings >
Select your folder to set public.
After that, follow the pic below.
Set “Public on the web” checked.
Use Drive Notepad to prepare them.
Or edit with your own text editor and upload them.
My relative position is like below.
The link below is my web page created with Google Spreadsheet.
If you want, please use sources as sample.
< Extra script >
I developed imgur URL converter for my web page. If you want, please use this.