Biyete: Parse Bank Emails and send it to Google Sheets

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.

NinjasCL / biyete

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.

Table of Contents

• 🚀 Environment setup
  • Requirements
  • Quick Installation
    • Step 1 - Configure Gmail
      • Pro Tip
    • Step 2 - Create Spreadsheet
    • Step 3 - Configure Google Apps Script
      • (Optional) Script Config
• 👩‍💻 Project explanation
  • How does it work?
• 🤩 Credits

🚀 Environment setup

Requirements

• Google Apps Script.

• Gmail.

• Google Spreadsheets.

Quick Installation

Step 1 - Configure Gmail

1. Configure your Gmail inbox with filters for each Parser, that would assign specific labels.

2. 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…

View on GitHub