Automating feedback using ChatGPT and Zapier

Key Takeaways

here's the backstory I teach a machine learning class and I get a ton of feedback from my students and the feedback is great but I just don't have time to go through all of it so I've been thinking about hiring someone who can just go and process the feedback for me but then a couple weeks ago coincidentally sappier reached out to me to show me what they're doing with AI in their platform and then I had an idea what if instead of paying someone else to process the feedback what if I build an automation using sappier that processes the feedback automatically for me using artificial intelligence that is what I'm about to do right here and I'll show you how to do the same thing by the way this video is sponsored by sappier and I'm going to be recording a bunch of these workflows and a bunch of these Integrations on their channel so go and subscribe to their channel so you can see more about this in order to build my feedback automation I'm going to start by creating an interface this is my sappier account I'm going to click on form and I'm going to create a simple form to do this now I like to ask people for two questions what do you like about the program and what can I do to improve it so let's edit this form and add those two new Fields I'm going to add a new field here I'm going to make it long text and I'm going to say what do you like about the program when I insert this feel that's awesome and then I'm going to add a new one that says it's also long text what can I do to improve it okay let's keep it simple one thing that I don't feel comfortable doing is asking for email so I'm going to change the position of that the email field I'm going to put it uh last and then I'm going to edit it so I don't make it required so whoever wants to give an email that's awesome if not they don't have to okay cool now I have a form now I can just go and click on this link and this link is going to open the form and I can just try it out I have some feedback real feedback that I receive and I'm going to use that content just to submit it here just for testing purposes what do you like about the program well here is some content what can I do to improve it well extending the course one two more lessons will be nice okay that's awesome let me provide an email here that's my email and I just submitted the form okay so this is working that's the form let's now build the Integrations here so I'm going to close this and I'm going to edit the form and I'm going to go to actions and I'm going to add an action for this form so this action is going to get triggered whenever a user submits the form and what I'm going to do is run a sap now the sap is basically the workflow that we are going to build right now so I'm going to click on create sap and that will open the editor with the form submission right here which is the first thing that's going to happen in my in this workflow when I zoom this in you see this exclamation mark that just indicates that I have not tested this specific component so I'm going to click test the trigger this is going to use the information that I submitted before and it's just going to send that information here you can get the answers that's awesome next step is just to do something with AI so I'm going to click on that plus button and then I'm going to go to apps and click on AI and I'm going to pick cha gbt what I want to uh to do with cha gbt is basically process the feedback and turn that feedback into actionable items a lot of people the feedback that they send me is just is huge there's a lot of content there I just need a bullet list okay so that's what Char gbt is going to help me do so the event here A bunch of uh things that I can do with chat GPT that are pre-created for me I'm going to focus on conversation where I can just provide a prompt and be done with it uh obviously here you're going to have to connect your chpt account to sappier so you can communicate with it I'm going to click continue and here in action is where I'm going to be typing the user message okay so this is the prompt that I'm going to be using write a number list of action questionable tasks based on the feedback received from a user very very simple notice that I added here triple quotes and within the triple quotes I'm going to specify the content that the User submitted through my form now here you get this popup that says insert data and if I scroll down you're going to find the form data which is automatically created by sapure based on the fields that I added form so you see the email you see the first question and you see the second question so I'm going to add the first question I'm going to hit enter here just to give some space and then I'm going to add the answer to the second question so now I'm condensing the user feedback into you know inside the triple quote so chib recognizes that all of that is part of the feedback okay so that is uh good the model that I'm going to be using is going to be GPT 40 mini that is a good enough model for for me you can use any of the models that CH GPT provides I'm not going to make any othero changes here I'm just going to click continue and now I can just test that this integration is working I'm going to click on test step this is going to send now the information the form submission that I created is going to send it to chat GPT and then it's going to show me what CH GPT is going to reply so this is the request and the response says consider adding one to two additional lessons to the course that's it it's just one thing that's coming out of the feedback so this is awesome I can either publish my sap or I can keep adding stuff I'm going to keep adding stuff because I need to send those action items somewhere so what I created before is I have this Excel uh cheet this spreadsheet a Google spreadsheet with what's good what spot and action items and I have an example here in this spreadsheet I want anytime somebody builds out the form and submits it I want my my sap to add that information right here so let's build that is going to be very very simple so I'm going to go to this plus button I'm going to click add step I'm going to find Google Sheets it's right there you can connect to anything here that's the good thing about Sapp here which by the way have been around for a long long time so you can connect to anything applications here so what will be the event well I want to create a spreadsheet row I want to add a new row to my spreadsheet I'm going to click continue I'm going to connect to my Google sheet account I already did that click continue the action okay so I have to select my Google Drive and then I have to select my spreadsheet which is going to be the course feedback here and now I have to select the worksheet I have only one worksheet within that spreadsheet so that's speedback and now this is automatically populating every column on that worksheet that's awesome what do we want to enter under what's good well I can just go to form submission I can look for the first field of feedback and I can enter that bit back there and I can go to what's bad do the same thing for the second question that I'm asking and finally for the action items I can select conversation so I can get the response from CH GPT and add it here I'm going to look for that response here there we go reply there we go I'm going to add that right here that's the connection so I'm going to click continue and now I can just give it a try when I click on test step now this is just connecting to my spreadsheet look at this this is just beautiful now all of the sudden I have the data that I enter right here that's pretty cool but I'm not done yet I'm going to do something else because some of the users might give me an email address and if they do I want to be nice and I want to reply to them saying thank you for sending me feedback this is how your feedback is going to help me something like that right how do I do that well not everyone is giving me an email so I'm going to click add step and I'm going to use the path by sapier which is a built-in tool and what this is going to allow me to do is just to create a condition here now I only need one condition so I'm going to get rid of path B I don't need a path B here just going to click here delete really delete yes please get rid of it and now I can write a condition so I'm going to click there and it says only continue if okay that's good let me just go and select the email from the form if that email exists that's it if it doesn't exist then just don't go down this path so I'm going to click continue and then is go going to tell me whether or not my path would have continued for the test data that I have because I provided an email it says that yes this path would have continued that's awesome I'm going to click continue and now it's asking me for the action that this path is going to lead me to and for that I just want to send an email to that person so I'm going to click Gmail here what will be the event let's just send an email I'm going to click continue I'm going to connect my Gmail account which I already did click continue and here is where I'm going to peel out the pills to send that email to who am I sending an email well obviously to the email provided by the user which I know if I'm here I know the user provided it already because I'm under specific condition from who I'm just going to pick my email address here from the list what will be the subject I'm going to say thanks for the feedback and now I need to to just enter the body here okay so here is just a quick quick email here I'm saying hi there this is an AI response I'd like to disclose that this is not me uh replying to the email directly but I wanted to let you know that I received your feedback and here are the action items that chbt generated from what you told me now obviously here I need to just show the generation whatever chpt decided to create as action items so I'm just going to go to the the popup of insert data going to go to conversations find the reply and I'm going to add right here and then I'm going to finish the email saying let me know if I'm missing something thanks Santiago's AI B okay so that's cool I think what am I missing here am I missing anything I don't think so I think this is done already let me just see I'm not going to enter any attachments no signature I'm going to click continue and now I can give this a test so I'm going to just test this step and this should send an email to myself from myself so I'm going to go to my Gmail account I see okay there is a sent message and as you can see this is the email that I just sent myself okay so now I'm ready to go this is it it took me how long five minutes this is it and I'm honestly don't have to pay anyone to just do this so the final step is to publish this thing I need to publish this app so I can actually share the link to my form and people start entering my feedback so I just click on published uh awesome my sap is live I'm gonna go home this is taking me home uh let me go home let me go to the interfaces and let me just find the link to the interface that I just created here is the link I'm going to click on that link and this is the link that I have to share with people so let's give it one more try let's enter some feedback and let's see if everything is working as it's supposed to be working again I'm just typing here feedback that I already got from other users what can I do to improve it that is a long paragraph that's really really hard to process manually so I'm just going to submit it here also going to add my email and then I'm going to click submit and I'm then I'm going to wait just a few seconds to give time to that sa to do all of the processing and here it is I have what's good what's bad and then I have three action items coming from the feedback of the user and all of that took me 5 minutes to build and it's just running so anyway if you really really like this make sure you go to the sap your channel And subscribe today and they're sponsoring this video I'm going to be building some of these Integrations on their Channel and I hope you I hope to see you in the next one bye-bye