Compare physical and digital gold prices and get a buy signal

Compares physical and digital 24K gold costs daily, factors in taxes and fees, and logs a buy or wait verdict.

How the work actually flows

It branches. Every path runs; all paths must finish before it continues; runs once per each gold price source.

Pattern: Parallel Split (2) · Synchronisation (3) · Multiple Instances without Synchronization (12)

flowchart TD trig(["daily price check"]):::trigtime s0[["fetch gold prices"]]:::mi s1["combine into buy or wait score"]:::task s2[("log dated report")]:::store trig --> s0 s1 --> s2 gx{"+ cost versus sentiment analysis"}:::gate s0 --> gx p00["calculate landed cost with tax and fees"]:::task gx -->|"cost analysis"| p00 p10["analyze market news sentiment"]:::task gx -->|"sentiment analysis"| p10 jn{"+ combine into score"}:::gate p00 --> jn p10 --> jn jn --> s1 out[/"dated buy or wait report logged"/]:::out pay{{"data driven gold buying decisions"}}:::pay s2 --> 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 stepRuns once per itemA record or sheetEvery pathWaits for allResultPayoff
Build size
Advanced

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

Business functions
AI Agents & Autonomous SystemsSpreadsheet & Database OpsWeb Scraping & Data Collection
Connects
Google SheetsGoldAPIIBJAGroq

The problem it solves

Figuring out whether digital gold or physical gold is the better buy right now means checking multiple price sources, remembering to add taxes and dealer fees, and guessing at market sentiment. Doing that math every day is not realistic, so you end up buying on gut feel instead of real numbers.

Who it fits

Individual investors and advisors in India who track gold as part of a portfolio.

How it works

  1. The system fetches live digital gold prices and physical gold benchmark rates
  2. It calculates the full landed cost, including tax and dealer fees, for each option
  3. AI reviews current market news to gauge investor sentiment
  4. It combines the price gap and sentiment into a single buy-or-wait score
  5. The result is logged as a dated report in Google Sheets
What you get

A clear buy-or-wait signal you can act on

You get a daily comparison of physical versus digital gold costs, with taxes and fees factored in and a buy-or-wait verdict logged for you.

What you get

A dated investment report in Google Sheets showing landed costs, price gap, and a buy or wait verdict.

What you need

A GoldAPI account, an IBJA data source, a Groq API key, 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

Back to the AI Playbook