← All workflows

BUILT FOR CLIENTS, INSIDE THEIR STACK.

Property Photo Auto-Categorisation

Hundreds of site photos sorted by component while you do something else.

Starts
Start a run for a property
Size
11 nodes · 12 connections
Tools
Google Gemini, Airtable
Category
Document Processing · moderate
Status
Built and run, currently paused
property-photo-auto-categorization.jsonn8n canvas

Drawn by n8n's own canvas from the workflow file, synced 2026-09-29. Click it to pan and zoom. Node settings, credentials, prompts and IDs are removed; names, layout and wiring are exactly as built.

Part 1 The problemWhy teams need this

01 · THE PROBLEM

A single site visit can produce hundreds of photos, and someone has to label every one before the report can be written. It's slow, dull work that nobody does well at photo number 300.

Part 2 How it worksWhat it does, step by step

02 · WHAT IT DOES

For the same reserve-study firm. Point it at a property and it works through every uncategorised photo: AI identifies the component in each image, the record is updated, and the property's photo stats are recalculated at the end.

03 · HOW IT RUNS

Step by step, as built.

  1. Pick the property

    A form starts the run and loads the property's details.

  2. Find unsorted photos

    Lists every photo for that property that hasn't been categorised.

  3. Categorise one by one

    Each image is downloaded and Gemini assigns its component category against a fixed schema.

  4. Update the totals

    Photo records are updated, then the property's category stats are recalculated.

04 · TOOLS AND APPS

Built around the systems already in the process.

Google GeminiTrigger or source
AirtableDestination or delivery

05 · WHEN SOMETHING BREAKS

Failure is designed in.

Standard on every build

  • Schema validation before downstream writes
  • Retry and error routes for external API failures
  • Duplicate-safe processing and idempotent updates
  • Human approval where the action carries business risk
  • Execution logging for support and audit review

Part 3 The impactWhat it's worth, and how we'd build yours

06 · PROJECTED IMPACT

What it should change in the business.

01Hundreds of photos sorted per propertyProjected
02Component-level categoriesProjected
03Property stats updated automaticallyProjected

Projections for a typical deployment. The calculation below shows the math, and you can put in your own numbers.

07 · ROI CALCULATION

How it pays back in your business.

The starting numbers are a hypothetical deployment sized to the projections above. Change any of them to your own volumes and costs, and the math updates underneath.

Projected net value per year$17,520450 hours back per year
Full-time equivalent freed
0.3 people
Gross value
$18,000
Running cost
−$480
Return per $1 of running cost
$37.5

The math: 5,000 site photos × 0.5 min × 12 months × 90% ÷ 60 = 450 hours a year × $40/hour = $18,000. Net value = gross value − $480 running cost a year.

08 · HOW WE'D BUILD YOURS

How we'd build yours.

  1. Discover: map the current process, systems, volumes, owners and exceptions.
  2. Design: define the canonical data model, approvals, retries and system boundaries.
  3. Build: implement credentials, nodes, validation and observable error routes.
  4. Prove: run controlled data through success, duplicate and failure scenarios.
  5. Operate: publish runbooks, ownership and measurable service levels.

SAME SYSTEM

Built for clients, inside their stack.

Workflows we built for a home-services contractor, a dental practice, a reserve-study firm and an indoor cultivation facility. Names are kept private; the workflows are real.

YOUR VERSION

Want this, wired to your tools?

Tell us what the process looks like today: the systems, the volumes, the step everyone hates. We'll come back with the n8n version and where a person stays in charge.

Start a project Back to all workflows