Front + Google BigQuery

Create rows in Google BigQuery when new rules are triggered in Front

Simplify your data management process with this streamlined workflow. When a specific rule is activated within the Front app, this setup instantly creates a new row in your Google BigQuery. It's an efficient solution to ensure your BigQuery always stays up-to-date with the latest data from your Front app while saving you time and manual work.

When this happens...
Rule Triggered
Triggers when criteria for a team rule is met.
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

- Team
- Inboxes
Trigger
Instant
Try It
- Team
- Inboxes
Trigger
Instant
Try It
- Team
- Tags
Trigger
Instant
Try It
- Contact IDRequired
- HandleRequired
- Handle SourceRequired
Action
Write
- Conversation IDRequired
- Tag IDsRequired
Action
Write

- Account NameRequired
- Description
- Email Domains
- External ID
- Custom Attributes
Action
Write
- Channel IDRequired
- AuthorRequired
- To
- cc
- bcc
- Subject
- BodyRequired
- Sharing
Action
Write

- Name
- External URLRequired
Action
Write
- InboxRequired
- Sender Name
- Sender HandleRequired
- Sender Handle TypeRequired
- ToRequired
- Subject
- Body Format
- BodyRequired
- DateRequired
- Attachment
- External IDRequired
- Message Type
- Message Direction
- Author
- Is ArchivedRequired
- Should Skip RulesRequired
- Thread Reference
Action
Write
- Contact IDRequired
- HandleRequired
- Handle SourceRequired
- Force
Action
Write
- Conversation IDRequired
- Tag IDsRequired
Action
Write
- Conversation IDRequired
- To
- Cc
- BCC
- Subject
- BodyRequired
- Attachment
- Channel
- Tags
- Tag IDs
- Archive the Conversation
Action
Write
- ContactRequired
- Name
- Description
- Links
- Groups
- Remove Contact From Every Group
- Picture
- Custom Attributes
Action
Write
- Link IDRequired
- NameRequired
Action
Write
- Email Domain
- External ID
- Account ID
Action
Search
- Search Text
- Inbox ID
- Tag
- Contact
- Recipient
- From
- To
- CC
- BCC
- Participant
- Assignee
- Author
- Mention
- Commenter
- Conversation Status
Action
Search
- Handle SourceRequired
- HandleRequired
- Team
- Name
- Description
- Email Addresses
- Phone Numbers
- Links
- Groups
- Picture
- Custom Attributes
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

- Team
- RuleRequired
Trigger
Instant
Try It
- Team
- Inboxes
Trigger
Instant
Try It
- Conversation IDRequired
- Author
- BodyRequired
Action
Write
- Conversation IDRequired
- Links External URLsRequired
Action
Write
- Conversation IDRequired
- Teammate
Action
Write
- Team
- Name
- Description
- Email Addresses
- Phone Numbers
- Links
- Groups
- Picture
- Custom Attributes
Action
Write
- Conversation IDRequired
- AuthorRequired
- To
- Cc
- Bcc
- Subject
- BodyRequired
- Sharing
- Channel IDRequired
- Quote Body
- Signature ID
- Should add default signature
Action
Write
- Conversation IDRequired
Action
Write
- Link IDRequired
Action
Write
- Conversation IDRequired
- Link IDsRequired
Action
Write
- ChannelRequired
- Sender Name
- ToRequired
- Cc
- BCC
- Subject
- BodyRequired
- Attachment
- Author
- Archive the Conversation
- Tags
- Tag IDs
Action
Write
- Account IDRequired
- Name
- Description
- Email Domains
- Custom Attributes
Action
Write
- Inbox
- Conversation IDRequired
- Assignee
- Status
- Tags
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Handle SourceRequired
- HandleRequired
Action
Search
- Email Domain
- External ID
- Account ID
- Account NameRequired
- Description
- Email Domains
- Custom Attributes
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

About Front

Front is the AI-powered customer service platform built for collaboration that enables 9,000 businesses to deliver five-star service at scale.

Learn more

Related categories

Customer Support

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

Send messages in Front for new rows in Google BigQuery

Related Zap Templates

Send messages in Front for new rows in Google BigQuery

Front + Google BigQuery

Create rows in Google BigQuery when new rules are triggered in Front

New Comment

New Inbound Message

New Tag Added to Message

Add Contact Handle

Add Conversation Tags

Create Account

Create Draft

Create Link

Import Message

Remove Contact Handle

Remove Conversation Tags

Send Reply

Update Contact

Update Link

Find Account

Find Conversation

Find or Create Contact

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

Rule Triggered

New Outbound Message

Add Comment

Add Conversation Links

Assign or Unassign Conversation

Create Contact

Create Draft Reply

Get Conversation Last Message

List Link Conversations

Remove Conversation Links

Send Message

Update Account

Update Conversation

API Request (Beta)

Find Contact

Find or Create Account

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

About Front

Related categories

Similar apps

Zendesk

Gmail

Help Scout

About Google BigQuery

Related categories

Related Zap Templates

Related Zap Templates