1. 📈 Workflow Function Overview

This Activepieces automation captures payment notifications from your Gmail inbox and logs them in a Google Sheet for expense tracking. You can run it in real time (per incoming email) or as a batch (once every 24 h), ensuring your sheet stays up to date with minimal manual effort.

Key goals:

• Fetch all labeled emails received in the last 24 h.
• Extract expense details (description, amount, date, account) from each email snippet by calling ChatGPT.
• Write each parsed record into Google Sheets
• 🤖Automated way to track daily expenses

How it looks like:

• Turn an email payment notification from your bank with the following text:

  “Hello Mr LUNA,

  A payment of 90,00 EUR to Exit Travel E.E has been made on 28/07/2025 from your account LUXX XXXX XXXX XXXX XXXX.

  Kind regards,

  Your bank”

• Into a spreadsheet entry such as:

Simplified workflow diagram:

flowchart TD
    T1[🕒 Scheduled Trigger]
    A1[🔐 Get OAuth2 Token]
    B1[📥 List Gmail Messages]
    L1{{🔁 Loop: Each Message}}
    C1[📬 Get Message Details]
    C2[📦 Store Snippet]
    D1[🧠 Aggregate Snippets]
    E1[🤖 GPT: Parse to JSON]
    L2{{🔁 Loop: Each Parsed Row}}
    F1[📊 Insert Row into Sheet]

    T1 --> A1 --> B1 --> L1
    L1 --> C1 --> C2
    C2 --> D1 --> E1 --> L2 --> F1

2. 🛠 Detailed Steps (Batch Processing Flow)

A. Scheduled Trigger