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'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.
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.
@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.
@TheDavidJohnson, thank you for your reply! I'll answer it a little bit later!🙂
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.
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!😊