Agile CRM + Google BigQuery

Create Google BigQuery rows from new Agile CRM deals

Get ready to take data-based action to grow your business with this integration. When active, it turns new Agile CRM deals into data rows on Google BigQuery. Add deal value, owner, profitability, close date, and other info to a Google BigQuery table. Then, run queries that can take your business to the next level.

When this happens...
New Deal
Triggers when a new Deal is added in AgileCRM.
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?

- Track / MilestoneRequired
Trigger
Scheduled
Try It
New Case
Triggers when a new case is added in Agile CRM.
Trigger
Scheduled
Try It
New Deal
Triggers when a new Deal is added in AgileCRM.
Trigger
Scheduled
Try It
- Ticket FilterRequired
Trigger
Scheduled
Try It
- Tag NameRequired
Trigger
Scheduled
Try It

- Contact EmailRequired
- Subject of NoteRequired
- DescriptionRequired
Action
Write
- Contact EmailRequired
- TagsRequired
Action
Write

- First NameRequired
- Last Name
- EmailRequired
- If Duplicate Found
- Phone
- Tag
- Company
- Add Address
- City
- State
- Zip Code
- Country
- Website
Action
Write
- NameRequired
- PriorityRequired
- OwnerRequired
- Start TimeRequired
- End TimeRequired
Action
Write
- SubjectRequired
- Task TypeRequired
- PriorityRequired
- Owner
- Email
- Due Date
Action
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
- 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

Changing Any Deal Milestone
Changing any milestone in Agile CRM should be triggered.
Trigger
Instant
Try It
New Contact
Triggers when a new contact is add in AgileCRM.
Trigger
Scheduled
Try It
New Event
Triggers when a new event is created in Agile CRM.
Trigger
Scheduled
Try It
New Task
Triggers when a new task is added in the Agile CRM.
Trigger
Scheduled
Try It
- CampaignRequired
- Subscriber EmailRequired
Action
Write
- Contact EmailRequired
- Score to Be AddedRequired
Action
Write
- Company NameRequired
- Company URL
Action
Write
- NameRequired
- Owner
- Probability (%)
- ValueRequired
- Track
- Milestone
- Related To
- Close Date
- Description
- Deal Source
Action
Write
- EmailRequired
- SubjectRequired
- Cc
- PriorityRequired
- Status
- AssigneeRequired
- MessageRequired
Action
Write
- EmailRequired
- First Name
- Last Name
- Company
- Phone
- Tags
- Add Address
- City
- State
- Zip Code
- Country
- Create New Contact
- Website
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Scheduled
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
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 Agile CRM

Agile CRM offers contact management, marketing automation, telephony, analytics, web engagement, real-time alerts and social suite. Track, nurture, and sell like a pro.

Related categories

CRM (Customer Relationship Management)

Similar apps

About Google BigQuery

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

Learn more

Agile CRM + Google BigQuery

Create Google BigQuery rows from new Agile CRM deals

Changed Deal Milestone

New Case

New Deal

New Ticket

New Tag to Contact

Add Note

Add Tag to Contact

Create Contact

Last Name

If Duplicate Found

Phone

Tag

Company

Add Address

City

State

Zip Code

Country

Website

Add Event

Create Task

Owner

Email

Due Date

Query Job Completed (With Row Data)

Dataset

Table

New Job Completed

Create Row

Delete Rows

Run a Query

Location

API Request (Beta)

Query String Parameters

Headers

Additional Request Headers

Body

Find Row(s)

Sort By Column

Sort Direction

Find or Create Record

Sort By Column

Sort Direction

Changing Any Deal Milestone

New Contact

New Event

New Task

Add to Campaign

Add Score to Contact

Create Company

Company URL

Create Deal

Owner

Probability (%)

Track

Milestone

Related To

Close Date

Description

Deal Source

Create Ticket

Cc

Status

Create or Update Contact

First Name

Last Name

Company

Phone

Tags

Add Address

City

State

Zip Code

Country

Create New Contact

Website

New Row

Updated Row