Notice: compact(): Undefined variable: post_id in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: order in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: meta_key in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: featured in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: attachment in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: scan in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: scan_raw in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: callback in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: default in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: split_content in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: size in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: srcset_sizes in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: link in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: link_class in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: image_class in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: image_attr in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: width in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: height in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: before in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: after in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: min_width in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: min_height in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: caption in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: meta_key_save in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: thumbnail_id_save in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: cache in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: format in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: echo in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: custom_key in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: default_size in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: the_post_thumbnail in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: image_scan in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: default_image in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: order_of_image in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298

Notice: compact(): Undefined variable: link_to_post in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-content/themes/stargazer/library/ext/get-the-image.php on line 298
shot1

Grab all Google Calendar events to Excel!

There is a site out there that charges $15/month to allow you to download calendars you have access to to a Google Docs Spreadsheet. Someone I know was thinking about buying this, so I went out and wrote a utility that does just what these people charge for.

It works with ANY Google Calendar (GCal), meaning private or corporate.

The link is here, and you can copy it and use it to your heart’s content. Don’t blame me for anything other than saving money.

Note: Click any image for full version

The first nice thing I did was have instructions come up when you open the spreadsheet. You first go to the config tab, and set what you want to download:

shot2

Just adjust values in the green cells, and you can’t lose! There is a relatively complicated search available, and it can handle any number of target calendars.

There is only one thing to remember:

If you can see it in your Google Calendar, this will find it!

Here are the notes (from the config tab):

  • The ‘config’ tab can be hidden.
  • Search is case-insensitive (nice!).
  • The order you put ‘Calendar Emails’ in is the order they are put into the ‘data’ tab.
  • Calendar events are output in chronological order (old -> new).
  • Complex searches are a little funky. Try to avoid special characters.
  • Search string needs to be 4 or more characters long to be considered. Otherwise all events are shown, just like if left blank.
  • Search string needs to be 4 or more characters long to be considered. Otherwise all events are shown, just like if left blank.
  • Please tell me if you find a mistake/bug-especially if you have a fix! :)

Just let me know if it is of use to you, or if you want to send me $15 each month out of the goodness of your heart!

 

Written in GAS in like 3 hours, as I’d never done anything with the GCal API before…


Deprecated: Function get_magic_quotes_gpc() is deprecated in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-includes/formatting.php on line 4819

Deprecated: Function get_magic_quotes_gpc() is deprecated in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-includes/formatting.php on line 4819

Deprecated: Function get_magic_quotes_gpc() is deprecated in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-includes/formatting.php on line 4819

Deprecated: Function get_magic_quotes_gpc() is deprecated in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-includes/formatting.php on line 4819

Leave a Reply
Deprecated: Function get_magic_quotes_gpc() is deprecated in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-includes/formatting.php on line 4819

Deprecated: Function get_magic_quotes_gpc() is deprecated in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-includes/formatting.php on line 4819

Deprecated: Function get_magic_quotes_gpc() is deprecated in /homepages/16/d105165054/htdocs/atcp.us/blog/wp-includes/formatting.php on line 4819

Your email address will not be published. Required fields are marked *