Google Sheets + Spotify
Create rules in Google Sheets for new tracks added to Spotify playlist
Keep track of your new Spotify playlist additions and make tracking them more visually appealing in Google Sheets. Whenever you add a new track to your Spotify playlist, this workflow sets up a new conditional formatting rule in Google Sheets. This makes it easy to see and analyze all the songs you've recently added to your playlist. Stay organized and make your spreadsheet more insightful with this Spotify to Google Sheets workflow.
Keep track of your new Spotify playlist additions and make tracking them more visually appealing in Google Sheets. Whenever you add a new track to your Spotify playlist, this workflow sets up a new conditional formatting rule in Google Sheets. This makes it easy to see and analyze all the songs you've recently added to your playlist. Stay organized and make your spreadsheet more insightful with this Spotify to Google Sheets workflow.
- 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 Conditional Formatting RuleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values.
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 appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
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.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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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
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 appDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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 new tracks in Spotify playlists to Google Sheets rows
- Add tracks to Spotify playlist from new Google Sheets rows
- Log new played tracks from Spotify to create spreadsheet rows in Google Sheets
- Log new played tracks from Spotify to create multiple rows in Google Sheets
- Create spreadsheets in Google Sheets for new playlists in Spotify
- Add new Spotify Playlists to a Google Sheet
- Create playlists in Spotify from new spreadsheets in Google Sheets
- Update playlists in Spotify when new rows are added in Google Sheets
- Add new Spotify saved tracks to Google Sheets rows.
- 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
- Log new Spotify tracks in Google Sheets spreadsheets as they play
- 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
- Log new played tracks in Spotify to the top of a Google Sheets row
Related Zap Templates
- Add new tracks in Spotify playlists to Google Sheets rows
- Log new played tracks from Spotify to create multiple rows 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 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
- Add tracks to Spotify playlist from new Google Sheets rows
- Create spreadsheets in Google Sheets for new playlists in Spotify
- Update playlists in Spotify when new rows are added in Google Sheets
- 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
- 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 in Spotify to the top of a Google Sheets row
- Log new played tracks from Spotify to create spreadsheet rows in Google Sheets
- Add new Spotify Playlists to a Google Sheet
- Add new Spotify saved tracks to Google Sheets rows.
- 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
- Log new Spotify tracks in Google Sheets spreadsheets as they play
- 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