Google Sheets + Kommo

Update Google Sheets worksheets with updated contacts from Kommo

When a contact's details are refreshed in Kommo, this workflow jumps into action to mirror those updates in your Google Sheets. By keeping a consistent record of your contact information, this workflow saves you the trouble of manual data entry. Experience the convenience of an aligned and error-free database across your apps with this automation.

When this happens...
Contact Updated
Triggers when contact is updated.
TriggerInstant
automatically do this!
Copy Worksheet
Creates a new worksheet by copying an existing worksheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

New Company
Triggers when a new company is created.
Trigger
Instant
Try It
New Lead
Triggers when a new lead is created.
Trigger
Instant
Try It
Task Deleted
Triggers when a task is deleted.
Trigger
Instant
Try It
Lead Status Changed
Triggers when lead status is changed.
Trigger
Instant
Try It
Contact Updated
Triggers when contact is updated.
Trigger
Instant
Try It

Task Updated
Triggers when task is updated.
Trigger
Instant
Try It
Update Company
Updates a company.
Action
Write

Update Contact
Updates a contact.
Action
Write
Create Lead With Contact
Creates a new lead with contact.
Action
Write
- Which Data Do You Want to Link?
- The Data ID You Want to Link
- What Do You Want to Link It To?
- The Data ID You Want to Link To
Action
Write
Update Note
Updates a note.
Action
Write
- Text of Task
Action
Write
- Query
- Element ID
Action
Search
- ID of Entity ItemRequired
Action
Search
- Deadline
- Element ID
- Element Type
Action
Search
- Query
- Element ID
Action
Search or write
- Element TypeRequired
- Element ID
- Text
- Creation Data
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

New Contact
Triggers when a new contact is created.
Trigger
Instant
Try It
New Task
Triggers when a new task is created.
Trigger
Instant
Try It
Lead Responsible User Changed
Triggers when lead responsible user is changed.
Trigger
Instant
Try It
Company Updated
Triggers when company is updated.
Trigger
Instant
Try It
Lead Updated
Triggers when lead is updated.
Trigger
Instant
Try It
Create Company
Creates a new company.
Action
Write
Create Contact
Creates a new contact.
Action
Write
Create Lead
Creates a new lead.
Action
Write
Update Lead
Updates a lead.
Action
Write
- Text
- Creation Data
Action
Write
- Text of Task
- Deadline
Action
Write
- Query
- Element ID
Action
Search
- Query
- Element ID
Action
Search
- Element TypeRequired
- Element ID
Action
Search
- Query
- Element ID
Action
Search or write
- Query
- Element ID
Action
Search or write
- Deadline
- Element ID
- Element Type
- Text of Task
- Deadline
Action
Search or write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About Kommo

Kommo is a messaging-powered CRM that helps you engage with your customers on a whole new level. It's a versatile, cloud-based sales automation tool that enables you to manage leads and monitor your sales pipeline in only a few clicks.

Learn more

Related categories

CRM (Customer Relationship Management)

Google Sheets + Kommo

Update Google Sheets worksheets with updated contacts from Kommo

New Company

New Lead

Task Deleted

Lead Status Changed

Contact Updated

Task Updated

Update Company

Update Contact

Create Lead With Contact

Create Link

Update Note

Update Task

Find Contact

Find Linked Data

Find Task

Find or Create Contact

Find or Create Note

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

New Contact

New Task

Lead Responsible User Changed

Company Updated

Lead Updated

Create Company

Create Contact

Create Lead

Update Lead

Create Note

Create Task

Find Company

Find Lead

Find Note

Find or Create Company

Find or Create Lead

Find or Create Task

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Kommo

Related categories

Similar apps

Pipedrive

Nimble

ClinchPad

Related Zap Templates

Related Zap Templates