Hi, I m trying to setup integration where I need to get a result when everytime a card updated in Trello, the Google Spreadsheet Row should update too.
I’ve been trying the steps like Every Card Updated - Update Spreadsheet Row but still didn’t work and only 1 specific row updates every time. Can someone please help me to setup this?
Thank you in advance!
Best answer by Liz_RobertsView original
@keycamillereyes ! Thanks for hopping in with this question!
To help us better understand where you’re at with this Zap, could you share screenshots of your configuration thus far (minus any personal info)?
In the meantime, it sounds like we’re looking for:
Once we can check out some screenshots, we can dive deeper!
Thank you for the response Liz! Here are the screenshot of what I have on my Zap, I want to update multiple rows every time each card updated.
They already have their records on the sheet when they added a card for the first time.
But we want to update the card on trello, we want to update the card as well in the Google sheet existing row.
It seems our Support team has identified the culprit here- a Lookup Row! Posting their solution below in an effort to assist future members who may encounter a similar scenario:
If you'd like to update a row in Google Sheets when a corresponding card in Trello is updated you'll want to add a step to Lookup Spreadsheet Row to your Zap. Your Zap setup would be like this:
This is to ensure that the Zap finds the row corresponding to the Trello card, and so you can map its ID in the step to update.
You can also read more about find/ search steps here: https://zapier.com/help/create/basics/search-for-existing-data-in-zaps
Hi Liz! Thank you for the information above.
One thing I need to confirm, I used the Lookup Search and it only update 1 row every time even other cards updated that specific row only is the one that updating.
How can we make that every row on each corresponding cards that will need to be updated?
Thank you so much!