Google sites is a web page creation tool provided by Google. It has very limited features, including storage capacity of 100 Mb only (Google Apps users can increase it upto 10 GB). One can use only a fixed set of HTML codes and even custom CSS cannot be made use of in the templates.
As it has very less options, it is suitable to newbies who would like to dive straight into blogging rather than having to worry about the technicalities involved in other blogging platform or CMS. However, once you make a site on Google sites, it is very difficult to move it to another platform, mainly because, it does not provide the ability to export your articles. There is the possiblity to export articles as XHTML files by using the Google Sites Liberation Tool, but again, XHTML is not a format supported by Blogger or WordPress for importing purposes.
So what can we do to transfer articles on Google Sites to Blogger? After quite a bit of brain-storming, I came up with a solution : Feeds. Google sites does generate feed, but how can we import those feeds to our blogger blog? The easiest way is to use the secret email address provided by Blogger. Here I’m sharing step by step tutorial, which any one follow to migrate their Google sites to BlogSpot platform.
Configure Blogger platform:
Go to your blogger dashboard. Navigate to Settings > Mobile and Email.
On “Posting using email”, enter some texts after the “.”, select “Save emails as draft post” and click on Save settings.
Whenever an email is sent to this particular email address, it will get saved as a draft on your blogger dashboard.
Google Sites Feed URL
A default Google Sites URL looks like this : http://www.sites.google.com/site/example
The feed URL for that site can be accessed by going to : https://sites.google.com/feeds/content/site/example/
There are lots of realtime RSS to Email web-services available, but most of them are not suitable for our purpose because either they include an ad at the end of the email or they just don’t accept blogger.com emails at all (due to spam, off course).
So instead, we are going to use a free, open-source tool called RSS2Email. It is available for users of both Windows and Unix OS.
This tool will use our own email account in order to send RSS feeds to our secret email address. I’m going to use Outlook.com email account for the purpose, but you can use any one you like, just google for the SMTP settings of your preferred mail service provider.
Open up the config.py.example file with a text editor (eg. Notepad). Put the following information on the respective fields :
SMTP_SERVER = “smtp.live.com:587″
AUTHREQUIRED = 1
SMTP_USER = ‘[email protected]’ (Do not use an alias here.)
SMTP_PASS = ‘email-password’
Save the file and rename it as config.py.
If you are on Windows 7, python scripts cannot be executed directly without making some changes to the system’s PATH variable. So, here’s what you need to do (only if you are on Win 7):
- Right click on Computer and go to Properties.
- Select Advanced system Settings.
- Select Environment Variables under Advanced tab.
- Now under System variables, select Path and click on Edit.
- Paste the following texts in the Variable value field (at the start of the field). Do not delete the texts that are already there.
- Click on OK.
Execute the script
Open up command prompt and navigate to the folder where you had extracted the contents of RSS2Email. Enter the following commands on command prompt :
r2e.bat new [email protected]
r2e.bat add Google-sites-feed-url.com
Unix users will need to run “r2e” instead of “r2e.bat”. You can add multiple Google sites feed URLs by repeating the second command.
Now, to send all the articles to blogger, enter “r2e.bat run“.
There is a limit on how many articles you can send to Blogger in a day, so if you have lots of articles, you can setup Windows Task Scheduler to run “r2e.bat” every once in a while. That’s it. All of your Google Sites posts should be imported and saved as drafts. You might need to go through every article and edit the alignments, HTMLs. Or, you can just make changes on the config.py file to exclude HTML, CSS Styling etc.
If you stuck at any step, feel free to ask me via comments. If you find this article informative, do consider sharing it on Google plus and Twitter.