Thursday, October 26, 2006

Publishing to Blogger beta using Google Docs & Spreadsheets

Google Docs & Spreadsheets is a fine tool for composing documents online. The advantages of using Google Docs & Spreadsheets is conversation for another day, but I will tell you this - how you can compose and publish your blog posts from Google Docs & Spreadsheets to Blogger beta. So the obvious question is why would you want to compose your posts in GD&S rather than using the built-in editor provided by Blogger beta?

  • Auto save - You will not lose your post if you inadvertently close the tab/browser. GD&S constantly auto saves your document at regular intervals.
  • Spell checking - The Blogger beta post editor provides no means to spell check your posts.
  • More control - GD&S provides advanced options when inserting rich elements like images, links, and tables into your posts.
  • Interface - The editing interface of GD&S is more akin to a full featured document editor.

Although GD&S does not support publishing to Blogger beta directly, I have successfully been able to configure GD&S to publish to Blogger beta. GD&S help center provides documentation on how to publish your documents on any blog, but these will generally not work for Blogger beta. To publish to Blogger beta using GD&S:
  1. Click on "Settings" in the upper right corner of your GD&S home page.
  2. In the "Documents" tab, select "edit info" in the "Blog settings" section.
  3. In the "Blog Site Settings" dialog,
    1. Choose My own server / custom
    2. API: Blogger API
    3. URL:
    4. Enter your user name and password
    5. (Optional) Enter your Blog ID/Title
      1. If you host multiple blogs on Blogger beta, I strongly recommend entering the Blog ID/Title to ensure that your posts are published to the desired blog.
    6. Select any desired options

You are done!

Full Disclosure: Tecnirvana runs on Blogger beta. This post was published using Google Docs & Spreadsheets.

Update: I have discovered that publishing from GD&S does not provide a title to your post. This means that you will not get a permalink to your post. I have edited this post in Blogger beta editor to give it a title.

Tags: , ,


Roger said...

Posting to Blogger Beta works fine (well sort of) now. Although a GD&S header looks OK, you are write that it doesn't generate the permalink. I've had to do the same as you and re-edit the post. Sort of defeats the purpose.

Anyhow, my first posting is

Abhishek Ghuwalewala said...

@Roger: I completely agree with you. This completely defeats the purpose. I have reported it in the the Google Docs & Spreadsheets discussion group. I am hoping they (Blogger folks, or GD&S folks) will get it resolved one way or another.

InGinouity said...

Abishek, I still can't publish to my Blogger Beta blog from Google. I have followed your instructions to the letter, but when I publish, or try to, it says:

There was an expected problem (Connection reset)

Any idea?


Abhishek Ghuwalewala said...

@InGinouity: I am not sure why this is not working for you. I was suspecting that a change from the Blogger beta feature completion milestone may have broken this functionality, but I tried publishing a new post with the same settings as I have mentioned in the tutorial and everything worked as expected.

I have tested Windows Live Writer and that has worked beautifully as well. Can you give that a try and let me know if it works for you? If that does not work either, I suspect that this is a problem in the way the blog is configured.

Sweetie Pie said...

Thank you, thank you, thank you...I don't know much about all this stuff, but I was able to get my GD&S spreadsheet to finally post on my blog:

Thank you for the help.

Sweetie Pie said...

Help! It was there, and now it's not...I didn't change anything...there's now just a blank spot where the spreadsheet appeared the first time...does it have to refresh or something?

Sweetie Pie said...

One more appears that if I hit the little "tool" icon to edit the "Page Element," change nothing, then click "Save Changes," I at least get a box for the spreadsheet...but now the spreadsheet itself is not appearing...can you ehlp with this or should I be writing in a different group? Thank you.

Kasper said...


Anonymous said...

Hi - silly question probably; I followed the instructions and ran 'text' and got the confirmation that everything is ready to go. Now how do I post a spreadsheet to my blog? I don't see any button or link that does that with in GD&S ... or does it only do docs?

Abhishek Ghuwalewala said...

@Anonymous: Unfortunately, GD&S does not provide an option to publish a spreadsheet to your blog. You can publish the spreadsheet to the web and link it from your blog.

The Bit Bucket said...

Thanks for the Tip! This has been bugging me for a little while, and I was really glad to be able to fix it.

Your directions where right on and it worked like a Charm. Thanks again Abhishekg!

Mike Scott
The Bit Bucket

When Getting New Features Means that Old Features don't work anymore

Ouida said...

Thanks for this solution. Now if I could get the layout to work.

Anonymous said...

of what use is this hack if we cant get title on post?

Melody Lam said...

It's kinda ironic how Blogger, a product of Google, supports the least features of Google Docs and Spreadsheets. :(
I write my posts offline (it's a fiction blog) in Openoffice and it's hard to copy and paste the post without it getting the formatting in OO, so I use Google Docs. It's not hard going back and putting the title back in, actually, since once you're logged onto Docs you're logged into Blogger, so it isn't that painful. Thanks for the hack, though, it's helpful.

Rajiv Abraham said...

Hi Abhishek :),
Thanks a lot. I was stumped by this for quite some time :)

btw, is there any update about showing the title of a Google D & S doc in blogger yet?

Thanks again,

Anonymous said...

Welcome to our website for you World of Warcraft Gold,Wow Gold,Cheap World of Warcraft Gold,cheap wow gold,buy cheap wow gold,real wow gold,sell wow gold, ...Here wow gold of 1000 gold at $68.99-$80.99 ,World Of Warcraft Gold,buy wow gold,sell world of warcraft gold(wow gold),buy euro gold wow Cheap wow gold,cheapest wow gold store ... gw gold

Anonymous said...

I think wow gold is better than world of warcraft gold i always Buy WoW gold with cheap wow gold so u Do u like play nba live with nba live 2008 can play wow gold also then Buy WoW gold need to world of warcraft gold u can go google排名 or cheap wow gold i think its google左侧排名

Anonymous said...

runescape money runescape gold runescape money runescape gold wow power leveling wow powerleveling Warcraft Power Leveling Warcraft PowerLeveling buy runescape gold buy runescape money runescape items runescape gold runescape money runescape accounts runescape gp dofus kamas buy dofus kamas Guild Wars Gold buy Guild Wars Gold lotro gold buy lotro gold lotro gold buy lotro gold lotro gold buy lotro gold runescape money runescape power leveling runescape money runescape gold dofus kamas cheap runescape money cheap runescape gold Hellgate Palladium Hellgate London Palladium Hellgate money Tabula Rasa gold tabula rasa money lotro gold buy lotro gold Tabula Rasa Credit Tabula Rasa Credits Hellgate gold Hellgate London gold dofus kamas buy dofus kamas wow power leveling wow powerleveling Warcraft PowerLeveling Warcraft Power Leveling World of Warcraft PowerLeveling World of Warcraft Power Leveling runescape power leveling runescape powerleveling eve isk eve online isk eve isk eve online isk 成都网站优化 成都网站推广 北京网站推广 北京网站优化 血管瘤 肝血管瘤 音乐剧 北京富码电视 富码电视 富码电视台 7天酒店 7天连锁酒店 7天连锁 自清洗过滤器 过滤器 压力开关 压力传感器 流量开关 流量计 液位计 液位开关 温湿度记录仪 风速仪 可燃气体检测仪

aneesh2k7 said...

free runescape account here