From Trello to Google Sheets

Question

Hello Guys !

Last year, I used to make an automation from Trello to Google Sheets through Crmble and Zapier.

Today, I'm in a new job where we use Trello.

I might helo some teams to report their customer orders from Trello to a monitoring made on G.Sheets and I can use only Integromat (The only automation tool allowed by my company).

Therfore, is it possible to make a Trello >> Integromat >> Sheets automation or not please ?

Feel free to send me any useful tips and thanks in advance !

Omar Bensad

Trello Beginner - Business Analyst

Chandrashekhar Pandey · Answer

Hi Omar,

It's completely possible to make trello>>integromat>>google sheets automation.

But as I understand from your post your company is selective in using only Integromat due to security or may be financial reasons.

For both the cases I have a better alternative to integromat. You can use apps script to address both of these concerns.

Best part of this solution is that it has 2 away sync between Trello and google sheets which no one is offering except for Unito and Unito is super expensive.

In my opinion you can achieve more with this solution.

You can go through this video to know more https://www.youtube.com/watch?v=ZJuXMA29y6I

Please let me know if it helps.

Sam Dixon_f5cu3w · Answer

Unito has a 2way integration for Trello and Google Sheets that’s pretty easy to set up.

https://unito.io/blog/guide-how-to-connect-trello-with-google-sheets/

Alberto Estévez_qn3e7e · Answer

Hi Omar. Not totally sure about the automation workflow with Crmble you mentioned. Currently, Crmble makes it possible to connect a Google Sheet with Crmble to create new Trello cards with Crmble Fields information when a new row is added to the Google Sheet via automation. I'm sure Integromat makes it possible to connect many third-party services to a Google Sheet. Once you do that, you can connect your Google Sheet to Crmble using our Google Forms Topping. Please read this blog post to learn more on how to connect different Form services with Crmble using our Topping. Hope this helps. Cheers!

https://crmble.com/blog/tips-and-tricks/automate-your-sales-workflow-connecting-your-wordpress-form-with-crmble/