Add new rows in Google Sheets when a Assembly (formerly Copilot) form is submitted
Allene Norton
57 steps
3 minutes
Make
Google Docs
As of September 30, 2025, we’ve rebranded to Assembly. The steps below remain the same. When searching in Make, look for Assembly (formerly Copilot) and this logo.
1
Create a new scenario in Make
2
Click the + button to add a trigger. Search for and select "Copilot"
3
Click "Watch Completed Forms"
4
Click "Add" or "Create a webhook"
5
Name your webhook in Make
6
Open the dropdown
7
Select the form you want to use for this trigger
8
Click "Save"
9
Click "Copy address to clipboard"
10
Click "OK"
11
In a new tab go to the Copilot Dashboard
12
Click "Settings"
13
Click "API"
14
Click "New webhook"
15
Label the webhook and paste the webhook URL from Make into the Endpoint URL field
16
Click this icon.
17
Click "form_response.completed"
18
Click "Update"
19
Click "Confirm"
20
Now it's time to test the trigger by submitting the form as your test client. Right-click here.
21
Click "Run this module only"
22
In your Copilot Dashboard, assign the form used for this trigger to your test client
23
Click "Portal"
24
Click "Open portal"
25
Log in as your test client and click "Forms"
26
Fill out and submit the form as your test client
27
Back in Make, you should see that the trigger ran successfully
28
Add a new module and select “Copilot”
29
Click "Retrieve a Client"
30
Click here.
31
Click "Client ID"
32
Click "OK"
33
Add a new module and search for “Google Sheets”
34
Click "Add a Row"
35
Click "Click here to choose file"
36
Find the spreadsheet you want to update
37
Open the dropdown
38
Select the worksheet where you want to add rows
Tip!The following mapping steps will vary based on your form and Google Sheet. You can map the client data from the Retrieve a Client step, and the form responses from the Form Response Completed trigger.
39
Click here.
40
Click "Given Name"
41
Click here.
42
Click "Family Name"
43
Click here.
44
Click "Email"
45
Click here.
46
Click here.
47
Click here.
48
Click here.
49
Click "answer"
50
Click here.
51
Click here.
52
Click "answer"
53
Click here.
54
Click here.
55
Click here.
56
Click "\[1\]". This is an example of a single-select form field.
57
Click "OK"
Add new rows in Google Sheets when a Assembly (formerly Copilot) form is submitted
Allene Norton
57 steps
3 minutes
Make
Google Docs
As of September 30, 2025, we’ve rebranded to Assembly. The steps below remain the same. When searching in Make, look for Assembly (formerly Copilot) and this logo.
1
Create a new scenario in Make
2
Click the + button to add a trigger. Search for and select "Copilot"
3
Click "Watch Completed Forms"
4
Click "Add" or "Create a webhook"
5
Name your webhook in Make
6
Open the dropdown
7
Select the form you want to use for this trigger
8
Click "Save"
9
Click "Copy address to clipboard"
10
Click "OK"
11
In a new tab go to the Copilot Dashboard
12
Click "Settings"
13
Click "API"
14
Click "New webhook"
15
Label the webhook and paste the webhook URL from Make into the Endpoint URL field
16
Click this icon.
17
Click "form_response.completed"
18
Click "Update"
19
Click "Confirm"
20
Now it's time to test the trigger by submitting the form as your test client. Right-click here.
21
Click "Run this module only"
22
In your Copilot Dashboard, assign the form used for this trigger to your test client
23
Click "Portal"
24
Click "Open portal"
25
Log in as your test client and click "Forms"
26
Fill out and submit the form as your test client
27
Back in Make, you should see that the trigger ran successfully
28
Add a new module and select “Copilot”
29
Click "Retrieve a Client"
30
Click here.
31
Click "Client ID"
32
Click "OK"
33
Add a new module and search for “Google Sheets”
34
Click "Add a Row"
35
Click "Click here to choose file"
36
Find the spreadsheet you want to update
37
Open the dropdown
38
Select the worksheet where you want to add rows
Tip!The following mapping steps will vary based on your form and Google Sheet. You can map the client data from the Retrieve a Client step, and the form responses from the Form Response Completed trigger.
39
Click here.
40
Click "Given Name"
41
Click here.
42
Click "Family Name"
43
Click here.
44
Click "Email"
45
Click here.
46
Click here.
47
Click here.
48
Click here.
49
Click "answer"
50
Click here.
51
Click here.
52
Click "answer"
53
Click here.
54
Click here.
55
Click here.
56
Click "\[1\]". This is an example of a single-select form field.
57
Click "OK"
