Google BigQuery + Microsoft Dynamics 365 CRM

Create new rows in Google BigQuery for Microsoft Dynamics 365 CRM leads

Effortlessly manage new leads with this automation workflow that connects Microsoft Dynamics 365 CRM and Google BigQuery. Whenever a new lead is added in Microsoft Dynamics 365 CRM, a new row will be created in Google BigQuery, keeping your data organized and up-to-date. Boost your productivity and ensure accurate lead information in your database with this seamless integration.

When this happens...
New Lead
Triggers when a new lead is created.
TriggerScheduled
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 Account
Triggers when a new account is created.
Trigger
Scheduled
Try It
Contact Updated
Triggers when a contact has been updated.
Trigger
Scheduled
Try It
New Case/Incident
Triggers when a new case/incident is created.
Trigger
Scheduled
Try It
New Lead
Triggers when a new lead is created.
Trigger
Scheduled
Try It
New Opportunity
Triggers when a new opportunity is created.
Trigger
Scheduled
Try It

Updated Quote
Triggers when a quote is updated.
Trigger
Scheduled
Try It
Create Campaign
Creates a new campaign.
Action
Write

Create Campaign Response
Creates a new campaign response.
Action
Write
- Info
Action
Write
Update Campaign Response
Updates an existing campaign response.
Action
Write
- Info
- Case/IncidentRequired
- State
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
Find Campaign Response
Finds a campaign response.
Action
Search
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search or write
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
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

New Contact
Triggers when a new contact is created.
Trigger
Scheduled
Try It
- Custom EntityRequired
Trigger
Scheduled
Try It
Case/Incident Updated
Triggers when a case/incident has been updated.
Trigger
Scheduled
Try It
Lead Updated
Triggers when a lead has been updated.
Trigger
Scheduled
Try It
Opportunity Updated
Triggers when an opportunity has been updated.
Trigger
Scheduled
Try It
- Info
Action
Write
- Info
Action
Write
- Info
- Customer typeRequired
- Status
Action
Write
- Info
- AccountRequired
Action
Write
- Info
- ContactRequired
Action
Write
- Info
- LeadRequired
Action
Write
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Campaign NameRequired
Action
Search
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search or write
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
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

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 Microsoft Dynamics 365 CRM

Microsoft Dynamics is built for any device, anywhere. Built for you. For Dynamics Version 9 and Dynamics 365.

Learn more Help

Related categories

Similar apps

Pipedrive

CRM (Customer Relationship Management)

Insightly

CRM (Customer Relationship Management)

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

PRODUCTS

CAPABILITIES

By team

Google BigQuery + Microsoft Dynamics 365 CRM

Create new rows in Google BigQuery for Microsoft Dynamics 365 CRM leads

New Account

Contact Updated

New Case/Incident

New Lead

New Opportunity

Updated Quote

Create Campaign

Create Campaign Response

Create Lead

Info

Update Campaign Response

Update Case/Incident

Info

State

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Contact

Info

Match if any of the fields match (otherwise only match if all the fields match)

Find Campaign Response

Find Opportunity

Info

Match if any of the fields match (otherwise only match if all the fields match)

Find or Create Contact

Info

Match if any of the fields match (otherwise only match if all the fields match)

Find or Create Opportunity

Info

Match if any of the fields match (otherwise only match if all the fields match)

New Row

Project IDRequired

DatasetRequired

TableRequired

Sort By ColumnRequired

Unique ColumnRequired

Updated Row

Project IDRequired

DatasetRequired

TableRequired

Unique ColumnRequired

ValueRequired

Create Rows

ProjectRequired

DatasetRequired

TableRequired

Import Data

Project IDRequired

DatasetRequired

TableRequired

RowsRequired

Skip Invalid Rows

Ignore Unknown Values

Update Row(s)

Project IDRequired

DatasetRequired

TableRequired

Where ColumnRequired

Where ValueRequired

Update ColumnsRequired

Find One Row

Project IDRequired

DatasetRequired

TableRequired

Sort By Column

Sort Direction

Where ClauseRequired

Get Rows for Job Completed

Project IDRequired

Job IDRequired