Copilot + Google BigQuery

Create new rows in Google BigQuery when new clients are added in Copilot

Streamline your data management process with this efficient workflow. When a new client is added in Copilot, a corresponding entry is created in Google BigQuery. This simplifies your task by directly populating your database with necessary client information, ensuring you have instant access to updated insights. This hands-off process saves time, reduces manual entry errors, and aids in maintaining an up-to-date client database.

When this happens...
Client Created
Triggers when a new client is created.
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

What does this mean?

List App Installs
Lists the app installs in a workspace.
Trigger
Scheduled
Try It
Client Created
Triggers when a new client is created.
Trigger
Instant
Try It
List Clients
Lists the clients.
Trigger
Scheduled
Try It
Company Created
Triggers when a company gets created in the Copilot for the first time
Trigger
Instant
Try It
Contract Signed
Triggers when a contract is signed.
Trigger
Instant
Try It

List Custom Fields
Lists all available custom fields.
Trigger
Scheduled
Try It
File Created
Triggers when a file gets created within a file channel
Trigger
Instant
Try It

- File Channel IdRequired
- Folder path
- Limit
Trigger
Scheduled
Try It
Folder Created
Triggers when a folder gets created within a file channel
Trigger
Instant
Try It
Folder Updated
Triggers when a folder gets updated within a file channel
Trigger
Instant
Try It
- Limit
Trigger
Scheduled
Try It
Link Deleted
Triggers when a link gets deleted within a file channel
Trigger
Instant
Try It
Message Channel Created
Triggers when a new message channel is created.
Trigger
Instant
Try It
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- Member ID
- Limit
Trigger
Scheduled
Try It
Message Sent
Triggers when a message gets sent in any channels belonging to the portal
Trigger
Instant
Try It
List Workspace
List the workspace associated with the portal
Trigger
Scheduled
Try It
- EmailRequired
- Given nameRequired
- Family NameRequired
- Company ID
- Send Invite?
Action
Write
- NameRequired
- Icon Image URL
Action
Write
- Contract Template ID
- Recipient ID
Action
Write
- Channel IDRequired
- PathRequired
- File ContentRequired
Action
Write
- Recipient IDRequired
- Form IDRequired
Action
Write
- Membership TypeRequired
- Entity ID - ID of the membership entity, e.g., ID of a company or individual client user
- Member IDs - IDs of client members to be added to this channel
Action
Write
- The ID of the App InstallRequired
- ClientId
- CompanyId
Action
Search
- The ID of the Company to get
- Name
Action
Search
- The ID of the file channel to get
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- Member ID
Action
Search
- The ID of the internal user to get
Action
Search
- The ID of the App InstallRequired
- ClientId
- The company id of the App Connection
- The type of the App ConnectionRequired
- The content of the App ConnectionRequired
- The client ids to be part of the App Connection
Action
Search or write
- The ID of the Company to get
- NameRequired
- Icon Image URL
Action
Search or write
- The ID of the message channel to get
- Membership TypeRequired
- Entity ID - ID of the membership entity, e.g., ID of a company or individual client user
- Member ID
- Limit
- Member IDs - IDs of client members to be added to this channel
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

Client Activated
Triggers when a client authenticates in the Copilot for the first time
Trigger
Instant
Try It
Client Custom Fields Updated
Triggers only when a client user has updates to custom fields.
Trigger
Instant
Try It
Client Updated
High-frequency trigger for each client user update.
Trigger
Instant
Try It
List Companies
Lists the companies.
Trigger
Scheduled
Try It
Contract Requested
Triggers when a contract is assigned to a client.
Trigger
Instant
Try It
- Custom Field IDRequired
Trigger
Scheduled
Try It
File Deleted
Triggers when a file has been deleted within a file channel
Trigger
Instant
Try It
File Updated
Triggers when a file has been updated within a file channel
Trigger
Instant
Try It
Folder Deleted
Triggers when a folder gets deleted within a file channel
Trigger
Instant
Try It
- Form IDRequired
Trigger
Instant
Try It
Link Created
Triggers when a link gets created within a file channel
Trigger
Instant
Try It
Link Updated
Triggers when a link gets updated within a file channel
Trigger
Instant
Try It
Message Channel Deleted
Triggers when a message channel is deleted.
Trigger
Instant
Try It
- Channel ID
- Limit
Trigger
Scheduled
Try It
- Recipient ID
Trigger
Instant
Try It
- The ID of the App InstallRequired
- The type of the App ConnectionRequired
- The content of the App ConnectionRequired
- The company id of the App Connection
- The client ids to be part of the App Connection
Action
Write
- IDRequired
- Given name
- Family Name
- Company ID
Action
Write
- NameRequired
- Company IDRequired
Action
Write
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- IDs of all members in the channel
Action
Write
- Channel IDRequired
- PathRequired
Action
Write
- Channel IDRequired
- PathRequired
- Link urlRequired
Action
Write
- The text content of the messageRequired
- The Id of the target message channelRequired
- (Optional) The Id of the client who is the author of the message
Action
Write
- ID
- Email
- Company ID
Action
Search
- Custom Field IDRequired
- Label
Action
Search
- The ID of the Form to getRequired
Action
Search
- The ID of the message channel to get
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- Member ID
- Limit
Action
Search
- ID
- EmailRequired
- Company ID
- Given nameRequired
- Family NameRequired
- Send Invite?
Action
Search or write
- The ID of the file channel to get
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- Member ID
- IDs of all members in the channel
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 Copilot

Create a client portal to combine messaging, payments, and other modules to offer clients a branded, streamlined experience.

Learn more

Related categories

Project Management

About Google BigQuery

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

Learn more

PRODUCTS

CAPABILITIES

By team

Copilot + Google BigQuery

Create new rows in Google BigQuery when new clients are added in Copilot

List App Installs

Client Created

List Clients

Company Created

Contract Signed

List Custom Fields

File Created

List Files

Folder path

Limit

Folder Created

Folder Updated

List Internal Users

Limit

Link Deleted

Message Channel Created

List Message Channels

Membership Type

The ID of the membership entity. E.g. ID of a company or individual

Member ID

Limit

Message Sent

List Workspace

Create Client

EmailRequired

Given nameRequired

Family NameRequired

Company ID

Send Invite?

Create Company

NameRequired

Icon Image URL

Create Contract

Contract Template ID

Recipient ID

Create File

Channel IDRequired

PathRequired

File ContentRequired

Request Form Responses

Recipient IDRequired

Form IDRequired

Create Message Channel

Membership TypeRequired

Entity ID - ID of the membership entity, e.g., ID of a company or individual client user

Member IDs - IDs of client members to be added to this channel

Find App Connection

The ID of the App InstallRequired

ClientId

CompanyId

Find a Company

The ID of the Company to get

Name

Find a File Channel

The ID of the file channel to get

Membership Type

The ID of the membership entity. E.g. ID of a company or individual

Member ID

Find an Internal User

The ID of the internal user to get

Find or Create AppConnection

The ID of the App InstallRequired

ClientId

The company id of the App Connection

The type of the App ConnectionRequired

The content of the App ConnectionRequired

The client ids to be part of the App Connection

Find or Create Company

The ID of the Company to get

NameRequired

Icon Image URL

Find or Create Message Channel

The ID of the message channel to get

Membership TypeRequired

Entity ID - ID of the membership entity, e.g., ID of a company or individual client user