Skip to content

Instantly share code, notes, and snippets.

@ArvinH
Last active December 12, 2017 17:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ArvinH/a46f9af2df4316651d2056e610ba68b1 to your computer and use it in GitHub Desktop.
Save ArvinH/a46f9af2df4316651d2056e610ba68b1 to your computer and use it in GitHub Desktop.
googleCalendar nodejs parser
var fs = require('fs');
var readline = require('readline');
var google = require('googleapis');
var googleAuth = require('google-auth-library');
// If modifying these scopes, delete your previously saved credentials
// at ~/.credentials/calendar-nodejs-quickstart.json
var SCOPES = ['https://www.googleapis.com/auth/calendar.readonly'];
var TOKEN_DIR = (process.env.HOME || process.env.HOMEPATH ||
process.env.USERPROFILE) + '/.credentials/';
var TOKEN_PATH = TOKEN_DIR + 'calendar-nodejs-quickstart.json';
var CalendarMapCount = {};
var CalendarMapData = {};
// Load client secrets from a local file.
fs.readFile('client_secret.json', function processClientSecrets(err, content) {
if (err) {
console.log('Error loading client secret file: ' + err);
return;
}
// Authorize a client with the loaded credentials, then call the
// Google Calendar API.
authorize(JSON.parse(content), listEvents);
});
/**
* Create an OAuth2 client with the given credentials, and then execute the
* given callback function.
*
* @param {Object} credentials The authorization client credentials.
* @param {function} callback The callback to call with the authorized client.
*/
function authorize(credentials, callback) {
var clientSecret = credentials.installed.client_secret;
var clientId = credentials.installed.client_id;
var redirectUrl = credentials.installed.redirect_uris[0];
var auth = new googleAuth();
var oauth2Client = new auth.OAuth2(clientId, clientSecret, redirectUrl);
// Check if we have previously stored a token.
fs.readFile(TOKEN_PATH, function (err, token) {
if (err) {
getNewToken(oauth2Client, callback);
} else {
oauth2Client.credentials = JSON.parse(token);
callback(oauth2Client);
}
});
}
/**
* Get and store new token after prompting for user authorization, and then
* execute the given callback with the authorized OAuth2 client.
*
* @param {google.auth.OAuth2} oauth2Client The OAuth2 client to get token for.
* @param {getEventsCallback} callback The callback to call with the authorized
* client.
*/
function getNewToken(oauth2Client, callback) {
var authUrl = oauth2Client.generateAuthUrl({
access_type: 'offline',
scope: SCOPES
});
console.log('Authorize this app by visiting this url: ', authUrl);
var rl = readline.createInterface({
input: process.stdin,
output: process.stdout
});
rl.question('Enter the code from that page here: ', function (code) {
rl.close();
oauth2Client.getToken(code, function (err, token) {
if (err) {
console.log('Error while trying to retrieve access token', err);
return;
}
oauth2Client.credentials = token;
storeToken(token);
callback(oauth2Client);
});
});
}
/**
* Store token to disk be used in later program executions.
*
* @param {Object} token The token to store to disk.
*/
function storeToken(token) {
try {
fs.mkdirSync(TOKEN_DIR);
} catch (err) {
if (err.code != 'EEXIST') {
throw err;
}
}
fs.writeFile(TOKEN_PATH, JSON.stringify(token));
console.log('Token stored to ' + TOKEN_PATH);
}
/**
* Lists the next 10 events on the user's primary calendar.
*
* @param {google.auth.OAuth2} auth An authorized OAuth2 client.
*/
function listEvents(auth, pageToken) {
var calendar = google.calendar('v3');
var queryOptions = {
auth: auth,
calendarId: 'primary',
timeMax: (new Date()).toISOString(),
singleEvents: true,
orderBy: 'startTime'
};
if (pageToken) {
queryOptions.pageToken = pageToken;
}
calendar.events.list(queryOptions, function (err, response) {
if (err) {
console.log('The API returned an error: ' + err);
return;
}
var events = response.items;
if (events.length == 0) {
console.log('No upcoming events found.');
} else {
for (var i = 0; i < events.length; i++) {
var event = events[i];
var start = event.start.date || event.start.dateTime;
var dateString = start.split('T')[0];
var colorId = event.colorId || 'default';
CalendarMapCount[colorId] = CalendarMapCount[colorId] || {};
CalendarMapData[colorId] = CalendarMapData[colorId] || {};
CalendarMapCount[colorId][dateString] = (CalendarMapCount[colorId][dateString] || 0) + 1;
CalendarMapData[colorId][dateString] = event.summary;
}
if (!response.nextSyncToken && !!response.nextPageToken) {
// means we have more data, query again!
return listEvents(auth, response.nextPageToken);
}
var headerColors = Object.keys(CalendarMapCount);
headerColors.forEach((colorId) => {
var headerDate = Object.keys(CalendarMapCount[colorId]);
fs.appendFile(`calendarData-${colorId}.csv`, `date,colorIdNum\n`, 'utf8', (err) => {
if (err) throw err;
headerDate.forEach((date) => {
fs.appendFile(`calendarData-${colorId}.csv`, `${date},${CalendarMapCount[colorId][date]}\n`, 'utf8', (err) => {
if (err) throw err;
});
});
});
});
return;
}
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment