Student Support AI Agent

Sumit Gupta

Sumit Gupta

Aug 1, 2025 8:27 AM

Summary

Transcript

Today, we will talk about my next project with this student support AI program. What is the purpose of this region? I have made a decision with any type AI program, my SQL workbench and the Postman for request sending. So when I open this first mobile, which is the dev of OneMom, and I have copied this URL and paste it in the Postman and and set the request method as this. So when I trigger this start this workflow let us start.
And then click on send button. Just in the effort, note get note get triggered. See. And it is returning his phone, invalid post name. Please provide valid post. Why it is returning invalid post? Because I have provided empty post name. So how this is returning from anything but this is see, in this ignore, I have added condition whether post name is empty or not. If it is not empty, it will note to my SQL note.
If it is empty, that it will return its response from this note, which is invalid post name. Please provide a valid post name. Okay. Then I will okay. Let us still collect the post name. I have made a I have filled out correct post name, and let's see. Let us see what is the output. Okay? I'll click on send. See, it is it is giving the answer of the the question which is asked by the push student. What is the question asked by a student?
Will I get a certificate after completing this course? See, yes. You will get a certificate after completing the course. The course will take the certificate. So how this is happening from my workflow? See, when I can in provided input, this mode is triggered if condition true because post name is not empty. That is why this condition is true, and it will move to my SQL node. After that my SQL node, I have added one more condition.
What this condition is doing, it will check-in the input provided by the webhook node is equal to the my SQL database present in Percwench. If it is equal, then it will move to next node, HTTP request node. If it is false, then we will talk in about later on this because so if it is true, then it will return goes to the HTTP request node. And HTTP request mode, I have a you do Gemini AI to take the response from the database.
And I I have added this JSON content, which is where I have provided the useful field like post name, post timing, all the answers which which I want to get and all the questions I'll I've also provided. And after this test, will request more, it will move to set the field, edit field mode, which is still returning the response in clean way. Basically, it is removing these type of character star star n as well.
And after that, it will return the response from the respond web of node from here. Yes. You will get a certificate after completing this course. The course will get explicitly split certificate. Yes. Okay. After that, if I provide invalid post name or no wrong post name, and I will make a request, see what is happening. Post not found. The response will be returned from here. Why it is returning from here?
Because in this if node, I have edit invalid post name, which is not present in my database, and it will compare to the input field, which is not equal to. That is why this if condition is false and returning go to this level. Response node and returning response force not found. With one node error trigger, which will automatically gets triggered if any error occur. And after that, this will move to edit field, which is actually returning the response.
Sorry. We are unable to process your request at the moment. Please try it later if any error occur in the workflow, it will return this one from here. Okay. And now I will do the database as well. Work. Yes. It is opening. And now I will this is yes. This is the database. And I've created student support database. If not, I'll just and use student support. I will show you. Actually, one is the table. And this is why I created a table for system.
I have added some fields and added some data as well. See. I've added ID, post name, timing, labor, and certificate support. Of course, of that. And you can edit this database as per your need, and this is the influence support basic issue and support. Yeah. It isn't. Okay. So it's done.

Share This Audio Transcript & Summary 📚

Student Support AI Agent

00:00
06:02
Student Support AI Agent by Sumit Gupta | Glasp