Track and rate used iPhone listings across marketplaces daily

Scans phone resale listings, has AI rate each deal, and emails you a daily summary of the best ones.

How the work actually flows

It branches. Exactly one path is taken; runs once per each listing scanned.

Pattern: Exclusive Choice (4) · Multiple Instances with a priori Design-Time Knowledge (13)

flowchart TD trig(["daily scheduled scan"]):::trigtime s0["scan marketplace listings"]:::svc s1["clean up price data"]:::task s2[["AI scores each listing"]]:::mi s3["email daily summary"]:::task trig --> s0 s0 --> s1 s1 -->|"one per each listing scanned"| s2 gx{"× which rating tier"}:::gate s2 --> gx p00["save to Google Sheets"]:::task gx -->|"high rated"| p00 p10["save to Airtable"]:::task gx -->|"mid rated"| p10 p20["drop listing"]:::task gx -->|"low rated"| p20 p00 --> s3 p10 --> s3 p20 --> s3 out[/"scored deal listings organized by quality"/]:::out pay{{"faster sourcing of good deals"}}:::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 serviceRuns once per itemOne path onlyResultPayoff
Build size
Advanced

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

Business functions
AI Agents & Autonomous SystemsEmail AutomationSpreadsheet & Database OpsReporting & AnalyticsWeb Scraping & Data CollectionResearch & Market Intelligence
Connects
GmailGoogle SheetsAirtable

The problem it solves

You're hunting for good used iPhone deals across multiple marketplaces, but checking each site every day is tedious and prices are listed inconsistently. Good deals disappear before you spot them manually.

Who it fits

A phone resale business or reseller sourcing used inventory across online marketplaces.

How it works

  1. A schedule triggers a scan of listings across marketplaces
  2. Prices are cleaned up into one consistent format
  3. An AI model scores each listing and adds a short opinion
  4. High-rated listings go to Google Sheets, mid-rated to Airtable, and low-rated are dropped
  5. You receive a daily email summarizing the best finds
What you get

Resale deals ranked by daily AI review

Every day you receive a summary of the best used iPhone deals across marketplaces, each one rated and reviewed by AI.

What you get

A daily email report plus organized lists of scored listings in Google Sheets and Airtable.

What you need

A Gmail account, a Google Workspace account, an Airtable account, and an AI model 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