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.

Best answer

Is there a way to follow timedata for a random Trello Card into Sheets ?

  • September 23, 2022
  • 8 replies
  • 59 views
KevinCocoonr

Hello,

I didn’t found any informations here on the Community Zapier so I’m trying to figure out how I can automate data time for a random Trello card to different lists in Trello.

 

Each cards in Trello will be create randomly so I can’t add an ID card before.

 

The issue is that I will move manually the card to different lists as “steps” but everytime I use the trigger “moved to list XX” it creates a new row and it’s not following the ID Card in Trello 😥

 

Is there a way to follow the “life” (in my case I will need the time in order to calculate a duration) of a specific and random card in Trello to different lists in Google Sheets ?

Not really sure that my question is clear 🙄

 

For the moment I can only easily follow the time creation of a random card in Sheets… It’s a beginning but not enough unfortunately..

 

Thank you in advance for your help and support !

 

PS : I can provide screenshots of my Spreadsheets and Trello Board if it could help

Best answer by Troy TessaloneBest answer by Troy Tessalone

@KevinCocoonr 

This expects a numerical value, but you have the Trello Card ID value also mapped.

 

I'm seeing an errors that mention 'range' (cannot parse range, requested writing within range)

If you are getting an error that says something like cannot parse range or 400 Error: Requested writing within range ['DO NOT EDIT: Feed via Zapier'!A74], but tried writing to column [B], there are a couple of possible causes:

  • There is a colon (:) in your worksheet or spreadsheet title. If so, try removing it - colons in spreadsheet and worksheet titles can sometimes cause a Zap to malfunction.
  • There are no fields mapped in the Zap. This error sometimes occurs when the Zap attempts to add a completely blank row.
  • The spreadsheet/worksheet name has changed. Make sure you turn the Zap off while you make the change, and then turn it back on again after.
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.

8 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 31004 replies
  • September 23, 2022

Hi @KevinCocoonr 

Good question.

Help article: https://zapier.com/help/doc/finding-and-updating-rows-in-google-sheets

Try using these Zap steps

  1. Trigger: Trello - Card Moved to List
  2. Action: GSheets - Lookup Row
  3. Action: GSheets - Update Row

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
KevinCocoonr
1 person likes this
  • KevinCocoonr
    KevinCocoonr
KevinCocoonr
  • KevinCocoonrBeginner
  • Author
  • Beginner
  • 4 replies
  • September 23, 2022

Hi @Troy Tessalone 

Thank you for your feedback I will try this out !

 

 

jesse
Forum|alt.badge.img+9
  • jesseArchitect
  • Architect
  • 1348 replies
  • September 26, 2022

Hey @KevinCocoonr! Eager to hear if this worked for you. Let us know! 🙂

KevinCocoonr
  • KevinCocoonrBeginner
  • Author
  • Beginner
  • 4 replies
  • September 28, 2022

Hello @jesse and @Troy Tessalone ,

 

I’m still blocked with an error on my zap 😥

 

Failed to create a spreadsheet row in Google Sheets
There was an error writing to your Google sheet. Unable to parse range: ….

 

Any idea how I can solve this issue ? I don’t have any frozen/hidden/protected columns or rows, spreadsheet or worksheet name changed since it was initially selected or insufficient permissions (read-only)

 

Maybe I can share you some screenshots of the zap actions or my spreadsheet ? I will create a separate one from the original with fake data of course😅

 

Thank you !

KevinCocoonr
  • KevinCocoonrBeginner
  • Author
  • Beginner
  • 4 replies
  • September 28, 2022

Hello again

 

You can find below a fake Gsheet that I use for the test :

 

And all the actions in my zap :

 

 

I hope these screenshots will be helpful ! 

 

Thank you again for your time 😇

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 31004 replies
  • Answer
  • September 28, 2022

@KevinCocoonr 

This expects a numerical value, but you have the Trello Card ID value also mapped.

 

I'm seeing an errors that mention 'range' (cannot parse range, requested writing within range)

If you are getting an error that says something like cannot parse range or 400 Error: Requested writing within range ['DO NOT EDIT: Feed via Zapier'!A74], but tried writing to column [B], there are a couple of possible causes:

  • There is a colon (:) in your worksheet or spreadsheet title. If so, try removing it - colons in spreadsheet and worksheet titles can sometimes cause a Zap to malfunction.
  • There are no fields mapped in the Zap. This error sometimes occurs when the Zap attempts to add a completely blank row.
  • The spreadsheet/worksheet name has changed. Make sure you turn the Zap off while you make the change, and then turn it back on again after.
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
KevinCocoonr
1 person likes this
  • KevinCocoonr
    KevinCocoonr
Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • September 30, 2022

Hi @KevinCocoonr! 

Did you try removing the Trello card ID from the Row field as Troy suggested? If so, did that do the trick?

Let us know if you’re still running into an error with this, we’d love to see you up and running :) 

KevinCocoonr
  • KevinCocoonrBeginner
  • Author
  • Beginner
  • 4 replies
  • September 30, 2022

Hello @Troy Tessalone and @Danvers 

 

Thank you so much it works ! I have just erased the Trello card ID from the row field and it worked smoothly now :)

 

Have a nice evening !😊

Terms & Conditions