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 a Google Sheet. 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 sheet — 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 Google Sheet. 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 14 days and list each event's date, time, type (high/low), and height in columns C through F. Write each event as a separate row — group by site using the site name in column G if it's present.
What You Get
- Each tide event from the Stormglass response written as its own row in the sheet — date in column C, time in D, type (High or Low) in E, height in meters in F.
- Events grouped by site, with the site name from column G 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 14 days and expand each tide event — date, time, type, height — as a separate row in the Tide Schedule tab. 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. 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 columns C through F instead of leaving the rows blank.
Full dedup, filter to active sites, high tides only, expanded to a fresh tab
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" tab 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 tab.
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 Google Sheet 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. You might also check out fetching 48-hour weather forecasts or browse the full Stormglass.io overview for other data types.