Best answer

How to move existing tasks from Todoist to Google Sheets?

  • 1 October 2019
  • 32 replies
  • 2531 views


Show first post

32 replies

Userlevel 5

Sounds good, @terbiy — let me know if you have a question about Airtable or if you'd like some additional detail. It should be able to accommodate everything you're trying to do. Cheers!


Userlevel 3

Thank you,



Userlevel 3

Thank you,



Userlevel 7
Badge +10

@terbiy The most of the time this should work.

Build a zap that triggers daily.

Have the zap create the new worksheet.

Then you want a "Google Sheets -> Find Many Spreadsheet Rows"

Assuming your task list sheet has a date column, you can search by that with the today's date to bring back all (up to 10) the tasks due that day.

You can then use a "Google Sheets -> Create Spreadsheet Row(s)" step to write these rows to your new workbook (you'll need to map the new worksheet ID at this step).

Edit: This doesn't take care of the overdue tasks, though, we might need some more creative thinking for that.


Userlevel 5

This feels like a job for Airtable to me. With their flexible "views," you can easily accomplish this!


Userlevel 3

HI @Andrew_Luhhu! Thank you!🙂

In case I'm not on vacation, it's less than 10. However, several times a year, there can be more. Sometimes there can be no overdue at all.


Userlevel 7
Badge +10

Hi



Reply