Extract pay slip details from LINE photos into Google Sheets

Reads a pay slip photo sent over LINE and logs the amount and details into Google Sheets instantly.

How the work actually flows

It branches. Exactly one path is taken.

Pattern: Exclusive Choice (4) · Transient Trigger (23)

flowchart TD trig>"employee sends message on line"]:::trig s0["check message type"]:::task s1["extract pay slip details"]:::svc s2[("save record to sheet")]:::store s3["confirm reply to sender"]:::task trig --> s0 s1 --> s2 s2 --> s3 gx{"× is it a pay slip photo"}:::gate s0 --> gx p00["extract details with ai"]:::task gx -->|"pay slip photo"| p00 p01["save to sheet"]:::task p00 --> p01 p10["answer question directly"]:::task gx -->|"text question"| p10 p01 --> s1 p10 --> s1 out[/"pay slip logged in sheet"/]:::out pay{{"less manual payroll entry"}}:::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 stepAn outside serviceA record or sheetOne path onlyResultPayoff

Build size

Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions

AI Agents & Autonomous SystemsAI Chatbots & AssistantsSpreadsheet & Database OpsAPI & Webhook Integration

Connects

LINEGoogle GeminiGoogle Sheets

The problem it solves

Manually reading pay slips and typing the amounts, dates, and payer details into a spreadsheet is slow and invites typos. Every slip looks a little different, which makes simple copy-paste rules unreliable.

Who it fits

Payroll or admin staff who process pay slips and want less manual data entry.

How it works

An employee sends a pay slip photo or a question through LINE
The system checks whether the message is an image or plain text
If it's a pay slip, AI reads the status, sender, recipient, date, and amount
The details are saved as a new row in Google Sheets and confirmed back to the sender

Quick estimate

What it is worth to you

Your numbers, your hourly cost. We add nothing hidden.

Pay slips processed per week

per week

Minutes to read and type each slip into the sheet

minutes

Loaded hourly cost of staff doing this

$ per hour

0Hours freed per month

0Value per year at your hourly cost

Assumes the freed time is used for other work and that slip formats stay simple enough for accurate reading.

What you get

A logged pay slip record in Google Sheets and a confirmation reply in LINE.

What you need

A LINE Business account and a Google Gemini API key.

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

Back to the AI Playbook