Aparna's video 🐄

Hello, my name is Apayanati and in this video I will demonstrate you regarding my Zapier project.

So I have two assignments regarding Zapier.

First is to determine whether the email that I have received is a feedback email and if it is a feedback email then check if it is a negative feedback or positive or neutral feedback.

So for that I have created a flow in which the first step is whenever a new email arrives.

So this flow will get triggered whenever a new email arrives.

Here I have signed in to my VishApp account.

The second is detect if email is customer feedback.

So here I have used this AI by Zapier and I have given the input fields like check if if we can determine whether it is a feedback email or not.

So to check that from subject and body and I have also given here a prompt to analyze if it contains the customer feedback, opinion, complaints, praise or reviews about products or services or experiences and classify based on that whether it is a feedback or not feedback email.

I have added here few more fields like from email or from name.

because I wanted to remove myself from this condition.

If the email is from Apana then don't check that email.

So for that I have added this and then in the output fields I have given the field name as classification and field type as text.

So this will give me whether it is a feedback or not feedback.

Then third step is filter conditions.

For that I have used filter by Zapier in this based on the classification that we have done in the previous step it checks if classification exactly match with feedback or not.

If it does then it will proceed further.

But if it does not then it will stop right here.

The then the fourth step is analyzed and return data.

Now as we have checked whether it is a feedback email or not in the above step now we will check whether the feedback is a negative or positive or neutral feedback.

Here also I have given the same input fields check in subject and body whether it is a positive or negative feedback and given here a prompt to analyze the sentiment of the feedback email and classify it as negative, neutral or positive.

Here in the output field I have given the field name as sentiment and added here the sentiment classification as negative, neutral or positive.

Then I have split the paths.

If the feedback is negative then it will follow this path.

So here I have added that only continue if the sentiment which I have created in the previous step whether it exactly matches with negative, if it does then it will send an email to the customer here into we can add the from name.

From name means the email from whom we have received that.

But for now I have added my name only because I wanted to show you how we will get the response and subject.

I have added to and added the subject which customer have added and we received your feedback and created an email.

Now second email will go to the support team here.

Also I have added my main subject urgent.

It is a negative customer feedback and the subject of subject which customer have added in his email.

The second path is positive or neutral feedback.

Here I have given the path conditions if sentiment is positive on neutral and send the email here I have added my email address, added a subject and a body.

Now let's test this flow.

I will share an email from another ID it So I have shared an email.

Hi team.

I had liked to share some feedback regarding my recent experience with your service.

Unfortunately it did not meet my expectations.

There was delays in response and the issue wasn't resolved as efficiently as expected.

I hope you can look into this and take necessary steps to improve further customers experiences.

So from this email we can see it appears to be a negative feedback.

So yeah here we get the automated generated email.

The feedback on recent service experience.

Dear Aparna, thank you for taking the time to share your feedback with us.

We have received your message and want you to know that we take all customer concern seriously.

Your feedback has been forwarded to our support team for immediate review and we will get back to you within 24 hours with detailed response and action plan.

We value your business and appreciate your patience as we work to address your concerns.

So this email will be shared with the customer.

And this is for the support team mentioning that urgent, urgent is required priority High negative feedback received from customer.

And here it is mentioned the message which we have received from customer.

So this is regarding the negative feedback.

Now check regarding the neutral or positive feedback.

Yeah here it is.

excellent service experience.

Hi team.

I wanted to share my appreciation for the great service I received recently.

Your team was prom professional and ensured everything went smoothly.

The overall experience exceeded my expectations.

Thank you for maintaining such high standards.

So this seems to be a positive feedback.

Yeah, we received an automated email from the flow that we have created.

So here it is.

So this is the first one.

When we received a negative feedback it followed this path and when we received the positive feedback it followed this path and sent us the email.

So that was regarding the first assignment.

Now the second assignment is when the Google Calendar meeting ends.

So after the 30 minutes we have to share an email with the person whom we had a meeting with.

So use the delay feature to send a follow up email to the client 30 minutes after the Google meeting concludes thanking them for their time.

So here I have created a flow.

First is when Google Calendar events end.

So here I have choose the Google Calendar I have connected my account then delay wise happier.

So here I have added time to delay by 30 minutes and then send an email.

So here we can add the attendees email or the guest name or the email to whom we have to share the email and with whom we had a meeting for now I have added my email address and have added here a subject thanking them for their time and the summary of that meeting.

Then hi and then adding the attendees name and thanking them adding the summary and duration of the meeting.

So let's check.

Yeah so let's check by creating one event which is a test event and the timings will be from 10 to 10:13pm and save.

So let's check if the flow has been triggered or not.

It.

Okay, so it is not triggering right now.

Yeah it got triggered.

So here we can see it is mentioning as a delayed.

So we have triggered it at 10:30.

Yeah so the meeting ends at 10:30.

So therefore the flow got triggered and it will share an email at 11pm so that's all.

Thank you.