Skip to content

Instantly share code, notes, and snippets.

Avatar

Dave Mozdzanowski davemoz

View GitHub Profile
@davemoz
davemoz / Gmail data into Sheet with Google Apps Script
Last active Mar 6, 2019
Google Apps Script to pull data from transaction emails in Gmail, and insert into Spreadsheet
View Gmail data into Sheet with Google Apps Script
/*
* This Google Apps Script works by simply scraping info from transaction emails
* sent to your Gmail account.
* My credit cards are Capital One, Chase, and Bank of America so the email-scraping
* regexes will need to change to work with the format of your emails.
*
* Once installed, you'll need to set a monthly trigger to run the createMonthlySheet()
* function, but then it will run automatically and sort your transactions into monthly sheets.
*
* Any reference to the getActiveSpreadsheet() method will create a new sheet