Back
Todoist New completed task. Microsoft 365 Excel Add row to workbook.

Log completed Todoist tasks to Microsoft 365 Excel

Connect

How this automation works

Automatically track your productivity by adding completed Todoist tasks to an Excel spreadsheet. This Applet runs each time a task is marked complete in your chosen Todoist project, adding its details as a new row in a Microsoft 365 Excel workbook. Ideal for keeping organized records of your progress and sharing task history across projects.

If
Todoist icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger​ ​fires every time a task is marked as​ ​completed in Todoist.
TaskContent TaskDescription LinkToTask Project Labels Priority CompletedAt DueDate Section
Then
Microsoft 365 Excel icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the worksheet you specify in the workbook.
path filename formatted_row worksheet_name

Services used in this Applet

Create your own Microsoft 365 Excel and Todoist workflow

Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.

15 triggers, queries, and actions

Cell updated in workbook

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the workbook you specify.

New completed task

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger​ ​fires every time a task is marked as​ ​completed in Todoist.

New completed task with label

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a task is marked as completed with a label you specify.

New row added to workbook

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a workbook you specify.

New task created

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time you create a new task in Todoist.

New task created in section

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time you create a new task in a Todoist section.

New task created with label

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time you create a new task with a label you specify.

Current value of a cell

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your workbook.

History of completed task with label

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time a task was marked as completed with a label you specified. NOTE: Labels are only supported for Todoist Premium users.

History of completed tasks

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time a task is marked as? ?completed in Todoist.

History of tasks created

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time you create a new task in Todoist.

History of tasks created with label

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time you create a new task with a label you specify. NOTE: Labels are only supported for Todoist Premium users.

Add row to workbook

Pro icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the worksheet you specify in the workbook.

Create task

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new task in the project and section you specify.

Update cell in workbook

Pro icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will update a single cell in the workbook you specify.

Add row to workbook

Pro icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the worksheet you specify in the workbook.

Cell updated in workbook

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the workbook you specify.

Create task

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new task in the project and section you specify.

Current value of a cell

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your workbook.

History of completed task with label

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time a task was marked as completed with a label you specified. NOTE: Labels are only supported for Todoist Premium users.

History of completed tasks

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time a task is marked as? ?completed in Todoist.

History of tasks created

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time you create a new task in Todoist.

History of tasks created with label

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time you create a new task with a label you specify. NOTE: Labels are only supported for Todoist Premium users.

New completed task

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger​ ​fires every time a task is marked as​ ​completed in Todoist.

New completed task with label

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a task is marked as completed with a label you specify.

New row added to workbook

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a workbook you specify.

New task created

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time you create a new task in Todoist.

Build an automation in seconds!

You can add delays, queries, and more actions in the next step!

More on Microsoft 365 Excel and Todoist

About Microsoft 365 Excel

Microsoft 365 Excel is a powerful spreadsheet program used for organizing, analyzing, and visualizing data. Leverage its capabilities to manage finances, track projects, and perform complex calculations with ease. Connect Microsoft 365 Excel to IFTTT to automate data entry, generate reports, and trigger actions based on spreadsheet changes. Optimize your data workflows and enhance productivity across your personal and professional tasks.

Explore Microsoft 365 Excel

More integrations with Microsoft 365 Excel

About Todoist

Todoist is a to-do list app and online task manager that works across 15 different platforms including Web, iOS, Android, Google Chrome, Mac, and Outlook. Turn on Applets to quickly and automatically create new tasks, and sync or share tasks across other systems and services. Download the Todoist app today and start automating with IFTTT.

Explore Todoist

More integrations with Todoist

IFTTT helps all your apps and devices work better together

Get started for free