Skip to content

Instantly share code, notes, and snippets.

View saiananth1's full-sized avatar
🌴
On vacation

Lakshmi Ananth saiananth1

🌴
On vacation
View GitHub Profile
@saiananth1
saiananth1 / Gmail data into Sheet with Google Apps Script
Created April 30, 2025 22:32 — forked from davemoz/Gmail data into Sheet with Google Apps Script
Google Apps Script to pull data from transaction emails in Gmail, and insert into Spreadsheet
/*
* 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
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.