Automate Product Feedback with Typeform, Airtable, and Trello 📈

today we're going to use typeform airtable and trello to create an automated product feedback system we're going to assume that you've done a few things here that you've got nan up and running and that you're using the tunnel option this is so that you can get access to naden from behind a firewall we're going to assume that you've got your typeform account created and that the form has already been built and you have your airtable account graded and the table is already built and you've already got your trello account working and those credentials are all set up so for this workflow we are going to be using six nodes the type form trigger the set the air table the if the trello and the no up nodes by the time we're done our workflow should look something like this

so let's start off with the type form trigger the typeform trigger allows us to receive information from any form that we use in type form so all we need to do is grab our credentials which we've already set up ahead of time we know we're going to use the access token and then feedback form let's close this and quickly save our flow as feedback the reason that we save the workflow is that we can't test any triggers unless they are already working in a saved workflow so we're going to get rid of

our start node because we don't really need it and we're just going to keep our type form trigger here one last save and let's see if this works so we're going to execute the node which will run it 120 seconds and we'll start adding in some information so we'll go john go and his email address is john doe com didn't really like it and only gonna give it a three star and submit let's go back to our feedback you can see that all that information is already available to us in naden it's perfect

on to the next one so the next is our i'm just going to add that set node in here so the set node is actually going to be used to configure the proper values so we want to go into both our trello and our airtable table so we're going to be creating the name the email the description and the score and we're just going to be doing like this so first we'll start off with the name and this is going to be an expression so we're going to add the expression in and we're going to pull it from the typeform trigger so the name is john doe right there so as you can see it says using the typeform trigger node in the json look for what is your name and here's the results that it'll put out we're going to pause for a moment here and talk a little bit about expressions are used to represent information that is constantly changing as we go about working within the workflow and different information comes through the value of the expression will change depending upon the information that it is given this is why expressions are so powerful they allow us to constantly be working with different information and getting different results and that's it so let's do that for the other ones next one's gonna be email and we're gonna do the same thing add the expression work our way through the nodes and there's this email address right there i'm going to add another one and this is going to be called the description again we'll add the expression to good and then the last one it's going to be a little bit different it's a number because this is going to be the score so one thing you'll note that's a little bit different than the other ones because this is a number it already has a zero in it so we have to delete the zero then we go in and pull up the score there it is exactly what we wanted now we're also going to do one other thing we're going to set the keep only set trigger or sorry toggle the reason that we're going to keep this is because it will prevent any data that's coming through from other nodes to get past this node so that way we're only getting the good clean data that we're looking for all right let's give this a try and perfect score name email and description as we want it wonderful

so on to the air table node so the error table node is going to allow us to put the information that we receive into an error table we are going to do an append operation because you want the information to add to the table as it is entered now we need to figure out what the base id is so what we do is we're going to go to this web page here and we need to find our feedback table there it is so this is our base id and we need to make sure that we feed this into here then we need to put in the name of our table which we've called feedback and that should be everything we need so let's execute this node and see if this works properly we see that we've got all the fields going in that we want plus some additional information the id of the uh event that occurred and the date and time that it occurred so let's go take a look at our feedback table and see if it's there oh there it all is excellent exactly like we wanted

so we can close our air table node now we're going to come up to our if node so the if node basically does some logic for us and we'll do different things based on the input that it's receiving so we want to take a look and uh make sure that we are looking at a number so we've got basically what this is showing us here is that it's going to compare value 1 to value 2 and trigger true when the value one is less than value two so what we're going to do is we're gonna in the very first one we're gonna add the expression and we're gonna pull this from our set node and we're going to look at our score and again see we've got a zero here so we've got to delete that and it just goes to show that you can delete it before or after it doesn't matter it'll work the exact same way and so we've got the value 3 in there it automatically figures that out so this will change every time we get a different entry put into the system and we want to make sure that it is smaller than seven so you can do this two ways you can either just type it in like i just did or use these minus plus buttons to give you the information you want so let's see how this deals with the information we just received so it's saying that the number three was smaller than number seven and it would output it to true and this is the information you would output to the system wonderful so now what are we going to do with it well if it's true since basically we've got a low score we want to add it into trello so that it will assign it to somebody to do something so let's take a look at reload and here's our fellow credentials and we're going to create a card so these are all exactly what we want and now we've got to go to the list id so the list id is a little interesting to dig up so just follow me here so we're going to go into our channel board i've already got the where i want it to go those low ratings and i've got a list id here so this has some oops let's open up this card and we have to add json to the end of the url that's this girl up here press enter and we're going to look for the field called id list so we're just going to change this to dot json wonderful and we're looking for id list there it is and we're just going to copy that great go back here so now what are we going to call this card so what we're going to do here is we're just going to cheat a little bit we're going to grab this expression from our documentation so what this tells us is we're going to use the if node and we're going to find the field of score and the if node we're going to find the field name and we're going to put some brackets around them and this is the output we get so you can paste information straight into the expression field rather than manually creating it going through the nodes you can still go through the nodes they're all there still but this way is a bit a quicker way to do it and get the results that you want great so we've got the name description we're going to do something very similar so we're just going to copy this we're going to add an expression and we're going to paste it in as well and there's all of our information the way we want it to show up great now let's try this up there's a whole bunch of information that it puts into here this is good this is telling us that everything works properly so if we go back into our get list and there it is there's john doe created as we expected so we're almost done we're just going to move our trello note up here and we have one more node to add and that's the no op node so does nothing

absolutely nothing but it is very useful if you are developing some of the workflows because what it will do is it can tell you in this instance for example that if this were the trigger false it would actually go green you could also use it for putting in notes or comments so it's actually pretty useful even though it actually doesn't do anything all right so our final workflow looks just like this it's great so let's save this and we're just going to clear it out a little bit now we want to test out our workflow to make sure it's all working properly but before we do that we need to activate this workflow so we'll just activate here click yes activate and save and we should be good to go so let's go and test out our workflow and see how it works so let's start out with our with jane doe and jane doe dot com for email this is awesome she really liked it just give it a nine and submit so as you can see we've got uh our jane doe showed up in our feedback and uh and that uh she did not create a new treble card because jane liked it and it was above a seven right so she went through the trigger form and the set air table added it in went to the if did not hit below a seven and went to the new lock all right let's try this again but let's do this with a somebody that did not like it dildo so jill doe. com horrible and jill's going to give it a 2. all right now you notice this time that jill did show up in feedback as well within the database table but jill also showed up with the a brand new trello card so we know that there needs to be some work done there as well hope you had a great day and i hope that you find that this was useful