WEBVTT

00:01.400 --> 00:06.960
In this lesson, we are going to create a feedback collection form for your friends.

00:07.000 --> 00:14.400
Customers or clients can easily leave their feedback and all the responses will automatically appear

00:14.640 --> 00:17.880
in a Google Sheet organized and ready for you to review.

00:18.160 --> 00:19.400
So let's get started.

00:19.840 --> 00:21.800
First, open your dashboard.

00:22.240 --> 00:23.680
Click on Create Workflow.

00:27.480 --> 00:29.040
Now give your workflow a name.

00:32.000 --> 00:35.600
Let's say feedback collection form.

00:40.280 --> 00:41.040
Press enter.

00:44.360 --> 00:49.280
Now we need to start our workflow with some type of trigger.

00:50.240 --> 00:55.200
So in this particular scenario we are going to use on form submission trigger.

00:55.880 --> 01:03.770
So let's search for this node by clicking on this plus button and select on Form Submission trigger.

01:08.570 --> 01:16.250
Now any time you see that something is highlighted in red or there is an exclamation mark, that's mean,

01:16.610 --> 01:17.490
there is something wrong.

01:17.530 --> 01:19.210
There is some issue we have to fix.

01:19.890 --> 01:24.690
So in that case, we need to provide at least one field in our submission form.

01:26.010 --> 01:28.810
So first let's ask for a name.

01:31.090 --> 01:31.690
What's.

01:33.730 --> 01:34.690
Your first name.

01:41.530 --> 01:42.210
Now let's.

01:44.330 --> 01:46.410
Now let's add another field.

01:47.610 --> 01:48.970
So what's your email?

01:58.170 --> 01:59.820
Now let's ask about the feedback.

02:01.700 --> 02:04.940
So please give us.

02:07.380 --> 02:08.180
Your feedback.

02:12.220 --> 02:15.660
And let's change element type to the drop down list.

02:16.660 --> 02:17.900
And as the first option.

02:20.660 --> 02:22.940
Our customer is happy.

02:25.740 --> 02:27.780
The second option let's say good.

02:30.940 --> 02:31.740
Neutral.

02:35.660 --> 02:36.460
And but.

02:40.620 --> 02:43.180
Also you want our customer to leave a comment.

02:44.260 --> 02:46.380
So let's let's add the last field.

02:50.380 --> 02:51.460
Please leave a comment.

02:58.830 --> 03:00.390
All right, let's close it for now.

03:02.190 --> 03:04.270
As you can see, there is still something wrong.

03:04.430 --> 03:07.910
Which means our automation will not be executed successfully.

03:09.830 --> 03:11.590
Because there is an issue we have to fix.

03:13.710 --> 03:14.950
So let's open this node.

03:18.270 --> 03:21.830
And as you can see, we have to give this form a title.

03:23.950 --> 03:27.590
So let's call it feedback form.

03:30.990 --> 03:32.190
Now we have our trigger.

03:33.110 --> 03:37.870
So when we click Test workflow the submission form will pop up.

03:39.990 --> 03:41.470
So let's quickly fill it out.

03:44.070 --> 03:44.790
Damon.

04:03.760 --> 04:09.920
And now when I click submit, this data will be passed into our node.

04:14.400 --> 04:17.680
As you can see, the workflow was successfully executed.

04:22.400 --> 04:23.680
Now let's open this node.

04:26.920 --> 04:33.760
And on the right hand side and the output you can see all the information we just submitted.

04:40.040 --> 04:40.480
Alright.

04:40.480 --> 04:40.920
Awesome.

04:48.320 --> 04:51.240
Now before we connect our workflow.

04:53.560 --> 04:59.490
To pass all this data to Google Sheets, let's quickly create a simple spreadsheet to store all the

04:59.490 --> 05:00.610
feedback responses.

05:04.010 --> 05:05.890
So I'm just going to my Google Drive.

05:12.010 --> 05:13.610
And creating a Google Sheets.

05:18.010 --> 05:20.770
Now let's call it feedback collection.

05:35.250 --> 05:36.570
And we need four columns.

05:38.490 --> 05:40.250
The first one is name.

05:42.930 --> 05:44.810
The second one email.

05:47.770 --> 05:48.450
Feedback.

05:50.970 --> 05:52.770
The last one is comment.

05:57.140 --> 05:57.580
All right.

05:57.580 --> 05:58.060
Great.

05:58.300 --> 06:00.060
So now let's go back to our Na ten.

06:02.740 --> 06:04.420
Now we have our trigger node.

06:05.420 --> 06:07.860
So we need some type of action.

06:08.500 --> 06:11.580
So let's search for an action node.

06:11.580 --> 06:17.100
In that case you want to use Google Sheet to pass all this information into Google Sheet.

06:18.180 --> 06:20.740
So let's let's search for a Google Sheet node.

06:25.740 --> 06:29.780
Now here you can choose a specific action you want to perform.

06:30.740 --> 06:34.580
In that case we want to append row in a sheet.

06:37.260 --> 06:38.420
So let's select this one.

06:42.340 --> 06:51.500
Now if you are using a cloud version of an A-10 in order to connect your Norton account into your Google

06:51.500 --> 06:52.980
Sheet app.

06:54.870 --> 06:56.350
You can just simply sign in.

06:56.510 --> 07:00.710
So just simply sign in with Google and you don't need to do anything else.

07:00.710 --> 07:01.710
You are all set up.

07:02.590 --> 07:09.950
But if you are self-hosting, then you have to provide credentials by clicking on this drop down menu

07:11.230 --> 07:12.550
and creating credentials.

