Log every time you stop charging your phone to a Google spreadsheet
Start today
Triggers (If this)
Queries (With)
Actions (Then that)
Other popular Google Sheets workflows and automations
-
2.82K
-
-
Save new Google contacts to a Google Drive spreadsheet
8.14K
-
-
When a reddit post is saved, enter a row into a Google Drive sheet with its info.
1.32K
-
-
Track every time the ISS passes over your house
4.07K
-
-
Log new items in Raindrop.io to a Google Sheet
1.01K
-
-
Automatically add a new row to Google Sheets when you receive a new Google Business review
5
-
-
Create a new row in Google Sheets when your business is tagged in a Facebook photo
1
-
-
All your new reminders in one Google Drive spreadsheet
1.92K
-
-
Add your Foursquare check-ins (w/ maps) to a spreadsheet
2.87K
-
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.
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.
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)
-
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.
-
Add task to a list
This action will add a task to the given task list.
-
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 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.
Add task to a list
This action will add a task to the given task list.
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.
Google Sheets and Google Tasks resources
How an IFTTTer (us) automates their LinkedIn
IFTTT can now help creators and businesses automate their LinkedIn. Click to learn more!
How a freelancer automates 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!
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.
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
IFTTT helps all your apps and devices work better together