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.

Question

How to Import Tasks from Google Sheets to Asana Without Duplicating

  • October 29, 2024
  • 3 replies
  • 13 views
C

 

Hi, I’m looking for support with this same thing.

I have successfully created the Zap but the problem is that it continually runs and adds the same tasks over and over again.

 

End goal: I want a list of tasks created for various projects in Google Sheets to import into Asana as Tasks, when I manually trigger it. Without creating the same tasks over and over. 

Any ideas? Thanks!

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

3 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7532 replies
  • October 30, 2024

Hi @cadexpat, welcome to the Community! 🎉

Hope you don’t mind but we’ve split this out into a new topic as you seem to be facing a different issue of the exact same tasks being added repeatedly, rather than not being added at all.

If you’ve mapped the task information directly from the relevant Google Sheets trigger fields then the Asana tasks should be created with the relevant task details that are supplied by Google Sheets, not the same exact tasks everytime. 🤔

Are you by any chance using the New or Updated Spreadsheet Row (Google Sheets) trigger? If so, I wonder if it could be that edits to the existing rows are triggering the Zap and causing the tasks to be re-added. Or were there structural changes like the deletion/sorting of rows that might have caused existing rows to be seen as new and caused the Zap to re-trigger for old information. Do you think either of those might have been the case here?

If not, can you share a screenshot showing the current setup? That’ll help us to get a better idea of what might be causing the same tasks to be added repeatedly. Make sure to blur or remove all personal information (names, emails, addresses etc.) from screenshots before sharing - you can use a tool like Zappy for that.

Thanks, looking forward to hearing from you!

C
  • cadexpat
  • Author
  • New
  • 1 reply
  • October 30, 2024

Hi SamB, thanks for your reply. I decided to go another direction with setting this up. Appreciate your response and feedback though.

 

 

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7532 replies
  • October 31, 2024

No worries @cadexpat, thanks for letting us know! 🙂

We’d be super grateful if you could share a quick outline of the different approach you took when you have a moment. I’m sure many in the Community would benefit from hearing about it! 🙏

Reply


Terms & Conditions