Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How Can I Automatically Include Closed Dates from ClickUp Tasks to Google Sheets After an Interval?
Best answer

How Can I Automatically Include Closed Dates from ClickUp Tasks to Google Sheets After an Interval?

MischaDR99
Forum|alt.badge.img+1

Hi everyone,

with your help I was able to take a very big step towards automating an important part of my payroll. Thank you everyone!

So I have set up a zap from ClickUp to Google Sheets, it basically gives me a lot of important information about tasks such as:

  • Project type
  • Start date
  • Due date
  • Assignee

The only information I want to automatically synchronize which is not yet showing is the closed date.

Ofcourse the task is only closed after a specific interval, usually about 5-10 working days.

Is there any way to enhance my current zap so that it also syncs this information?
Your help is greatly appreciated!

 

kind regards and have a great weekend guys :) 

 

Best answer by Troy TessaloneBest answer by Troy Tessalone

@MischaDR99 

Try adding a Filter step between the 2 GSheet steps, with a condition that checks if the 1st Delivered Date ID is empty.

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @MischaDR99 

Good question.

Please post detailed screenshots with how your current Zap steps are configured to help give us more context, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
MischaDR99
Forum|alt.badge.img+1
  • MischaDR99Beginner
  • Author
  • Beginner
  • 11 replies
  • August 21, 2023

Thanks for your reply @Troy Tessalone really appreciate your help! :) 

Here are screenshots of how I have currently set up my Zap

Let me know if you need anything else

 

I have chosen the event '’task changes'’ instead of '’new task'’ since it otherwise wouldn't sync the project number (which I add manually after the client have submitted the form)

 

Because the event I chose is '’task changes'’ I have set this trigger to '’assignee added'’ so that it does sync the project name which was entered by me manually. Only after that I add the assignee 
As you can see there is no data to be found yet for the delivered date since this usually takes about 5-10 working days after the initial form submission and thus creation of the task.

 

Troy Tessalone
Forum|alt.badge.img+14

@MischaDR99 

You would need another Zap configured to detect when the Asana Task date is populated, to then find/update the GSheet Row.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
MischaDR99
Forum|alt.badge.img+1
  • MischaDR99Beginner
  • Author
  • Beginner
  • 11 replies
  • August 26, 2023

@Troy Tessalone thank you very much for this answer! I actually took the time to configure this zap and I can confirm it works now!

I did however run into another issue, but let me give you a bit of context first.

Since we're a design agency we usually have to deal with revisions from the client so therefore a specific task is put to the status '’finished'’ multiple times.

The zap unfortunately keeps updating the task closed data which I actually don't want. I only want to see the date of the 1st delivery in my google sheets.

I have done some research and found that I could get this to work by creating a new custom field in ClickUp but this isn't the most convenient way to solve the situation since it requires some additional manual work.

What I also tried is creating another status in clickup called '’1st delivery'’. I just wasn't able to export the actual date and time of when a task was moved into this status.

I was wondering if you know any other way to stop the zap from updating the cell value more than once?

Hereby I share how I have currently set up my zap:

 

 

 

 

 

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 31377 replies
  • Answer
  • August 26, 2023

@MischaDR99 

Try adding a Filter step between the 2 GSheet steps, with a condition that checks if the 1st Delivered Date ID is empty.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
MischaDR99
Forum|alt.badge.img+1
  • MischaDR99Beginner
  • Author
  • Beginner
  • 11 replies
  • August 27, 2023

Thanks @Troy Tessalone this makes so much sense right now, LOL.

I guess I was too much in my head yesterday haha. Anyways thanks for all the help you provided, really appreciate it. 

Hope you have a wonderful day 😄

SamB
1 person likes this
  • SamB
    SamB
Terms & Conditions