Integration Kommo and Google Sheets (Google tables)

Connection in 5 minutes, 30 days on tests, try.

Accepted webhooks
Done actions
New clients

Try 30 days free

Free Turnkey setting, Instructions.

What data can be transmitted from: from_Service to: to_Service

Important: Please note that the presence of events and actions between the two services does not guarantee a solution your task - the available events and actions may not connect with each other in the way you need.

If you cannot independently determine whether these events and actions will be able to solve your problem; contact support or use the Full construction setting.

Events c Kommo

Click on the name of the event to see the available fields.

API documentation — No.

Description

Not

Available fields
Id Name
id Transaction ID
name Name of the transaction
status_id Status ID
pipeline_id Funnel ID
price The budget of the transaction
tags Tags
responsible_user_id ID of the user responsible for the transaction
account_id The ID of the account where the transaction is located
created_at Date of creation of the transaction
updated_at Date of transaction change
+ You can add your fields that are in webhuk.

If you haven't found the right event, but the service has the right webhook, then use the universal connector "Including webhuk". It will be possible to tie the logic of bundles to any field that comes in the webhook.

Actions in Google Sheets

Click on the name of the action to see the available fields.

API documentation — here.

Request fields
Id Name
sheet Sheet
a Column A
b Column B
c Column C
d Column D
e Column E
f Column F
g Column G
h Column H
i Column I
j Column J
k Column K
l Column L
m Column M
n Column N
o Column O
p Column P
q Column Q
r Column R
s Column S
t Column T
u Column U
v Column V
w Column W
x Column X
y Column Y
z Column Z
Answer fields
Id Name
result Result

Request fields
Id Name
sheet Sheet
column Column
value Meaning
Answer fields
Id Name
row_id Line number
row_data The contents of the line
column_value_a The value of column A
column_value_b The value of column B
column_value_c The value of column C
column_value_d The value of column D
column_value_e The value of column E
column_value_f The value of column F
column_value_g The value of column G
column_value_h The value of column H

Request fields
Id Name
sheet Sheet
row_id Line number
a Column A
b Column B
c Column C
d Column D
e Column E
f Column F
g Column G
h Column H
i Column I
j Column J
k Column K
l Column L
m Column M