Sunrise Sunset API + Google Sheets Integration

Why connect them

The Sunrise Sunset API in Google Sheets.

Google Sheets is the go-to collaborative spreadsheet for teams worldwide. Connecting APIs to Google Sheets transforms your spreadsheets into dynamic, self-updating data hubs. Automatically populate rows with API responses, validate data in real-time, and create living dashboards that reflect the latest information.

What you can build

Workflows worth wiring.

Automatically validate email addresses in a contact list and flag invalid entries

Build a real-time currency conversion tracker that updates exchange rates hourly

Create a lead scoring spreadsheet that enriches contact data with IP geolocation

Monitor domain SSL certificates and log expiration dates for your portfolio

Templates

Ready-made ideas.

Scheduled daily Fetch sunrise/sunset → append row

Log daily sunrise and sunset times

Append a daily row with sunrise, sunset, dawn, dusk, and goldenHour times for your location to track seasonal daylight changes.

New row added with coordinates Fetch sunrise/sunset → update row

Calculate daylight hours for locations

When a row with lat/lon is added, fetch sunrise and sunset times and calculate total daylight hours in an adjacent column.

Setup

Connect it in a few steps.

Set up with Zapier

1
Set the trigger. Create a Zap with Google Sheets as the trigger app and "New row added" 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 Google Sheets action for "Add row" 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 Google Sheets module set to "New row added". 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 Google Sheets module for "Add row". 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 Google Sheets trigger node for "New row added" 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 Google Sheets node for "Add row" 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 Google Sheets 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 + Google Sheets