Sunrise Sunset API + Airtable Integration

Why connect them

The Sunrise Sunset 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.

New record created Fetch sunrise/sunset → populate fields

Enrich location records with sun times

Automatically populate sunrise, sunset, goldenHour, dawn, and dusk fields on new Airtable location records.

New record created Fetch sunrise/sunset → set golden hour fields

Track golden hour for photo shoots

When a shoot location is added, fetch goldenHour and goldenHourEnd times so photographers can plan their sessions.

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 Sunrise Sunset 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 solarNoon) 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/sunrisesunset 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.solarNoon 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/sunrisesunset 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.solarNoon }}.
4
Execute & activate. Execute manually to verify, then activate the workflow for production.

The payload

What Airtable receives.

solarNoon"2025-12-16T12:14:40.51Z"

sunrise"2025-12-16T07:24:56.165Z"

sunset"2025-12-16T17:04:24.854Z"

sunriseEnd"2025-12-16T07:27:58.828Z"

sunsetStart"2025-12-16T17:01:22.192Z"

dawn"2025-12-16T06:56:02.774Z"

Sunrise Sunset API + Airtable