You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I'm looking to utilize a Google Sheet with a client list, I'd like to create a Google form that can select a client from a drop down menu, and when submitted the location info would show up in Trello. I've gotten it to work but only as a "custom fields" not "location".
Does anybody know how to get a Google form to provide location information into a Trello card?
Hi @Edward Tatton ,
founder of Crmble here! Do you need that location to check those on the map, or is it just for having the information on the card? As @milynnus said, you could do that through API.
In Zapier there is a Zap called "Webhooks". There you will be able to update an endpoint or make API calls like POST in your case to update a specific value of the location of each card. That will require adding some Zapier steps like "search for" and maybe even creating your database to get id of the cards just in case the name of the card changes for whatever the reason is.
Here you will find more information about API Trello for updating the Location:
Here more information about how webhooks in Zapier works:
JFYI what you could do with Crmble is to link that form or spreadsheet with Crmble to generate cards in Trello without Zapier. It will also create a link that will redirect the location to google maps, for example. You will not need to create your database neither
If you are interested in knowing more, just let me know!