
Other popular Google Sheets workflows and automations
-
Back up new texts you receive on your Android device to a Google Spreadsheet
-
All your new reminders in one Google Drive spreadsheet
-
Create a new row in Google Sheets every time someone mentions your business on Twitter
-
Automatically add a new row to Google Sheets when you receive a new Google Business review
-
When a song is added to a Spotify playlist, song details appended to Google Sheet
-
Automatically add your saved tracks in Spotify to a Google spreadsheet
-
Track work hours in a Google Spreadsheet
-
Log every time you stop charging your phone to a Google spreadsheet
-
Log WiFi connections/disconnections
Useful Google Sheets and Google Tasks integrations
Triggers (If this)
-
New spreadsheet added to folder
This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
-
A task is completed
This trigger fires when a task is completed.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
New task added
This trigger fires when a task is added to a list.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.






Queries (With)
-
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
-
List all tasks in a list
This query returns a list all the tasks in a given task list.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
List all task lists
This query returns a list of all your task lists.
-
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
-
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
History of spreadsheets added to folder
This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.








Actions (Then that)
-
Update cell in spreadsheet
This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
-
Add task to a list
This action will add a task to the given task list.
-
Add row to spreadsheet
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.



Google Sheets and Google Tasks resources

The 25 Best IFTTT Applets: Revolutionizing Your Digital Workflow
the 25 best IFTTT Applets

10 best productivity apps for 2025
IFTTT has helped over 30,000,000 people become more productive by automating their life. Click to learn about the 10 best productivity apps for 2025.

How an IFTTTer (us) automates their LinkedIn
IFTTT can now help creators and businesses automate their LinkedIn. Click to learn more!

7 repetitive tasks that small businesses should automate in 2025
Looking to improve your small business? Consider automating some of your tasks. IFTT will help you explore the benefits of automation and recommend some popular apps to use. Small Busines Automation

How a freelancer automations their tutoring business with IFTTT
IFTTT can now help teams and businesses alike automate their tutoring business. Click to learn more!

How an IFTTTer is automating their project management
IFTTT can now help teams and businesses alike automate their project management. Click to learn more!

How an IFTTTer automates their Twitch
Twitch is one of the most popular services on IFTTT. Automate your Twitch today!

How to connect your first Applet
Learn how to connect your first automation, called an Applet, on IFTTT. There are two easy ways to create Applets and integrate your favorite services. Find an Applet in our vast library or make your own custom Applet in a few quick and ...

How to automate scheduling tasks to improve productivity
Explore the differences between scheduling tasks and automating scheduled tasks. IFTTT is here to help you discover what tasks should be scheduled instead of automated, as well as step-by-step instructions for automating scheduling tasks...