How to Create a Zap Between Calendly and Google Sheets
Maria Meschi
112 steps
6 minutes
Zapier
Google Account
Calendly
1
Navigate to [https://zapier.com/](https://zapier.com/)
2
Click "Log in"
3
Click "Continue with Google"
4
Click "[doris@dorisresearch.com](mailto:doris@dorisresearch.com)"
5
Click here.
6
Click the "Search…" field.
7
Type "cal"
8
Click "Calendly"
9
Click the "*EventRequired" field.
10
Click "Triggers when an invitee schedules an event."
11
Click "Continue"
12
Click "Choose"
13
Click "(used in 5 Zaps)"
14
Click "Continue"
15
Click "Test trigger"
16
Click "Invitee A"
17
Click "Load more"
18
Click "Continue"
19
Click here.
20
Click here.
21
Type "slug"
22
Click "virtual-ideation-prototyping-session-city-of-boulder-2023"
23
Click "Choose condition…"
24
Click "(Text) Contains"
25
Switch to tab "My Calendly - Edit One-on-One Event Type - Calendly"
26
Double-click the "Event link *" field.
27
Press [[cmd]] + [[c]]
28
Click here.
29
Press [[cmd]] + [[v]]
30
Click "Continue"
31
Click "Continue"
32
Click the "Search…" field.
33
Type "shee"
34
Click here.
35
Click the "*EventRequired" field.
36
Click "Finds a row by a column and value. Returns the entire row if one is found. Optionally, create a spreadsheet row if none are found."
37
Click "Continue"
38
Click "Choose"
39
Click "(used in 9 Zaps)"
40
Click here.
41
Click "Continue"
42
Click "Choose value…"
43
Click the "Search…" field.
44
Type "butler"
45
Click "1brTfDRhMbIVJQUqOQrb8PK2ok6YDRSLw7ig-s46FNUg"
46
Click "Choose value…"
47
Click "1248098511"
48
Click "Choose value…"
49
Click here.
50
Click here.
51
Click this icon.
52
Click Invitee Email
53
Click the "Create Google Sheets Spreadsheet Row if it doesn’t exist yet?" field.
54
Click here.
55
Click here.
56
Click here.
57
Click here.
58
Click here.
59
Click here.
60
Click "Invitee Last Name"
61
Click here.
62
Click here.
63
Click here.
64
Click here.
65
Click here.
66
Type " [[Backspace]]"
67
Click "1. Invitee Created in Calendly"
68
Click "Shelly Conley"
69
Click here.
70
Click here.
71
Click here.
72
Click here.
73
Click here.
74
Click here.
75
Click here.
76
Click here.
77
Click here.
78
Click here.
79
Click "2023-06-13T13:00:00-04:00"
80
Click here.
81
Click "Remove these extra fields"
82
Click "Continue"
83
Click "Test action"
84
Click this icon.
85
Click the "Search…" field.
86
Type "shee"
87
Click "Google Sheets"
88
Click the "*EventRequired" field.
89
Click here.
90
Click "Continue"
91
Click here.
92
Click "Continue"
93
Click "Choose value…"
94
Click "1brTfDRhMbIVJQUqOQrb8PK2ok6YDRSLw7ig-s46FNUg"
95
Click "Choose value…"
96
Click "1248098511"
97
Click "Choose value…"
98
Click "Custom"
99
Click here.
100
Click here.
101
Click here.
102
Click here.
103
Click here.
104
Click here.
105
Click here.
106
Click here.
107
Click here.
108
Click here.
109
Click "Continue"
110
Click "Skip test"
111
Click "Skip test"
112
Click "Publish"
How to Create a Zap Between Calendly and Google Sheets
Maria Meschi
112 steps
6 minutes
Zapier
Google Account
Calendly
1
Navigate to [https://zapier.com/](https://zapier.com/)
2
Click "Log in"
3
Click "Continue with Google"
4
Click "[doris@dorisresearch.com](mailto:doris@dorisresearch.com)"
5
Click here.
6
Click the "Search…" field.
7
Type "cal"
8
Click "Calendly"
9
Click the "*EventRequired" field.
10
Click "Triggers when an invitee schedules an event."
11
Click "Continue"
12
Click "Choose"
13
Click "(used in 5 Zaps)"
14
Click "Continue"
15
Click "Test trigger"
16
Click "Invitee A"
17
Click "Load more"
18
Click "Continue"
19
Click here.
20
Click here.
21
Type "slug"
22
Click "virtual-ideation-prototyping-session-city-of-boulder-2023"
23
Click "Choose condition…"
24
Click "(Text) Contains"
25
Switch to tab "My Calendly - Edit One-on-One Event Type - Calendly"
26
Double-click the "Event link *" field.
27
Press [[cmd]] + [[c]]
28
Click here.
29
Press [[cmd]] + [[v]]
30
Click "Continue"
31
Click "Continue"
32
Click the "Search…" field.
33
Type "shee"
34
Click here.
35
Click the "*EventRequired" field.
36
Click "Finds a row by a column and value. Returns the entire row if one is found. Optionally, create a spreadsheet row if none are found."
37
Click "Continue"
38
Click "Choose"
39
Click "(used in 9 Zaps)"
40
Click here.
41
Click "Continue"
42
Click "Choose value…"
43
Click the "Search…" field.
44
Type "butler"
45
Click "1brTfDRhMbIVJQUqOQrb8PK2ok6YDRSLw7ig-s46FNUg"
46
Click "Choose value…"
47
Click "1248098511"
48
Click "Choose value…"
49
Click here.
50
Click here.
51
Click this icon.
52
Click Invitee Email
53
Click the "Create Google Sheets Spreadsheet Row if it doesn’t exist yet?" field.
54
Click here.
55
Click here.
56
Click here.
57
Click here.
58
Click here.
59
Click here.
60
Click "Invitee Last Name"
61
Click here.
62
Click here.
63
Click here.
64
Click here.
65
Click here.
66
Type " [[Backspace]]"
67
Click "1. Invitee Created in Calendly"
68
Click "Shelly Conley"
69
Click here.
70
Click here.
71
Click here.
72
Click here.
73
Click here.
74
Click here.
75
Click here.
76
Click here.
77
Click here.
78
Click here.
79
Click "2023-06-13T13:00:00-04:00"
80
Click here.
81
Click "Remove these extra fields"
82
Click "Continue"
83
Click "Test action"
84
Click this icon.
85
Click the "Search…" field.
86
Type "shee"
87
Click "Google Sheets"
88
Click the "*EventRequired" field.
89
Click here.
90
Click "Continue"
91
Click here.
92
Click "Continue"
93
Click "Choose value…"
94
Click "1brTfDRhMbIVJQUqOQrb8PK2ok6YDRSLw7ig-s46FNUg"
95
Click "Choose value…"
96
Click "1248098511"
97
Click "Choose value…"
98
Click "Custom"
99
Click here.
100
Click here.
101
Click here.
102
Click here.
103
Click here.
104
Click here.
105
Click here.
106
Click here.
107
Click here.
108
Click here.
109
Click "Continue"
110
Click "Skip test"
111
Click "Skip test"
112
Click "Publish"
