Assembly.com + Google BigQuery

Assembly.com + Google BigQuery integrations

Create new rows in Google BigQuery when new clients are added in Assembly.com

Streamline your data management process with this efficient workflow. When a new client is added in Assembly.com, 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 CreatedTriggers when a new client is created.
TriggerInstant
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Assembly.com and Google BigQuery

Discover other triggers and actions you can use with Assembly.com and Google BigQuery

List App Installs
Lists the app installs in a workspace.
Trigger
Polling
Try It
Client Created
Triggers when a new client is created.
Trigger
Instant
Try It
List Clients
Lists the clients.
Trigger
Polling
Try It
Company Created
Triggers when a company gets created in the Assembly for the first time
Trigger
Instant
Try It
- Query param to filter placeholder companies
Trigger
Polling
Try It

Contract Requested
Triggers when a contract is assigned to a client.
Trigger
Instant
Try It
- Custom Field ID
  Required
Trigger
Polling
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 ID
  Required
Trigger
Instant
Try It
Internal User Created
Triggers when a new internal user is created.
Trigger
Instant
Try It
- Limit
Trigger
Polling
Try It
Invoice Deleted
Triggers when an invoice is deleted
Trigger
Instant
Try It
Invoice Paid
Triggers when an invoice is paid
Trigger
Instant
Try It
Invoice Updated
Triggers when an invoice is updated
Trigger
Instant
Try It
List Invoice Templates
Lists the invoice templates.
Trigger
Polling
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
- The ID of the client user
- Member ID
- Limit
Trigger
Polling
Try It
Message Sent
Triggers when a message gets sent in any channels belonging to the portal
Trigger
Instant
Try It
Note Deleted
Triggers when a note is deleted.
Trigger
Instant
Try It
Note Updated
Triggers when a note is updated.
Trigger
Instant
Try It
Payment Failed
Triggers when a payment is failed for an invoice
Trigger
Instant
Try It
Payment Succeeded
Triggers when a payment is successful for an invoice
Trigger
Instant
Try It
List Prices
Lists the prices.
Trigger
Polling
Try It
List Products
Lists the products.
Trigger
Polling
Try It
Subscription Canceled
Triggers when an subscription is canceled
Trigger
Instant
Try It
List Subscriptions
Lists the subscriptions.
Trigger
Polling
Try It
Task Archived
Triggers when a task gets archived in your workspace.
Trigger
Instant
Try It
Task Completed
Triggers when a task gets completed in your workspace.
Trigger
Instant
Try It
Task Deleted
Triggers when a task gets deleted in your workspace.
Trigger
Instant
Try It
- Limit
- Next Token
Trigger
Polling
Try It
List Workspace
List the workspace associated with the portal
Trigger
Polling
Try It
- Email
  Required
- Given name
  Required
- Family Name
  Required
- Company ID
- Send Invite?
Action
Write
- Name
  Required
- Icon Image URL
Action
Write
- Contract Template ID
- Recipient ID (Deprecated)
- Client ID
- Company ID
Action
Write
- Channel ID
  Required
- Path
  Required
- File Content
  Required
Action
Write
- Client Permissions
- ID
  Required
Action
Write
- Recipient ID (Deprecated)
- Form ID
  Required
- Client ID
- Company ID
Action
Write
- Channel ID
  Required
- Path
  Required
- Link url
  Required
Action
Write
- The text content of the message
  Required
- The Id of the target message channel
  Required
- (Optional) The Id of the client who is the author of the message
Action
Write
- Title
  Required
- Content
  Required
- Note ID
  Required
Action
Write
- Recipient type
- Prompt
- Amount (in cents)
- Description
- Quantity
  Required
- PromptProduct
- Product
- PricePrompt
- Price
- Days Until Due
  Required
- Interval
- Tax Percentage
- Memo
- Accept Payment Via Credit Card
- Accept Payment Via Bank Transfer
Action
Write
- Name
- Description
- Parent Task ID
- Client ID
- Company ID
- Internal User ID
- Status
- Due Date
- Template ID
- ClientVisibility_clientId
- Company ID
Action
Write
- The ID of the App Install
  Required
- ClientId
- CompanyId
Action
Search
- ID
- Email
- Company ID
Action
Search
- Custom Field ID
  Required
- Label
Action
Search
- The ID of the file to get
  Required
Action
Search
- The ID of the internal user to get
Action
Search
- The ID of the note to retrieve.
Action
Search
- The ID of the Product to get
  Required
Action
Search
- The ID of the task comment
  Required
Action
Search
- The ID of the task template to get
  Required
Action
Search
- ID
- Email
  Required
- Company ID
- Given name
  Required
- Family Name
  Required
- 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 (Deprecated)
- Member ID
- Client ID
- Company ID
- IDs of all members in the channel
Action
Search or write
- The ID of the message channel to get
- Membership Type
  Required
- Entity ID - ID of the membership entity, e.g., ID of a company or individual client user (Deprecated).
- Client ID
- Member ID
- Limit
- Member IDs - IDs of client members to be added to this channel
- Company ID
Action
Search or write
- The ID of the Subscription to get
  Required
- Recipient type
- Prompt
- Amount (in cents)
- Description
- Quantity
  Required
- PromptProduct
- Product
- PricePrompt
- Price
- Days Until Due
  Required
- Interval
- Tax Percentage
- Memo
- Accept Payment Via Credit Card
- Accept Payment Via Bank Transfer
Action
Search or write
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

Client Activated
Triggers when a client authenticates in the Assembly 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
Company Custom Fields Updated
Triggers only when a company has updates to custom fields.
Trigger
Instant
Try It
Contract Signed
Triggers when a contract is signed.
Trigger
Instant
Try It
- Entity Type
Trigger
Polling
Try It
File Created
Triggers when a file gets created within a file channel
Trigger
Instant
Try It
- File Channel Id
  Required
- Folder path
- Limit
Trigger
Polling
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
- Next Token
- Form ID
  Required
- Status
Trigger
Polling
Try It
Internal User Deleted
Triggers when an internal user is deleted.
Trigger
Instant
Try It
Invoice Created
Triggers when an invoice is created
Trigger
Instant
Try It
List Invoices
Lists the invoices.
Trigger
Polling
Try It
Invoice Sent
Triggers when an invoice is sent
Trigger
Instant
Try It
Invoice Voided
Triggers when an invoice is voided
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
Polling
Try It
Note Created
Triggers when a new note is created.
Trigger
Instant
Try It
- Entity Type
- The ID of the entity assigned to the note. E.g. ID of a client or company.
- Limit
Trigger
Polling
Try It
- Recipient ID
Trigger
Instant
Try It
List Payments
Lists the payments.
Trigger
Polling
Try It
Price Created
Triggers when a price is created
Trigger
Instant
Try It
Product Created
Triggers when a product is created
Trigger
Instant
Try It
Product Updated
Triggers when a product is updated
Trigger
Instant
Try It
Subscription Created
Triggers when an subscription is created
Trigger
Instant
Try It
List Subscription Templates
Lists the subscription templates.
Trigger
Polling
Try It
- Limit
- Next Token
- Task ID
- Parent Comment ID
Trigger
Polling
Try It
Task Created
Triggers when a task gets created in your workspace.
Trigger
Instant
Try It
- Limit
- Next Token
- Created By
- Parent Task ID
- Status
- Client ID
- Company ID
- Internal User ID
Trigger
Polling
Try It
Task Updated
Triggers when a task gets updated in your workspace.
Trigger
Instant
Try It
- The ID of the App Install
  Required
- The type of the App Connection
  Required
- The content of the App Connection
  Required
- The company id of the App Connection
- The client ids to be part of the App Connection
Action
Write
- ID
  Required
- Given name
- Family Name
- Company ID
- Send Invite?
Action
Write
- Company ID
  Required
- Name
Action
Write
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual (Deprecated)
- IDs of all members in the channel
- Client ID
- Company ID
Action
Write
- Channel ID
  Required
- Path
  Required
- Client Permissions
Action
Write
- Client Permissions
- Channel ID
  Required
Action
Write
- Recipient type
- Note
- Amount (in cents)
- Description
- Quantity
  Required
- Note
- Product
- Note
- Price
- Days Until Due
  Required
- Tax Percentage
- Memo
- Accept Payment Via Credit Card
- Accept Payment Via Bank Transfer
Action
Write
- Membership Type
  Required
- Entity ID - ID of the membership entity, e.g., ID of a company or individual client user (Deprecated).
- Member IDs - IDs of client members to be added to this channel
- Client ID
- Company ID
Action
Write
- Entity Type
  Required
- ID of the entity, e.g., ID of a company or client.
  Required
- Title
  Required
- Content
Action
Write
- Subscription
Action
Write
- The ID of the task comment
  Required
Action
Write
- Name
- Description
- Client ID
- Company ID
- Internal User ID
- Status
- Due Date
- Is Archived
- ClientVisibility_clientId
- Company ID
Action
Write
- ID
  Required
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
- Client ID
- Company ID
Action
Search
- The ID of the Form to get
  Required
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
- The ID of the client user
- Member ID
- Limit
Action
Search
- The ID of the Price to get
  Required
Action
Search
- The ID of the Subscription to get
  Required
Action
Search
- The ID of the task to get
  Required
Action
Search
- The ID of the App Install
  Required
- ClientId
- The company id of the App Connection
- The type of the App Connection
  Required
- The content of the App Connection
  Required
- The client ids to be part of the App Connection
Action
Search or write
- The ID of the Company to get
- Name
  Required
- Icon Image URL
Action
Search or write
- The ID of the file to get
  Required
- Channel ID
  Required
- Path
  Required
- File Content
  Required
Action
Search or write
- The ID of the note to retrieve.
- Entity Type
  Required
- ID of the entity, e.g., ID of a company or client.
  Required
- Title
  Required
- Content
Action
Search or write
- The ID of the task to get
  Required
- Name
- Description
- Parent Task ID
- Client ID
- Company ID
- Internal User ID
- Status
- Due Date
- Template ID
- ClientVisibility_clientId
- Company ID
Action
Search or write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write

About Assembly.com

Assembly.com is a complete client communication and management solution that offers a branded and streamlined experience to businesses.

Learn moreLearn moreHelpHelp

Related categories

CRM (Customer Relationship Management)

About Google BigQuery

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

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

Related Zap Templates

Create rows in Google BigQuery when new companies are created in Assembly.com

Create new rows in Google BigQuery when new files are created in Assembly.com