Google/Zapier location import

Question

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?

Antonio Panea · Answer

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:

https://developer.atlassian.com/cloud/trello/rest/api-group-cards/#api-cards-id-put

Here more information about how webhooks in Zapier works:

https://zapier.com/apps/webhook/integrations

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!

Thanks

Cheers

Toni

Edward Tatton · Answer

Thanks so much for your reply, do you have a link where I can find out more info on how to utilize the Trello API to update content in the cards?

milynnus · Answer

@Edward Tatton

Assuming you have the right plan, you can use Trello api to update the address, locationName and the coordinates attributes.