The Scenario
It's the first day of the quarter and the maritime research team's new analyst is trying to answer a question that should take five minutes: which Stormglass tide stations exist, and which of them are in the North Atlantic? The team's reference sheet is two years out of date. The analyst needs the current complete catalog pulled fresh and ready to filter before the afternoon kickoff call.
The bad version:
- Navigate to the Stormglass tide station endpoint, run an API call with no filters to retrieve the full catalog, and parse the response — which comes back as a JSON array of station objects, each with an id, name, latitude, and longitude.
- Count the stations. There are 200+. Start pasting: ID into column A, name into column B, latitude into column C, longitude into column D.
- Realize at row 140 that the name column has extra whitespace in some entries and the ID field is sometimes an integer, sometimes a string, and the sheet is going to need cleanup before anyone can filter it.
The kickoff is in three hours. The analyst has other onboarding items to get through.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your intent — list all tide stations from Stormglass — calls the catalog endpoint, and writes a clean, consistently formatted table into your sheet. No JSON parsing, no column-by-column pasting, no format guessing. One prompt.
List all available Stormglass tide stations and write each station's ID, name, latitude, and longitude into this sheet starting at row 1 with column headers in row 1.
What You Get
- A complete station catalog table with headers in row 1: Station ID, Station Name, Latitude, Longitude.
- One row per station, IDs formatted consistently as text, names trimmed of extra whitespace.
- The total count of stations noted in a cell below the table so the team knows whether the import was complete.
What If the Data Is Not Quite Ready
You want to filter the catalog immediately to stations above a certain latitude
The team's study area is above 55°N and they don't want the southern hemisphere stations cluttering the reference sheet.
List all Stormglass tide stations, filter to those with latitude above 55, and write the filtered catalog — station ID, name, latitude, longitude — into this sheet with headers. Note the total count of matching stations below the table.
The sheet already has an old station catalog and you want to identify new stations added since the last export
The team's reference sheet has 180 station entries from two years ago. You want to see which stations in the current Stormglass catalog aren't already in the sheet.
List all current Stormglass tide stations and compare them against the existing entries in columns A through D of this sheet. Write any station IDs that don't appear in the existing list into a new "New Stations" section starting at row 210 with a header row.
Station names have inconsistent casing and you need them normalized before sharing with the external partner
The external team's system is case-sensitive. Some names are ALL CAPS, some are Title Case, some are mixed.
List all Stormglass tide stations, normalize all station names to Title Case, and write station ID, normalized name, latitude, and longitude into this sheet. Flag any name that contained non-standard characters in column E.
Full refresh: pull the catalog, deduplicate against the old sheet, classify by hemisphere, flag outlier coordinates
The reference sheet hasn't been updated in two years. You want a complete refresh: pull the current catalog, remove any stations already in the old list (keep only the new ones in a separate section), classify each new station by hemisphere, and flag any with coordinates that look like data entry errors (lat outside −90 to 90, lng outside −180 to 180).
List all current Stormglass tide stations. Compare against the existing station IDs in column A rows 2 through 181. Write only the new stations into a "New Stations" section starting at row 185 — with ID, name, latitude, longitude, and a hemisphere label (Northern/Southern based on latitude sign). Flag any new station where latitude is outside −90 to 90 or longitude is outside −180 to 180 in a "Coordinate Error" column.
Combining the refresh, the dedup, and the validation pass in one prompt means the team starts the afternoon kickoff with a reference sheet they can actually use.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where your team tracks geographic or environmental reference data, then ask it to pull the complete Stormglass tide station catalog and filter it to your region of interest. The Stormglass.io integration is included in every SheetXAI plan. Also see finding stations within a bounding box or the Stormglass.io overview.