ActiveCampaign + Google BigQuery

Create rows in Google BigQuery when new or updated deals occur in ActiveCampaign

Streamline your workflow with this efficient automation that activates when a new deal is added or updated in ActiveCampaign. It swiftly creates a row in Google BigQuery, keeping your database effortlessly updated. This allows for real-time tracking and management of business opportunities, enhancing business intelligence and sparking informed decision making.

When this happens...
New Deal Added or Updated
Triggers when a new deal is created or existing deal is updated.
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

- Custom ObjectRequired
- Trigger EventsRequired
Trigger
Instant
Try It
- Task Type (Optional)
Trigger
Instant
Try It
New Automation Webhook
Triggers when an automation sends out webhook data. To add a webhook in ActiveCampaign, navigate to your Automations section, add or edit an automation, and create a new "Webhook" action.
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It

- List (Deprecated)
Trigger
Instant
Try It
New Deal Note
Triggers when a new deal note is created.
Trigger
Instant
Try It

New Deal Added or Updated
Triggers when a new deal is created or existing deal is updated.
Trigger
Instant
Try It
- ListRequired
- Importer Note
Trigger
Instant
Try It
- List
- Skip Unsubscribe Events
- Importer Note
Trigger
Instant
Try It
- NameRequired
- Website
- Owner
Action
Write
- Account ID
- NameRequired
- Update OnlyRequired
- Account Owner
- Website
Action
Write
- TitleRequired
- ValueRequired
- Owner
- CurrencyRequired
- PipelineRequired
- StageRequired
- Account
- Contact Email Address
Action
Write
- AutomationRequired
- Automation RunRequired
- Contact IDRequired
Action
Write
- Contact IDRequired
- Account IDRequired
- Job Title
Action
Write
- Contact ID
- Contact Email
- ActionRequired
- Existing Tags
- Tags
Action
Write
- Custom ObjectRequired
- Record ID
- External ID
Action
Write
- TitleRequired
- ValueRequired
- Owner
- CurrencyRequired
- PipelineRequired
- StageRequired
- Account ID
- Contact ID
- Description
Action
Write
- Task ID
- Title
- Deal IDRequired
- Note
- Due DateRequired
- End Date
- Task TypeRequired
- Assignee
Action
Write
- ActionRequired
- List IDRequired
- Contact ID
- Email Address
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- ID
- Email Address
- Phone Number
Action
Search
- Deal Title
- Contact Email
Action
Search
- Deal Task TitleRequired
- Deal ID
Action
Search
- 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

- Custom ObjectRequired
Trigger
Instant
Try It
New or Updated Account
Triggers when a new account is added or an existing account's details are updated.
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- Task type
Trigger
Instant
Try It
New Deal Task
Triggers when a new deal task is created.
Trigger
Instant
Try It
- Importer Note
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- EventRequired
- Tag
Trigger
Instant
Try It
- Account IDRequired
- Name
- Website
Action
Write
- List
- ID
- Email Address
- First Name
- Last Name
- Full Name
- Phone Number
- Tags
- Organization Name
- Job Title
Action
Write
- AutomationRequired
- Subscriber EmailRequired
Action
Write
- Email MessageRequired
- ListRequired
- Campaign NameRequired
Action
Write
- Contact IDRequired
- List IDRequired
- NoteRequired
Action
Write
- Task ID
- Title
- Contact IDRequired
- Note
- Due DateRequired
- End Date
- Task TypeRequired
- Assignee
Action
Write
- Contact IDRequired
- Deal IDRequired
- Role
Action
Write
- DealRequired
- NoteRequired
Action
Write
- DealRequired
- Title
- Value
- Currency
- Owner
- Pipeline
- Stage
- Account ID
- Contact ID
- Status
- Description
Action
Write
- Event KeyRequired
- Event Account IDRequired
- Event NameRequired
- Event Value
- Contact Email Address
Action
Write
- NameRequired
Action
Search
- Contact Task TitleRequired
- Contact ID
Action
Search
- Title
- Contact Email
Action
Search
- EmailRequired
Action
Search
- 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 ActiveCampaign

ActiveCampaign is a customer experience automation (CXA) platform that helps businesses meaningfully engage customers. Access pre-built automations that combine transactional email and email marketing, marketing automation, ecommerce marketing, and CRM for powerful segmentation and personalization across social, email, messaging, chat, and text.

Learn more

Related categories

Marketing Automation

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

Related categories

Related Zap Templates

Create rows in Google BigQuery for new or updated custom object records in ActiveCampaign

Related Zap Templates

Create rows in Google BigQuery for new or updated custom object records in ActiveCampaign

ActiveCampaign + Google BigQuery

Create rows in Google BigQuery when new or updated deals occur in ActiveCampaign

New or Updated Custom Object Record

Deal Task Completed

New Automation Webhook

New Campaign Link Click

New Campaign Starts Sending

New Contact Note

New Deal Note

New Deal Added or Updated

Contact Added to List

New or Updated Contact

Create Account

Create or Update Account

Create Deal (Deprecated)

Remove Contact From Automation

Add Contact to Account

Add/Remove Tag From Contact

Create or Update a Custom Object Record

Create Deal

Create or Update Deal Task

Subscribe or Unsubscribe Contact From List

API Request (Beta)

Find Contact

Find Deal

Find Deal Task

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

Custom Object Record Deleted

New or Updated Account

New Campaign Bounce

New Campaign Open

New Campaign Unsubscribe

New Contact Task

New Deal Task

New Contact

Updated Contact

Tag Added or Removed From Contact

Update Account

Create or Update Contact

Add Existing Contact to Automation

Create Campaign

Add Contact Note

Create or Update Contact Task

Add Secondary Contact to Deal

Add Note to Deal

Update Deal

Create Tracked Event

Find Account

Find Contact Task

Find Deal Owner

Find User

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

About ActiveCampaign

Related categories

Similar apps

AWeber

HubSpot

Constant Contact

About Google BigQuery

Related categories

Related Zap Templates

Related Zap Templates