Google BigQuery + Kommo

Google BigQuery + Kommo integrations

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 ContactTriggers when a new contact is created.
TriggerInstant
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Kommo and Google BigQuery

Discover other triggers and actions you can use with Kommo and Google BigQuery

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 Item
  Required
Action
Search
- Deadline
- Element ID
- Element Type
Action
Search
- Query
- Element ID
Action
Search or write
- Element Type
  Required
- Element ID
- Text
- Creation Data
Action
Search or write
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
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 Type
  Required
- 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 ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
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 moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

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 moreLearn moreHelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Pipedrive

CRM (Customer Relationship Management)

Nimble

CRM (Customer Relationship Management)

ClinchPad

CRM (Customer Relationship Management)

Related Zap Templates

Update rows in Google BigQuery when leads are updated in Kommo

Update Google BigQuery rows when companies are updated in Kommo

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