Hi there,
New to the ecosystem & community here. I’m trying to create a simple scenario where when I update a Todoist task (either name or description), that it updates a corresponding spreadsheet as well (Spreadsheet already populated via another scenario to pull all task info).
I can use an array aggregator to pull the task ID, task name (content) and task description (description) from Todoist and then create a filter for Google Sheets but I’m not sure how to tell Google Sheets which Row to update. If I just say “2” for row number, I can update the task name or description and it updates fine… but can’t seem to parse the info and tell google sheets which row to update (based on task ID).
I figured the Task ID from Todoist would be handy to use but any help would be much appreciated. I’ve searched a whack of topics on the community and can’t quite figure it out.
Thanks!
Hello @Fattcamp, you can find a common value for both the Todolist and the googlesheet so you can search for the row based on the value and update it
Hi there. Thanks for the quick reply. Yes that’s why I grabbed the Todoist task ID and populated that in the sheet in advance. I’m just not sure how to tell the google sheets module in the Make scenario how find that specific row since it just asks for Row Number. (The first column is the task ID).
You can use the get range values to get all values in the sheet and use the search ranges to filter the search the filter will contain the todolist id row and the todolist id itself
2 Likes
Appreciate the info. Before coming back and reading this, I was able to figure out a solution by adding a Google Sheets Search Rows module between the Todoist array aggregator and the Google Sheets Update a Row module (Last Module). This is similar to your Get Range Values option by the sounds of it. I was then finally able to point the row number field to the row number from the previous Sheets module.
I wasn’t thinking about the fact that you needed the Google Sheets module twice in order to grab info to reference in the final module but it worked! Thanks again for the quick replies.
Dave
2 Likes