This post is the tenth and last in a series of postings, containing examples of SharePoint WebParts that anybody can build all by themselves. To read all posts in this series, or to get started with the RSSBus WebPart, go here.
#10 - Keep Your SharePoint Calendar Synced with Google
The following is one way you can use to keep your SharePoint Calendar(s) synced up with your Google Calendar. This particular example only syncs in one direction: from Google to SharePoint. It could go the opposite direction, or both, but that's not what I need so that's not what I did. :) As usual, this solution requires that you have the RSSBus Web Part installed. See here for instructions. You'll also need the GoogleOps Connector, which is automatically included with the RSSBus Web Part.
Step one: Logon to SharePoint and browse to your calendar. Under Site Actions, click Edit Page.
Step two: Now, click on "Add a Web Part", and add the RSSBus Web Part to the page. I prefer to drag the Calendar up so that it is on top, and this RSSBus Web Part is just below it. On its edit menu, click Modify Shared Web Part and open the Source Editor.
Step three: Paste in the following RSSBus Web Part template, and click "Apply".
Step four: After you click Apply, you'll need to specify your Google Calendar email and password, the name of the calendar to sync with (ie, "Calendar"), and the number of days you want it to keep synced at a time. Optionally, you can embed these inputs into the script if you want, instead of leaving them as web part properties. To do that, change the rsb:info section of code to this:
<rsb:set attr="email" value="YOUREMAIL" />
<rsb:set attr="password" value="YOURPASSWORD" />
<rsb:set attr="calendar" value="YOURCALENDARNAME" />
<rsb:set attr="days" value="30" />
Now, everytime you view your Calendar page it will automatically be updated with the lastest items from Google Calendar.
See all posts in this series: 10 DIY SharePoint Web Parts.
Browse RSSBus Connectors.
Basic RSSBus Scripting Cheat Sheet.