In the last post we setup a workflow in n8n to task data in a specific format and push it into Todoist. Now that we have that workflow, we will automate pulling tasks from various sources into Todoist through that workflow.
Keeping track of all of your tasks can be difficult when they are spread out over many different sources. If you want to keep track of items in one location, one option is to manually create todos in your chosen location and link them back, a drawback to this is it's all manual and you have to manage the tasks in two places now for each task and you have to remember to link them in. Another option is to automate this task creation and linking. You can also automate closing of the items when closed in one source or another. We are going to explore setting this up in n8n in a reusable way to make it easier to add additional sources in the future. The tools we are using for this are n8n, todoist and postgresql. It can be adapted to other tools as well.
Being able to cache tasks from Todoist in a database will allow us to do more complex things with them (reports, further automations, etc). This post will cover how to set up the relevant tables and how to cache tasks from Todoist in it. We will also be setting up a Todoist application to allow us to access the Todoist API and receive webhooks.
n8n is a useful workflow automation tool that can be used to automate various tasks. This post will cover how to set up n8n in docker with PostgreSQL and Traefik and will be used as a base for future posts in this series.