Other popular Google Sheets workflows and automations
- Save your Fitbit sleep logs to a Google Spreadsheet
- Do more with your Discover Weekly playlist
- Save the Tweets you like on Twitter to a Google Spreadsheet
- Log WiFi connections/disconnections
- Track every time the ISS passes over your house
- Sync all your new iOS Contacts to a Google Spreadsheet
- Gmail to Sheets
- Put all your completed tasks in a Google Spreadsheet
- How strong is your currency in another country? Log the exchange rate every day
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
Introducing the AI Twitter Assistant
Introducing the Twitter AI Assistant - New Twitter automation tool
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.
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 export Trello to Google Sheets
Learn how to export your Trello boards to Google Sheets automatically. Set up this integration in minutes with IFTTT.
How to export Twitter to Google Sheets (automated and manually)
Stop losing Tweets in the online abyss - Set up a Twitter to Sheets integration in minutes 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!