I use Todoist almost every day, and in the mornings I transfer all the tasks manually to Google Sheet to analyze the possibility of their accomplishment from the perspective of time, place, risk and its mitigation.
What I want Zapier to do is to:
- Create a new sheet in specific workbook (done now).
- Move all the overdue and today tasks into the rows of the first column starting from the second one: one for one row.
My search through the available functionality wasn't successful. If you have any ideas, this would be great to find them out!
Best answer by terbiyView original
I think now I can sum up the current state, which I can call a solution or a significant improvement at least.
My system looks the following way now.
Now when in the morning, I need to do my usual planning where I fill the table with task, time, place, risk and risk mitigation I use the autocomplete most of the time.
Many thanks for
@AndrewJDavison_Luhhu, @Danvers and @jesse for your support and ideas!😊
Uf, it's been a while, but here I am to continue this great discussion!
Maybe I haven't understood it right, but do you imply that I can use project names collected in Airtable in my zap where I want to trigger action on any new task in any project? If so, I cannot now think about how I can use this data. My options are very restricted on "When this happens..." part. Here are pictures attached to illustrate this.
@TheDavidJohnson, thank you for your reply! I'll answer it a little bit later!🙂
@PaulKortman, thank you for the indeed great suggestion! I've created a project zap and the main action zap to give it a try. This way looks promising.
Interesting. I'm just now catching up on all of this and it seems like there are a few ideas worth pursuing. The one thing I'm wondering,
@terbiy is this: when the "Project" changes, is that something that causes a task to be "updated" as well?
My thinking runs along these lines: If you're updating Airtable when a task gets "Updated," then you might be able to cause the latest "Project" name to be written to Airtable. This way, you'll have that data handy when you need to use it in a Zap like the one where you got stuck.
I hope this makes sense! It might be possible that I'm missing something here, but it seems feasible that something along these lines might be possible.
I've found a workaround that isn't ideal but still keeps the automation in place. I split the zap into two zaps, one which does all the work (Zap 😎, and the other (Zap A) which is the trigger on each project. You would still need to copy Zap A for each project, but if you needed to change anything in the process it would only be one zap (Zap 😎 that would need to be changed.
You will end up with as many Zap A's has you have projects, and the only thing that changes is the project. You will have only one Zap B as all Zap A's call Zap B with the data they were given. Your Zap B does all the heavy work.
Hm, I know these kinds of things, I'm a front-end developer!😁 I tried to use the ”*” symbol as done in Bash, and what's surprising, I had even received the successful test on it. Unfortunately this happened only once and saving failed on attempts to test Airtable.
I also experimented with possible predefined values like ”all”. I concatenated the ids of several projects and separated them with comma. I used multiselection in Todoist client to see how the address gets formed, but multiselection doesn't influence it.
Thank you for adding my vote,
@Danvers! This feature would be great, indeed. Maybe I will still implement the trigger for several projects to try the overall solution.
Right now, it's not possible to set up the Todoist Completed task trigger without selecting a Project, sorry about that!
We do have an open feature request to allow folks to watch for completed tasks across all projects and I've added your vote for that addition. It's not possible for us to build it right now as the Todoist API (the bit of code that allows Zapier to 'talk' to them) requires a project to be specified when looking for completed tasks. If this changes in the future and we're able to make the change, we'll send you an email to let you know!
On the initial "When this happens..." step I need to specify what project to observe for the new incomplete tasks. And what I want here is to say that I wish this zap to get triggered on the new task in any project. But this option is not available, and I need to choose only one.
The look-up table tool from utils is only available on "Do this..." step so I can't utilize it. Did I get it right or there is something that I've missed?
@PaulKortman was suggesting is that, because you have a lot of projects, you could use Google Sheets to create a lookup table. Have the project name on in Column A, and the Project ID in Column B, then use a Google Sheets Find row step to get the project ID that matches the name of the project. Does that help?
bouncing off of what
@Andrew_Luhhu suggested if you don't want to edit the zap each time you make a project you could have a spreadsheet "lookup table" that maps project ID to whatever you need.
And you could even have a zap that triggers off of a new project and writes a line to that spreadsheet so there's no manual input needed.
I thought that I've almost done it to the solution, but stopped in an unexpected place.
When building action on "New Completed Task in Todoist" event, I need to enter the required Project field. But projects in my approach are very dynamic, now I have 54 of them, so it seems like an inconvenient way to handle new tasks this way: to create 54 zaps. Should I start a new thread for this issue or continue this one?
@terbiy! Your use of filters is exactly the direction I had imagined would be beneficial to you. I'm thrilled that you're seeing time savings already!
Feel free to reach back out if you hit any speed bumps with the further enhancements! I'll be excited to see where you go with this! 😁
Glad you're making progress
As to your question to me - I'm not actually sure as I don't use Todoist very often. You may want to test or double check with Zapier support.
I try to implement suggestions one by one. My ultimate aim is regular process improvement, so the automation becomes a little bit like a moving target. Here is what happened since my last post.
@TheDavidJohnson recommendation, I've started using the Airtable service. The initial problem was the necessity to copy all tasks for a sheet dedicated to the current day by hand. In Airtable, I introduced the normalisation and moved all tasks descriptions to the other table. Due to the high number of recurring tasks, all I have to do now most of the time is to write several letters and choose a suggested option. To work only with the tasks for today, I use a filter and don't need to create a new sheet every day.
I feel that I've reached the significant improvement, but it looks even further from the possibility to automate!😳
Next, I'll respond to messages.
Here is the picture of my planning table now. The tasks are in Russian, but their content does not matter in this case. Task, Place, Risk and Risk mitigation columns are all links to other tables with corresponding names.
To enhance my current process as described above, I think I can make a Zap that will automatically add the description of the newly created tasks to the Tasks table, so I don't have to copy it manually. At the same time, I can't imagine the way to automate the creation of the planning table, but what I have now is much better than working with Google Sheets.
And yes, I have Todoist Premium subscription and we can rely on this.
I'm not sure how sophisticated we might want to get with this approach, but if you wanted to iterate through all the tasks that are not yet completed on a daily basis, then you could take this approach:
I'll admit the above is a little crazy to set up at first, but it could save a ton of time if I'm understanding the end goal correctly.
Airtable. Let us know what you think!
My advice would be to add them to the Google Sheet as soon as they are created with their due date.
You can then remove them from the Google Sheet when they are marked complete.
The only scenario this doesn't cover is if the due date changes after the task is created. Does that happen in your use case?
The step that I can't overcome now is how to get all the tasks for today held in Todoist and paste them either in Google Sheets or Airtable?
Beforehand thank you!