Compare physical vs digital 24K gold costs and returns with GoldAPI, IBJA, Groq and Google Sheets

Gold Investment Intelligence: Physical vs. Digital 24K Cost & Return Analysis

This high-performance n8n workflow automates the complex task of comparing gold investment types in the Indian market. By pulling live data from the GoldAPI (Digital) and the IBJA (Physical benchmark), it calculates the "Landed Cost" including GST and making charges to provide a data-driven "Buy/Wait" verdict powered by a Groq-hosted LLM.

Stop manually calculating gold spreads across different platforms. This workflow fetches real-time 24K gold rates, applies localized taxes (3% GST) and industry-standard fees (3-8%), analyzes global market sentiment via Yahoo Finance RSS and logs a professional investment report to Google Sheets. It transforms raw data into an actionable "Efficiency Score" using AI.

Quick Implementation Steps:

1. Import the JSON file into your n8n canvas. 2. Get API Key: Sign up at GoldAPI.io and paste your token into the "Get Digital Price" header. 3. Connect AI: Add your Groq API credentials to the "Groq Chat Model" node. 4. Prepare Sheet: Create a Google Sheet with these headers: Date, DigitalPrice, PhysicalPrice, Arbitrage, Sentiment and EfficiencyScore. 5. Authorize: Link your Google account in the "Add Report" node and select your spreadsheet.

What It Does

This workflow acts as a 24/7 Quantitative Financial Analyst specialized in the gold market. It eliminates the "hidden cost" surprise by calculating the absolute final price an investor pays out-of-pocket for 1 gram of 24K gold. It doesn't just look at the ticker price; it factors in the 3% GST applicable in India, platform spreads for digital gold apps and making charges for physical coins/bars.

Beyond raw arithmetic, the workflow contextually understands the global landscape. By scraping the latest commodity headlines from Yahoo Finance, the integrated AI Agent determines if the current market vibe is "Greedy," "Neutral," or "Fearful." It then synthesizes the price gap and the news into a single "Efficiency Score" (1-100), telling you exactly how favorable the buying conditions are today.