Google Sheets + Spotify
Add new tracks in Spotify playlists to Google Sheets rows
Want an easy way to share your favorite tracks with friends? Use this Zapier integration, which automatically adds new songs from a Spotify playlist to rows on a specified Google Sheets spreadsheet. Then, you can share that spreadsheet far and wide, just like sharing your earbuds with a friend!
Want an easy way to share your favorite tracks with friends? Use this Zapier integration, which automatically adds new songs from a Spotify playlist to rows on a specified Google Sheets spreadsheet. Then, you can share that spreadsheet far and wide, just like sharing your earbuds with a friend!
- When this happens...
New Track Added to PlaylistTriggers when a new track is added to one of your playlists.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Played Track
Triggers when a track finishes playing. Use with a Filter step to only trigger when particular song/s plays.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPlaylist NameRequired
Description
Visibility
Collaborative
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Currently Playing Track
Retrieve the item currently being played on the user's Spotify account.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ShowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Album IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TracksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PlaylistRequired
Playlist Name
Description
Visibility
Collaborative
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Artist IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appGet Saved Shows
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Saved Track
Triggers when a new track is "Liked".
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Playlist
Triggers when a new playlist is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPlaylistRequired
URIsRequired
Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Artist IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Show
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Track IDRequired
Feature Definitions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Episode IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Enter Album, Artist, Playlist URI
PlaybackRequired
Enter Track
Play When
Device
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EpisodeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTrack IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Copy Text
Search TypeRequired
Search QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
About Spotify
Related categories
Related Zap Templates
- Add tracks to Spotify playlist from new Google Sheets rows
- Log new played tracks from Spotify to create multiple rows in Google Sheets
- Log new played tracks from Spotify to create spreadsheet rows in Google Sheets
- Update playlists in Spotify when new rows are added in Google Sheets
- Add new Spotify Playlists to a Google Sheet
- Log new Spotify tracks in Google Sheets spreadsheets as they play
- Create playlists in Spotify from new spreadsheets in Google Sheets
- Add new Spotify saved tracks to Google Sheets rows.
- Create spreadsheets in Google Sheets for new playlists in Spotify
- Add tracks to Spotify playlist from new Google Sheets spreadsheet rows (team drive)
- Create multiple rows in Google Sheets when new tracks are added to Spotify playlist
- Update Google Sheets rows when new Spotify tracks are saved
- Create multiple rows in Google Sheets when new tracks are added to a Spotify playlist
- Create spreadsheet columns in Google Sheets for new tracks added to Spotify playlists
- Add new Spotify saved tracks to Google Sheets as rows
- Create spreadsheet rows in Google Sheets for new tracks added to Spotify playlists
- Create new Spotify playlist items from new Google Sheets spreadsheets
- Update Google Sheets rows when new tracks are played on Spotify
- Create multiple rows in Google Sheets for new saved tracks in Spotify
- Add items to a Spotify playlist from new Google Sheets rows
- Create spreadsheets in Google Sheets for new tracks added to playlists in Spotify
- Create spreadsheet rows in Google Sheets for new podcast episodes in Spotify
- Update Spotify playlist with new or updated Google Sheets rows
- Update Google Sheets rows whenever new tracks are added to a Spotify playlist
- Update Google Sheets rows for new Spotify played tracks
- Create worksheets in Google Sheets for new podcast episodes on Spotify
- Create worksheets in Google Sheets for new playlists in Spotify
- Create Google Sheets columns for new Spotify saved tracks
- Create multiple Google Sheets rows every time new tracks are played on Spotify
- Update Google Sheets rows with new played tracks from Spotify
- Log new Spotify tracks by creating rows in Google Sheets
- Add new Spotify tracks to top of Google Sheets rows when added to playlist
- Create playlists in Spotify for new rows in Google Sheets
Related Zap Templates
- Add tracks to Spotify playlist from new Google Sheets rows
- Update playlists in Spotify when new rows are added in Google Sheets
- Create playlists in Spotify from new spreadsheets in Google Sheets
- Add tracks to Spotify playlist from new Google Sheets spreadsheet rows (team drive)
- Create multiple rows in Google Sheets when new tracks are added to a Spotify playlist
- Create spreadsheet rows in Google Sheets for new tracks added to Spotify playlists
- Create multiple rows in Google Sheets for new saved tracks in Spotify
- Create spreadsheet rows in Google Sheets for new podcast episodes in Spotify
- Update Google Sheets rows for new Spotify played tracks
- Create Google Sheets columns for new Spotify saved tracks
- Log new Spotify tracks by creating rows in Google Sheets
- Log new played tracks from Spotify to create multiple rows in Google Sheets
- Add new Spotify Playlists to a Google Sheet
- Add new Spotify saved tracks to Google Sheets rows.
- Create multiple rows in Google Sheets when new tracks are added to Spotify playlist
- Create spreadsheet columns in Google Sheets for new tracks added to Spotify playlists
- Create new Spotify playlist items from new Google Sheets spreadsheets
- Add items to a Spotify playlist from new Google Sheets rows
- Update Spotify playlist with new or updated Google Sheets rows
- Create worksheets in Google Sheets for new podcast episodes on Spotify
- Create multiple Google Sheets rows every time new tracks are played on Spotify
- Add new Spotify tracks to top of Google Sheets rows when added to playlist
- Log new played tracks from Spotify to create spreadsheet rows in Google Sheets
- Log new Spotify tracks in Google Sheets spreadsheets as they play
- Create spreadsheets in Google Sheets for new playlists in Spotify
- Update Google Sheets rows when new Spotify tracks are saved
- Add new Spotify saved tracks to Google Sheets as rows
- Update Google Sheets rows when new tracks are played on Spotify
- Create spreadsheets in Google Sheets for new tracks added to playlists in Spotify
- Update Google Sheets rows whenever new tracks are added to a Spotify playlist
- Create worksheets in Google Sheets for new playlists in Spotify
- Update Google Sheets rows with new played tracks from Spotify
- Create playlists in Spotify for new rows in Google Sheets