Self-hosted Spotify playlist sync for Google Sheets.
Mirror Liked Songs or Spotify playlists automatically with Google Apps Script. No hosted backend. No always-on computer.

Install / update · Security · Architecture · Contributing

Liked Songs → Shareable Likes · ✓ Synced automatically

Spoti Sync has one normal control surface: Spoti Sync → Open Spoti Sync. The Google Sheet stays focused on status and Activity history rather than becoming a second configuration UI.

• Use Liked Songs or a Spotify playlist as the source.
• Sync into an existing playlist or create a new target playlist.
• Choose Exact Mirror or Append Only behavior.
• Set Automation: Off, Hourly, Every N hours, Daily, or Every N days.
• Run any job manually with Sync now.
• Optionally keep the target playlist description updated with Spoti Sync status.

1. Open the Spoti Sync installer.
2. Create or open a Google Sheet.
3. Open Extensions → Apps Script.
4. Copy the generated Spoti Sync bundle into Code.gs, then save and reload the Sheet.
5. Open Spoti Sync → Open Spoti Sync.
6. Connect your Spotify Developer app from the sidebar.
7. Choose + Add job.
8. Pick the source, target, behavior, and automation, then save.

No web-app deployment, local server, Node.js installation, or clasp setup is required for normal use.

Exact Mirror keeps the managed target membership aligned with the source.
Append Only adds missing source tracks and never removes existing target tracks.

Spoti Sync still uses one background scheduler. If any job uses an hour-based interval, jobs are checked hourly; Spotify is contacted only for jobs that are actually due.

Spoti Sync runs in your own Google Apps Script environment. Spotify access and refresh tokens are stored in Apps Script User Properties, not on a hosted Spoti Sync backend or GitHub Pages.

See SECURITY.md for the security model and ARCHITECTURE.md for implementation details.

1. Open the update section.
2. Copy the latest Apps Script bundle.
3. Replace Code.gs in the same bound Apps Script project and save.
4. Reload the Sheet and open Spoti Sync → Open Spoti Sync.

Updates preserve the existing installation state; they do not require recreating jobs or manually rebuilding automation.

Node.js 22+ is used only for local build and test tooling.

node scripts/build.js
node scripts/test.js
node scripts/test-v14.js
node scripts/test-v15.js
node scripts/test-scheduler.js
node scripts/test-sheet-repair.js
node scripts/test-job-editor.js
node scripts/test-heartbeat.js
node scripts/test-update-checker.js
node scripts/test-docs.js

docs/source-files.json is the canonical ordered Apps Script source manifest used by both the build and browser installer.

Focused fixes and improvements are welcome. See CONTRIBUTING.md before opening a pull request.

MIT. See LICENSE.