Keep track of my completed tasks in a Google Spreadsheet
Start today
Other popular Google Sheets workflows and automations
-
1.3k - Save the Tweets you like on Twitter to a Google Spreadsheet
2.5k - Do more with your Discover Weekly playlist
1.1k - Archive every Tweet you post to a spreadsheet 35.4k
- Add your Foursquare check-ins (w/ maps) to a spreadsheet2.9k
- Track #hashtag mentions in a Google Spreadsheet 2.4k
- Add new Square payments to a spreadsheet2.5k
- Keep a running Drive spreadsheet of Pocket articles
971 - Create a spreadsheet of new laws, eliminating the need for countless Washington, DC interns
1.1k
Useful Google Sheets and Microsoft Teams 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.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- 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.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- 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.
Post to channelThis action will post a message to the specified channel.- 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 Microsoft Teams resources
Top 3 cheapest cloud storage options
Click to learn about the top 3 cheapest cloud storage options!
Google Meet versus Zoom
Google Meet versus Zoom are two popular popular video conferencing tools that have become essential for remote communication and collaboration. In this article, we will compare key features, pricing plans, security measures, user...
7 best spreadsheet apps other than Excel
Check out our recommendations for the best spreadsheet apps and learn how you can build useful automations in minutes with IFTTT!
IFTTT helps all your apps and devices work better together