The Scenario
You run scheduling for a dive tour operation, and for the third time this month someone has booked departures that conflict with unsafe tidal windows. You have eight dive site coordinates in an Excel workbook. You need high and low tide events — with timestamps, type labels, and sea level heights — for the next 14 days at each site, so you can set departure windows in the booking system before anyone else gets the times wrong.
The bad version:
- Go to the Stormglass tide extremes endpoint docs, run a call for site one, parse the array of tide events, copy each event's timestamp, type, and height into a new row in the workbook — one row per event, potentially 30+ events per site.
- Do this eight times, keeping your place in the spreadsheet as you work through the event list by hand.
- Watch a client call come in on the third site because your column labeling drifted between sites two and three.
Eight sites, fourteen days, roughly two to four tide events per day — you're staring at around 250 individual data points to transcribe before the afternoon is gone.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your dive site coordinates and understands that you need an expanded event-per-row output — not a summary. Through its built-in Stormglass.io connection, it handles the one-to-many structure of the tide extremes response and routes each event into a properly labeled row, without any intermediate formatting step.
For each coordinate pair in columns A and B, fetch Stormglass tide extremes for the next 7 days — paste each high/low tide event with timestamp and sea level height as a separate row in Sheet2. Label columns: Site, Date, Time, Type, Height (m).
What You Get
- Each tide event from the Stormglass response written as its own row in Sheet2 — site name, date, time, type (High or Low), and height in meters.
- Events grouped by site, with the site name repeated in each event row for readability.
- No guessing at which row belongs to which site — the structure is explicit.
What If the Data Is Not Quite Ready
The coordinate list has sites marked "Inactive" that should be skipped
Running tide lookups for mothballed sites pulls Stormglass quota and adds noise to the schedule.
For coordinate rows where column H says "Active," fetch Stormglass tide extremes for the next 7 days and expand each tide event — date, time, type, height — as a separate row in Sheet2. Skip any row where column H is not "Active."
You only care about high tides — low tide rows clutter the departure view
The scheduling system only uses high tide windows to set safe departure times.
For each coordinate in columns A and B, fetch the next 14 days of Stormglass tide extremes, filter for high tide events only, and write each event's date, time, and height into columns C through E in Sheet2. Label column C as Date, D as Time, E as Height (m).
Some coordinates are missing and you need a placeholder row so the site count stays consistent
A few dive sites are newly scouted and coordinates haven't been confirmed yet. The output should still include a row for each site so the operations team can see what's pending.
Fetch Stormglass tide extremes for the next 14 days for each coordinate in columns A and B. If a row is missing a coordinate, write the site name and "Pending coordinates" in the output instead of leaving the rows blank.
Full dedup, filter to active sites, high tides only, expanded to a clean worksheet
Your site list has three duplicate entries, two inactive sites, and the operations manager wants only high tide events written to a clean "Departure Windows" worksheet with no header row gaps.
Remove duplicate rows from the site list, skip rows where column H is not "Active," then fetch Stormglass tide extremes for the next 14 days for each remaining coordinate. Filter for high tide events and write each — with site name, date, time, and height — as a new row in the Departure Windows worksheet.
Asking for the full sequence — dedup, filter, fetch, expand — in one prompt means the output is ready to hand to operations without an intermediate step.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with coastal coordinates, then ask it to pull Stormglass tide extremes for each site across your planning window. The Stormglass.io integration is included in every SheetXAI plan. Also check out fetching 48-hour weather forecasts or browse the full Stormglass.io overview.