Google BigQuery + Kommo

Add new Kommo contacts to Google BigQuery as rows

Effortlessly keep track of new Kommo contacts by adding them to your Google BigQuery database with this seamless workflow. Once set up, every time a new contact is created in Kommo, a new row will be added to your specified Google BigQuery table. This simple automation helps you maintain an organized and updated database without any manual data entry.

When this happens...
New Contact
Triggers when a new contact 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

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
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

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
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
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
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

About Google BigQuery

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

Learn more

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