Add new iOS Contacts to Google Sheets automatically
About this Applet
Automatically record your recently played Spotify songs in Google Sheets, add them as tasks in Google Tasks, and send yourself an email summary. This Applet runs every time you play a new track on Spotify, creating a log, a reminder, and a quick recap message. Perfect for music enthusiasts who love tracking their listening habits and keeping an organized record across services. Customize the email content to fit your tone.
If
Trigger ingredients
TrackName
ArtistName
TrackUrl
PlayedAt
TrackId
TrackIsrc
Then
Action fields
tasklist_id
task_title
task_notes
due_date
And
Action fields
subject
body
attachment_url
And
Action fields
filename
formatted_row
path
Services used in this Applet
You might also like...
-
272k
-
-
Add songs from videos you like to a Spotify playlist
186k
-
-
Track time at locations with Google Sheets
157k
-
Related services
-
-
App store rating
Create your own workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
84 triggers, queries, and actions
A task is completed
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a task is completed.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
New attachment
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time a new email with an attachment arrives in your inbox.
New conversation
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when a conversation starts in your Gmail inbox: a message gets its first reply and a back-and-forth begins. It fires once per conversation, not on every reply.
New email
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time a new email arrives in your Gmail inbox.
New email matching search
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time an email newly matches your Gmail search, whether it just arrived or just changed to match.
New episode from a followed show
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a followed show releases a new episode on Spotify.
New episode from search
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every time a new episode is released that matches your search
New followed show
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every time you follow a new show on Spotify.
New label
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires once every time a new label is created in your Gmail account. New labels are typically detected within an hour.
New recently played track
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every time you have played a new track on Spotify.
New row added to spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a spreadsheet you specify.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Currently playing track
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the track that is currently playing on Spotify.
Find email
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the most recent emails matching your Gmail search, newest first.
Get album details
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns details for a given album.
Get artist details
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns information about a given artist.
Get artists for album
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query will return artists for a given album.
Get artists for track
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a track's artists.
Get attachment by filename
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns an attachment from a specific Gmail message, located by its filename, as links to a temporary copy of the file that IFTTT hosts and removes automatically, along with the attachment's details.
Get audio features from a track
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the audio feature from a track
Get conversation
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the messages in a Gmail conversation, looked up by its thread id: one result per message, oldest first, each carrying the message's full content alongside the conversation's participants and message count.
Get featured playlists
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of featured playlists.
Add label to email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add the label you choose to a specific email message in your Gmail account.
Add multiple rows to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to top of spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Add task to a list
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a task to the given task list.
Add track to a playlist
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will search for a track and add the first result to a playlist you specify.
Add track to a playlist by TrackID
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will add a track to a playlist given a TrackID
Add track to playback queue
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a track you specify to the end of current playback queue on Spotify. Only available for Spotify premium accounts.
Archive email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will archive a specific email message, removing it from your inbox without deleting it. The message remains in All Mail and stays searchable.
Create a draft
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will save a new email as a draft in your Gmail account without sending it. The draft waits in your Drafts folder until you open Gmail and send it yourself.
Create a draft reply
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will save a draft reply to a specific email in your Gmail account, kept in the original conversation. The draft waits in your Drafts folder until you send it yourself.
Create label
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new label in your Gmail account.
A task is completed
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a task is completed.
Add label to email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add the label you choose to a specific email message in your Gmail account.
Add multiple rows to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to top of spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Add task to a list
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a task to the given task list.
Add track to a playlist
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will search for a track and add the first result to a playlist you specify.
Add track to a playlist by TrackID
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will add a track to a playlist given a TrackID
Add track to playback queue
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a track you specify to the end of current playback queue on Spotify. Only available for Spotify premium accounts.
Archive email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will archive a specific email message, removing it from your inbox without deleting it. The message remains in All Mail and stays searchable.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Create a draft
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will save a new email as a draft in your Gmail account without sending it. The draft waits in your Drafts folder until you open Gmail and send it yourself.
Build an automation in seconds!
If
Select a trigger the automation will use
A task is completed
Cell updated in spreadsheet
New attachment
New conversation
New email
New email matching search
New episode from a followed show
New episode from search
New followed show
New label
New recently played track
New row added to spreadsheet
New saved album
New saved episode
New saved track
New sent email
New show from search
New spreadsheet added to folder
New starred email
New task added
New track added to a playlist
New worksheet in spreadsheet
Then
Select an action the automation will perform
Add label to email
Add multiple rows to spreadsheet
Add row to spreadsheet
Add row to top of spreadsheet
Add task to a list
Add track to a playlist
Add track to a playlist by TrackID
Add track to playback queue
Archive email
Create a draft
Create a draft reply
Create label
Create spreadsheet
Delete email
Follow a playlist
Forward email
Pause playback
Remove label from conversation
Remove label from email
Reply to email
Save a track
Send an email
Send yourself an email
Skip track
Start playback
Update cell in spreadsheet
Update multiple rows in spreadsheet
Update row in spreadsheet
You can add delays, queries, and more actions in the chat.
More on these services
About Gmail
Gmail and IFTTT connect your inbox to 1000+ other apps and devices to automate routine email management tasks. Keep your inbox organized, ensure timely follow-up with custom reminders, keep teams informed for urgent messages, or even change your lights if a specific email comes in. Spend less time managing your email with easy-to-use automations.
The use of information received from Google Workspace scopes will adhere to the Google User Data Policy, including the Limited Use requirements.
About Spotify
Spotify is a digital music service that gives you access to millions of songs. Applets can help you save your Discover Weekly and Release Radar playlists, share your favorite tunes, and much more.
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
About Google Tasks
Get more done with Google Tasks. Keep track of your daily tasks, organize multiple lists, and track important deadlines with Google Tasks. Tasks synchronizes across all your devices, so your lists and tasks go with you, wherever you are.