07:15.030 --> 07:20.030
And you will see that you will have to provide client service and client client key.

07:20.990 --> 07:29.550
So if you are self-hosting and then go to Setup Credentials section and you can find a separate tutorial

07:29.590 --> 07:38.870
on how to connect your Google account into N810 and how to find client service and client API.

07:41.590 --> 07:42.750
For now, let's close it.

07:48.190 --> 07:52.470
And let's sign in with Google because this is the cloud version of N810.

07:59.750 --> 08:07.750
Now, as a resource, we want to use a specific sheet within document and the operation we want to append

08:07.750 --> 08:08.110
row.

08:09.830 --> 08:20.030
But if you want to create a row or bilateral or retrieve information from a specific row or update row,

08:20.590 --> 08:24.430
you can switch over to a different operation.

08:28.150 --> 08:33.350
Now let's choose our document from list because this is the easiest option.

08:35.510 --> 08:38.310
So we name our Google Sheet feedback collection.

08:38.310 --> 08:39.310
So let's choose this one.

08:42.910 --> 08:44.270
And the sheet is sheet one.

08:52.120 --> 08:56.080
Now, as you can see, any ten loaded or our columns automatically.

08:57.600 --> 08:59.200
So now let's go back to our canvas.

09:02.200 --> 09:06.440
And let's connect on submission trigger note to our Google Sheets note.

09:09.200 --> 09:15.720
Now when we click Test Workflow, we need to fill out the form to add some data to our workflow.

09:19.120 --> 09:20.160
And hit submit.

09:23.800 --> 09:33.360
Now as you can see, there is a problem in Google Sheet because we need to drag and drop dynamic variables

09:35.120 --> 09:36.400
into those fields.

09:40.680 --> 09:48.120
Because every time a new customer fills out the form, they have different name, different email.

09:50.080 --> 09:53.610
They can give you different feedback and leave different comments, right?

09:54.250 --> 09:59.930
So we can simply drag and drop these dynamic variables into those fields.

10:01.050 --> 10:02.210
So what's your first name?

10:04.170 --> 10:05.130
What's your email.

10:08.530 --> 10:11.210
And also the feedback.

10:16.290 --> 10:25.290
Now when I click test step my response is from submission form should be added into a Google sheet.

10:25.890 --> 10:28.930
So let's check our Google Sheet for now.

10:29.170 --> 10:30.610
Every column is empty.

10:31.770 --> 10:33.210
But when I click the step.

10:41.530 --> 10:45.290
We pass all the information into our Google sheet.

10:45.330 --> 10:46.770
Let's check it again.

10:48.970 --> 10:52.900
As you can see, we have Damon email and feedback.

10:54.900 --> 10:59.740
And there is a small issue because one column is missing.

11:00.980 --> 11:04.860
And as you can see here, columns are outdated.

11:04.860 --> 11:07.500
So you have to refresh it to see the changes.

11:08.340 --> 11:09.820
So let's click refresh.

11:16.060 --> 11:19.340
And now the last column comment appeared.

11:23.420 --> 11:26.500
So we need to drag and drop this dynamic variable as well.

11:31.340 --> 11:32.740
And now when I click the step.

11:35.340 --> 11:37.020
We should receive a comment as well.

11:37.460 --> 11:40.060
So our last row will be updated.

11:40.620 --> 11:41.900
Let's check our Google sheet.

11:43.700 --> 11:47.180
And as you can see now all the columns have been populated.

11:49.310 --> 11:50.510
Let's go back to Nathan.

11:54.310 --> 11:55.470
And let's close it for now.

11:58.270 --> 12:06.910
Now, in order to make this workflow for real world use, we can change the workflow status from inactive

12:07.150 --> 12:08.070
to active.

12:10.870 --> 12:17.790
So you don't need to click on Test Workflow to activate this automation.

12:19.870 --> 12:25.110
And every time when someone submits the form, it will trigger automatically.

12:27.030 --> 12:27.990
So let's do it now.

12:31.230 --> 12:31.950
Confirm.

12:33.790 --> 12:35.510
Now let's open on submission form.

12:38.030 --> 12:43.710
And now we need to use the production URL because this is a production ready automation.

12:44.670 --> 12:47.430
As we change the status to active.

12:47.430 --> 12:47.480
Proactive.

12:51.280 --> 12:52.960
We can use the production URL.

12:56.080 --> 12:58.280
And send it to our friends or customers.

12:58.680 --> 13:05.120
And we can add this form into our website just to demonstrate it to you.

13:07.440 --> 13:11.200
I'm going to open this form in a separate window.

13:17.760 --> 13:20.760
And now when I fill out the form let's do it.

13:34.080 --> 13:35.240
And submit the form.

13:39.680 --> 13:42.720
We receive responses in our Google Sheet.

13:45.040 --> 13:52.770
As you can see, We collected a new feedback from a new user without testing our workflow, because

13:53.490 --> 14:02.570
we changed the status of the workflow to active and use production URL to open the submission form.

14:06.850 --> 14:13.730
We are using confirm submission just for the sake of this tutorial, but you can use different form

14:13.730 --> 14:20.690
builders to make a beautiful forms and and added them to your website or funnels.

14:20.890 --> 14:32.370
For example, you can use you can search for form and you can use type, form, short form, tidy and

14:32.370 --> 14:37.570
any other form builder that provides access to the API.

14:38.130 --> 14:39.130
Congratulations!

14:39.130 --> 14:44.650
You have built your fully functional feedback form automation in just a few clicks, so well done.

14:44.690 --> 14:46.210
Now let's move to the next lesson.