Google Calendar events to CSV

Downloads all events from your Google Calendars and saves it as a CSV file.

Setup

Follow the steps bellow just once.

1. Download and install NodeJS

2. Download this repo - just click on the Download ZIP button available in this very page

3. Create a valid OAuth2 ID

3.1 Remember to save your client_secret.json in the same directory you've saved this code

4. Run the following commands (from within this application's directory)

   4.1 Restore all dependencies from this project

   npm update

   4.2 Run the application

   node gcn.js

5. Follow the steps through the page opened by the application to get the authorization token

6. Enter de authorization token back into the app and hit enter

7. Profit!

Future executions

After the first full run, all you need to do in order to gather your data from Google's servers is to run the command node gcn.js from within the application directory.

Limitations

The number of events that the this code is able to download is now limited to 2500. This is enforced by Google. See here for more info (parameter maxResults).

CSV file structure

1. Calendar description (usually it's name)
2. Event summary
3. Event description
4. Event start
5. Event end
6. Location
7. Event organizer's email address