Benchmark Rate API + Airtable Integration

Why connect them

The Benchmark Rate API in Airtable.

Airtable combines the simplicity of a spreadsheet with the power of a database. Integrating APIs with Airtable unlocks automated data enrichment, real-time validation, and dynamic record updates. Build sophisticated data workflows without writing complex database queries.

What you can build

Workflows worth wiring.

Validate and enrich new contact records automatically when added to your CRM base

Create an automated content calendar that fetches trending topics and keywords

Build an inventory tracker that updates product data from external APIs

Monitor competitor websites and log changes to an Airtable base automatically

Templates

Ready-made ideas.

Scheduled daily trigger Fetch benchmark rate → create Airtable record with rate, name, value, currency, and region

Benchmark Rate Database in Airtable

Build a benchmark rate database in Airtable with daily rate values, currency, and region data.

Scheduled daily trigger Fetch benchmark rate → create Airtable record with name, value, change1d, changeDirection, and previousValue

Rate Change Tracking in Airtable

Track rate movements in Airtable with current value, daily change, and previous value fields.

Setup

Connect it in a few steps.

Set up with Zapier

1
Set the trigger. Create a Zap with Airtable as the trigger app and "New record" as the event. Connect your account.
2
Add the API action. Add APIVerve as the action, select the Benchmark Rate API, and map your trigger data to the request.
3
Send it back. Add a second Airtable action for "Create record" and map the returned fields (like rate) into it.
4
Test & turn on. Test the Zap with real data to confirm the mapping, then turn it on.

Set up with Make

1
Add the trigger. Create a scenario and add a Airtable module set to "New record". Authenticate your account.
2
Call the API. Add an HTTP module pointing at api.apiverve.com/v1/benchmarkrate with your x-api-key header. Pass the trigger's data as the input.
3
Parse & map. Add a JSON module to read the response, then a Airtable module for "Create record". Map fields like data.rate into place.
4
Activate. Run once to confirm the mapping, then switch the scenario on and set its schedule.

Set up with n8n

1
Add the trigger node. Start a workflow with a Airtable trigger node for "New record" and connect your credentials.
2
Add an HTTP Request node. Point it at api.apiverve.com/v1/benchmarkrate using Header Auth (x-api-key). Feed in the trigger data.
3
Map with expressions. Add a Airtable node for "Create record" and reference the response with expressions such as {{ $json.data.rate }}.
4
Execute & activate. Execute manually to verify, then activate the workflow for production.

The payload

What Airtable receives.

rate"SOFR"

name"Secured Overnight Financing Rate"

currency"USD"

region"United States"

administrator"Federal Reserve Bank of New York"

value4.32

Benchmark Rate API + Airtable