Using a webform to add a card

Question

Hi, we're in the process of migrating from Smartsheet to Trello. Smartsheet allows the creation of Forms, which has been a really useful function - not to mention it's free!

For example, I setup a simple form for our customer support team to create a support ticket, which is then posted into the relevant Smartsheet as a new task. This also triggers a 'new task' alert to the Team Leader.

Does anyone know of a method of doing this in Trello?.

Thanks - Steve

Iain Dooley · Accepted Answer

@Steve O'Hara One thing you'll notice about Trello is that it's very light on features, but strong on integration. It's got one of the easiest to use and most comprehensive API implementations of any product in any category.

The best way to do form submissions into Trello, is using a Google Form.

You can use something like Zapier to take the form submission and put it into Trello, but you can also just use the Google Apps Script API to do this.

There's a number of examples of connecting to the Trello API via Google Apps Script scattered around the web, but you might be interested in this free/open source library I wrote called Trellinator that allows you to quickly and easily create Trello automations in Google Apps Script:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

The method for handling your specific scenario would be to create a Google Form, put the entries into a Spreadsheet, then create an onFormSubmit trigger which calls your function to populate Trello (you could then add members to a card which would notify them or do something like use MailApp inside your Google Script to send them an email if you'd rather).