About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Error When Testing ClickUp/Google Tables Zap ""You do not have access to this task"."

  • 27 October 2023
  • 5 replies
  • 53 views
W
Userlevel 1

I am trying to use Zapier to send new rows added to a Google Table (not Sheet) to ClickUp. When I test my zap, I receive the following error:

Failed to create a task in ClickUp

The app returned "You do not have access to this task".

I can’t find any information on the task the Zap can’t access. I’ve looked through the history, and nothing is listed. I’ve hit a brick wall as far as troubleshooting is concerned, so any advice is welcome. Thanks in advance.

icon

Best answer by Troy Tessalone 27 October 2023, 15:54

View original

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @wodajr 

Good question.

Please post screenshots with how your Zap steps are configured to help give us context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
W
Userlevel 1

Thanks @Troy Tessalone! I’ve included the workflow with the pertinent screenshots.

 

Step 1: Connecting to the Google Table with the Applicant’s Data

Step 2: Lookup the job posting associated with the application from the Job Postings Google Table

Step 3: Date Formatting

Step 4: Phone Number Formatting

Step 5: Date Formatting

Step 6: Trasferring data from Google Tables to ClickUp

 

Troy Tessalone
Userlevel 7
Badge +14

@wodajr 

Issue is likely related to this field.

The field is a dropdown with a list of options.

Each dropdown list option has 2 values (top/bottom).

If you are going to map a dynamic variable, then the variable value must match the bottom value of a list option.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
W
Userlevel 1

Thanks again, @Troy Tessalone. That seems to have solved it.

ken.a
Userlevel 7
Badge +6

That’s awesome @wodajr! Big thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 😊

Reply


Terms & Conditions