This was a small project I created some time ago, but never really took off. But maybe is interesting to you on how to integrate Gmail with Google Sheets.
It parses bank emails and send the information to a Google Sheet or a REST endpoint so you can track your finances.
A small Google Script that parses Google email and save the results to Google Spreadsheets
💵 Biyete 🏦
A simple Google Apps Script to parse Gmail messages related to Bank Notifications, Payment Bills Deposits and other related areas. Then save those data to a Google Spreadsheet that you could use to track your finances.
🚀 Environment setup
Step 1 - Configure Gmail
Configure your Gmail inbox with filters for each Parser, that would assign specific labels.
Ensure that you have some unread emails with the assigned label.
Each parser will have a designated label that you must configure first in your Gmail account This is the way to…