Log Bancolombia purchase alerts from Gmail into Google Sheets

Reads Bancolombia purchase alert emails and logs each transaction into a Google Sheet automatically.

How the work actually flows

It branches. Exactly one path is taken.

Pattern: Exclusive Choice (4) · Simple Merge (5)

flowchart TD trig>"new bank alert email arrives"]:::trig s0["extract transaction details"]:::task s1["validate transaction data"]:::task s2[("log transaction to sheet")]:::store s3["mark email as read"]:::task trig --> s0 s0 --> s1 s2 --> s3 gx{"× is transaction data valid"}:::gate s1 --> gx p00["continue to logging"]:::task gx -->|"valid data"| p00 p10["skip entry"]:::task gx -->|"invalid data"| p10 jn{"○ continue processing"}:::gate p00 --> jn p10 --> jn jn --> s2 out[/"transaction logged in spreadsheet"/]:::out pay{{"clear ongoing record of spending"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepA record or sheetOne path onlyPaths rejoinResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Email AutomationSpreadsheet & Database OpsFinance & Accounting
Connects
GmailGoogle Sheets

The problem it solves

You get a purchase alert email every time you use your Bancolombia card, but going back through your inbox to build a spending record is tedious and easy to abandon. Without a running log, you don't have a clear picture of where your money is actually going.

Who it fits

Individuals or small business owners in Colombia who want automatic expense tracking from their bank alerts.

How it works

  1. Gmail checks for new unread Bancolombia purchase alert emails
  2. The transaction details, like date, amount, merchant, and category, are pulled from the email
  3. Each entry is checked to make sure it contains valid transaction data
  4. The transaction is written into Google Sheets as a new row
  5. The email is marked as read so it isn't logged twice
What you get

Transactions logged without touching a keyboard

Every Bancolombia purchase alert you receive gets automatically turned into a logged entry in your Google Sheet, ready whenever you check it.

What you get

An updated Google Sheet with every card transaction logged and categorized.

What you need

A Gmail account and a Google Sheets account.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Read invoices from Gmail and log them to Google Sheets automatically

Pulls invoice attachments out of your inbox, reads the details with AI, and records them in a spreadsheet.

Advanced

Track invoices and automatically chase late payments by email

It logs invoices, emails reminders as they age, and alerts your team on Slack when accounts go to collections.

Advanced

Extract e-invoice data from Gmail into Google Sheets automatically

Reads e-invoices from your inbox and logs the invoice number, amounts, and details straight into a spreadsheet.

Advanced

Automatically catch receipt emails and route them to your books

Gmail automatically finds and labels receipt emails so nothing gets lost before expense reporting time.

Standard
Back to the AI Playbook