Scrapes your GMail and Google Calendar data and returns it as a CSV for further analysis.
Because I wanted to understand meeting and email trends at my employer over time.
The script uses the Google API to access your GMail and Google Calendar data. It then parses the data and returns it as a CSV file.
- Internal-only meetings (all attendees in the same domain)
- Internal-only emails (all recipients in the same domain, excluding automated emails)
- Clone the repo
- Follow the quickstart instructions for the Google API to create a project, and get a
client_secret.json
file. npm run run
to authorize the script to access your data, and then run it.- Grab the resulting
messages.csv
andevents.csv
files and open them in your favorite spreadsheet program. - 😢 at the results. :chart_with_upward_trend: