Record every time your phone's battery is low in a Google spreadsheet
Start today
Other popular Google Sheets workflows and automations
-
3.0k - Save the Tweets you like on Twitter to a Google Spreadsheet
2.5k - All your new reminders in one Google Drive spreadsheet1.9k
- Keep track of my completed tasks in a Google Spreadsheet 1.3k
- Automatically track your Fitbit weight logs in a Google spreadsheet
8.6k - Save all of your liked videos in a spreadsheet14.7k
- Keep a log of your recently played tracks
999 - Archive every time you're @mentioned to a Google spreadsheet 1.1k
- Archive every Tweet you post to a spreadsheet 35.4k
Useful Google Sheets and Google Tasks integrations
Triggers (If this)
- New spreadsheet added to folderThis 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 completedThis trigger fires when a task is completed.- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- New task addedThis trigger fires when a task is added to a list.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
Queries (With)
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- List all tasks in a listThis query returns a list all the tasks in a given task list.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- List all task listsThis query returns a list of all your task lists.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of spreadsheets added to folderThis 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 spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- Add row to spreadsheetThis 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 task to a listThis action will add a task to the given task list.
- Update cell in spreadsheetThis 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.
Google Sheets and Google Tasks resources
What are webhooks and how do you get the most out of them?
What are Webhooks and how to you use them? Click to learn all about Webhooks with IFTTT.
How to make a graph or chart in Google Sheets
In this article, we will show you how to make graphs in Google Sheets. We will also introduce you to IFTTT, which can help automate your workflow and save you time. Let's get started!
How to export Trello to Google Sheets
Learn how to export your Trello boards to Google Sheets automatically. Set up this integration in minutes with IFTTT.
7 repetitive tasks that small businesses should automate in 2024
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 to use Calendly (Easiest Guide)
New to Calendly? Click to read how to use Calendly quickly and easily. IFTTT connects Calendly with 750+ digital tools. Join IFTTT today!
Google Forms versus Jotform?
In this article, we will explore each of these aspects to help you understand the differences between Google Forms and Jotform, and determine which tool is best suited for your needs.
IFTTT helps all your apps and devices work better together