Skip to main content
Question

How to record both original and updated due dates from Asana in Google Sheets

  • February 8, 2025
  • 1 reply
  • 8 views

Newbie16

I created a zap that will automatically create a spreadsheet row whenever the due date of an asana task is updated. Now, I want the original due date to be recorded as well as the new due date. How will I do that? I hope someone will be able to assist me. Thank you

 

 

Did this topic help you find an answer to your question?

1 reply

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7289 replies
  • February 10, 2025

Hi there ​@Newbie16, welcome to the Community! 😁

I’d have thought that yo’d need to use a Lookup Spreadsheet Row action to record the original due date. That action has the ability to create a new spreadsheet row if one isn’t found. So if the Zap triggers for a task that has a due date set and it’s not in the spreadsheet already then that due date would be used for the Original Due Date column.

Then to handle cases where a new due date is set you’d have a Filter in the same Zap, that checks to see if an existing row was found (the Zap Search Was Found Status field will contain a value of true if it finds a row and false if it doesn’t). And if it was, then an Update Spreadsheet Row action would add the new due date value to the New Due Date column for that row.

Hope that helps to get you pointed in the right direction. If you run into any issues on that or have further questions just let us know!