How to Get Real-Time Gold and Silver Prices in Airtable

Step-by-step guide on integrating GoldAPI.io Price Call in Airtable base

Integrating GoldAPI.io with Airtable

Airtable is useful when you want to store live precious metals prices in a spreadsheet-like database, build lightweight dashboards, or trigger automations from changing market data.

The simplest approach is to use Airtable Automations with a script that calls GoldAPI.io and writes the returned price into a table.

What you need

  1. An Airtable base.
  2. A GoldAPI.io API key.
  3. A table for storing metal prices.
  4. An Airtable automation with a scripting action.

Step 1: Create a prices table

Create a table named:

Metal Prices

Add fields such as:

  • Metal
  • Currency
  • Price
  • Ask
  • Bid
  • Timestamp

Step 2: Add an automation

In Airtable, create an automation with a trigger such as:

At scheduled time

Then add a script action.

Step 3: Call GoldAPI.io from the script

Use a script like this:

const apiKey = 'YOUR_API_KEY';
const table = base.getTable('Metal Prices');

const response = await fetch('https://www.goldapi.io/api/price/XAU/USD?melt_price=false&currency_info=false', {
  method: 'GET',
  headers: {
    'x-access-token': apiKey,
    'Content-Type': 'application/json'
  }
});

if (!response.ok) {
  throw new Error(`GoldAPI.io request failed: ${response.status}`);
}

const data = await response.json();

await table.createRecordAsync({
  'Metal': 'XAU',
  'Currency': 'USD',
  'Price': data.price,
  'Ask': data.ask,
  'Bid': data.bid,
  'Timestamp': new Date(data.timestamp * 1000).toISOString()
});

Step 4: Use the stored data

After Airtable stores the record, you can:

  • build filtered views for gold, silver, platinum, or palladium
  • chart recent prices with Airtable Interfaces
  • trigger notifications when new records match a condition
  • sync the table into reporting or operations workflows

Example workflow

  1. Airtable scheduled automation runs every hour.
  2. Script calls GoldAPI.io for XAU/USD.
  3. Script inserts a new row in Metal Prices.
  4. Airtable Interface or another automation uses the latest value.

Updating the latest row instead of inserting

If you only want one current-price record, query the table first and update an existing record instead of creating a new one.

const records = await table.selectRecordsAsync();
const existing = records.records.find((record) => (
  record.getCellValue('Metal') === 'XAU' &&
  record.getCellValue('Currency') === 'USD'
));

if (existing) {
  await table.updateRecordAsync(existing.id, {
    'Price': data.price,
    'Ask': data.ask,
    'Bid': data.bid,
    'Timestamp': new Date(data.timestamp * 1000).toISOString()
  });
}

Security note

Avoid sharing Airtable scripts or bases that contain your GoldAPI.io key. If multiple people manage the base, limit editor access and rotate the key if it is exposed.

Conclusion

Airtable works well as a lightweight destination for GoldAPI.io price data. A scheduled automation and one script action are enough to keep a base updated with live metals prices.

GoldAPI.io Developer FAQ

Helpful answers for developers working with precious metals price data.

Can I use GoldAPI.io price API examples in production?

Yes. GoldAPI.io API examples can be used in production applications with your API key. Developers can integrate real-time gold, silver, and precious metals prices into websites, trading platforms, and financial tools.

Does GoldAPI.io support multiple currencies for gold price API?

Yes. GoldAPI.io supports multiple currencies including USD, AUD, CAD, EUR, GBP, AED, SGD, KWD, OMR, and SAR. You can request gold price and other metals price data in any supported currency.

Is GoldAPI.io suitable for trading bots and financial applications?

Yes. GoldAPI.io is designed for developers building trading bots, financial dashboards, analytics platforms, and pricing tools. It provides fast and reliable real-time and historical metals price data via JSON API.

Integration Guides To

Build With GoldAPI.io Today

Practical guides for WordPress, Shopify, Excel, Joomla, and Drupal.

WordPress integration icon
WordPress

How to Get Real-Time Gold and Silver Prices in WordPress

Step-by-step guide on integrating GoldAPI.io Price Call in WordPress site

Read article →
Shopify integration icon
Shopify

How to Get Real-Time Gold and Silver Prices in Shopify

Step-by-step guide on integrating GoldAPI.io Price Call in Shopify store

Read article →
Excel integration icon
Excel

How to Get Real-Time Gold and Silver Prices in Excel

Step-by-step guide on integrating GoldAPI.io Price Call in Excel spreadsheet

Read article →
WebSockets integration icon
WebSockets

How to Stream Live Gold Prices Using GoldAPI.io WebSockets Integration

Build a real-time gold price WebSocket feed for bullion dealer quotes, live dashboards, inventory valuation, and customer price updates with GoldAPI.io.

Read article →
FX WebSockets integration icon
FX WebSockets

How to Get Real-Time Currency FX Rates Using GoldAPI.io WebSockets

Stream live foreign-exchange rates, bid and ask prices, and currency-pair updates into FX dashboards, conversion tools, checkout pricing, and treasury workflows.

Read article →
MCP Server integration icon
MCP Server

How to Connect ChatGPT, Claude and Codex to the GoldAPI MCP Server

Connect AI agents to the hosted GoldAPI MCP Server for live and historical metal (gold, silver) prices, currency conversion, valuations, portfolio analysis and LBMA benchmarks.

Read article →