Track new Spotify releases in a Google Sheets release log

Every morning at 6am, check a watchlist of Spotify artists for new releases and append each one to a release log in Google Sheets. Use a cron trigger, since Spotify does not send outgoing webhooks. Build this as a code workflow: every step is deterministic, so there is no drafting or judgement involved.

Keep the watchlist as a configured list of Spotify artist IDs in the workflow config, alongside the Google Sheets spreadsheet ID, the tab name to write to (default: Releases), and an initial lookback window in days (default: 30).

For each artist ID, call Spotify Get an Artist once to resolve the display name for the artist column. Then call Spotify Get Artist's Albums with include_groups set to album, single, and compilation, and page through all results. Select the releases whose release_date falls on or after the cutoff date. The cutoff is the date of the previous successful run; on the very first run, fall back to the configured initial lookback window. Spotify returns partial dates for some older releases, so read release_date_precision and treat a year-only or year-and-month value as the first day of that period when comparing.

Before writing anything, read the album IDs already in the sheet using Google Sheets Get Values over the album ID column of the Releases tab. Drop any candidate whose Spotify album ID is already present, and also dedupe within the run itself, because the same album can come back more than once across markets and across artist credits on collaborations.

For each remaining new release, call Spotify Get an Album to pull the title, release date, album type, and total track count, plus the Spotify URL from external_urls. Then call Spotify Get Album Tracks, paging through it, to collect the track names in track order and join them into a single semicolon separated string.

Sort the new releases by release date ascending, then write them in one Google Sheets Append Values call to the Releases tab, one row per release, with the columns in this fixed order: release date, artist name, release title, album type, track count, track names, Spotify URL, Spotify album ID. If the tab is empty, write the header row first.

Do not include popularity, danceability, energy, or any other audio feature column. Spotify removed that data in February 2026 and it is no longer available. Our Spotify integration is read only and exposes exactly five operations: Get an Artist, Get Artist's Albums, Get an Album, Get Album Tracks, and Get a Track. There is no search operation, so the watchlist has to be a configured list of artist IDs rather than artist names looked up at runtime.

Handle Spotify rate limiting: on a 429 response, wait for the number of seconds given in the Retry-After header and retry. If one artist ID fails, log it and continue with the rest of the watchlist rather than failing the whole run, and only advance the stored cutoff date when the run completes.