Google BigQuery + Kommo

Add new Kommo leads to Google BigQuery as rows for seamless data management

Effortlessly manage your leads with this seamless integration between Kommo and Google BigQuery. Whenever a new lead is added in Kommo, a row will be created in your Google BigQuery table, ensuring that your lead data stays organized and up-to-date. By streamlining this process, you can focus on nurturing and converting leads rather than manually transferring information between platforms.

When this happens...
New Lead
Triggers when a new lead is created.
TriggerInstant
automatically do this!
Create Row
Creates a new row of data in a table. Note: Does not create a job.
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

What does this mean?

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
- ProjectRequired
- Dataset
- Table
Trigger
Scheduled
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
- LimitRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
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
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Scheduled
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- ValueRequired
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn more Help

Related categories

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 Help

Related categories

CRM (Customer Relationship Management)

Similar apps

Pipedrive

CRM (Customer Relationship Management)

Nimble

CRM (Customer Relationship Management)

ClinchPad

CRM (Customer Relationship Management)

PRODUCTS

CAPABILITIES

By team

Google BigQuery + Kommo

Add new Kommo leads to Google BigQuery as rows for seamless data management

New Company

New Lead

Task Deleted

Lead Status Changed

Contact Updated

Task Updated

Update Company

Update Contact

Create Lead With Contact

Create Link

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

Update Note

Update Task

Text of Task

Find Contact

Query

Element ID

Find Linked Data

Find Task

Deadline

Element ID

Element Type

Find or Create Contact

Query

Element ID

Find or Create Note

Element TypeRequired

Element ID

Text

Creation Data

Query Job Completed (With Row Data)

ProjectRequired

Dataset

Table

New Job Completed

Project IDRequired

Job IDRequired

LocationRequired

Create Row

ProjectRequired

DatasetRequired

TableRequired

Delete Rows

Project IDRequired

DatasetRequired

TableRequired

Where ColumnRequired

Where ValueRequired

Run a Query

Project IDRequired

SQL QueryRequired

Location

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Row(s)

Project IDRequired

DatasetRequired

TableRequired

Sort By Column

Sort Direction

Where ClauseRequired

LimitRequired

Find or Create Record

ProjectRequired

DatasetRequired

TableRequired