Snowflake - Icon

Snowflake

Salesforce Pardot - Icon

Salesforce Pardot

SQL-Server

Microsoft SQL Server

Firebase-icon-color

Firebase

Salesforce Marketing Cloud - Icon

Salesforce Marketing Cloud

Prometheus - Icon

Prometheus

MongoDB - Icon

MongoDB

Marketo - Icon

Marketo

AmazonAthena-icon-color

Amazon Athena

Databricks - Icon

Databricks

MySQL-icon-color

MySQL

InfluxDB

FreshService

Freshservice

PostgreSQL-icon-color

PostgreSQL

Oracle E-Business Suite EBS - Icon

Oracle E-Business Suite EBS

MailChimp

Mailchimp

SendGrid - Icon

SendGrid

Neo4j

PagerDuty - Full

PagerDuty

Azure Synapse Analytics - Icon

Microsoft Azure Synapse Analytics

Add or update one or more columns in a table in BigQuery via the API, so you don't have to create them manually. Useful when you're looking to ensure that a table matches a schema before running an "Insert Rows" operation.

Add or update columns in table

Create a new, empty table in the dataset.

Create table

Delete the table specified by table_id from the dataset. If the table contains data, all the data will be deleted.

Delete table

Get job

Gets full details about a Google BigQuery table.

Get table

Insert job

Inserts up to 500 rows into a Google BigQuery table.

Insert rows

Uploads a CSV file to BigQuery, saves the rows into a table.

Insert rows from CSV file

List datasets

List datasets DDL

List job query results

List jobs

List jobs DDL

List all the projects you have in your Google BigQuery account.

List projects

List projects DDL

List tables

List tables DDL

Run query

weekly-group-demo 2x

Tray Platform group demo every 3rd Thursday at 10am PT

MongoDB-Logo

How to integrate MongoDB

postgresql-logo

How to integrate PostgresSQL

aws redshift

How to integrate Amazon Redshift

flow-data-between-csv-and-your-stack-with-csv-processor blog post cover image

flow-data-between-csv-and-your-stack-with-csv-processor

Learn How to Automate Your CSV and Flat File Management

Connector Department - Developers - Cards

New Relic - Full - Dark

New Relic - ANONYMOUS

Software analytics company - Customer Story Quote

White New Relic Logo

Developers

Google BigQuery - Icon

Google BigQuery

Database

Add contact to company

Add contact records that have already been created in the system to a contact list. You can either specify their email addresses or their IDs.

Add contact to list

Move a specified property to the recycling bin.

Archive property

Move a specified property group to the recycling bin.

Archive property group

Associate crm objects

Associate a custom object with another object.

Associate custom object

Create a group of line items in your HubSpot account.

Batch create line items

Create a group of products in your HubSpot account.

Batch create products

If multiple contacts already exist update their data. Create new contacts if they do not i.e. Upsert

Batch create/update contact

Delete a group of line items from your HubSpot account.

Batch delete line items

Delete a group of products from your HubSpot account.

Batch delete products

Batch update companies

Update a group of deals in your HubSpot account.

Batch update deals

Update a group of line items in your HubSpot account.

Batch update line items

Update a group of products in your HubSpot account

Batch update products

Using the Event ID calculate the attendance duration for all attendees and update said attendees timeline entries.

Calculate attendance duration at event for all attendees

Cancel marketing event (beta)

Check if a contact with an email address exists.

Contact exists with email?

Create blog post

Create call engagement

Create company

Create contact

Create contact list

Create a CRM object with the given properties and return a copy of the object, including the ID. Please define a schema in advance using the 'Create object schema' operation.

Create custom object

Creates and tracks deals in HubSpot. It also allows you to connect HubSpot with an external CRM or other sales management software.

Create deal

Create an email with the given properties.

Create email engagement

Create a line item in your HubSpot account.

Create line item

Create marketing event (beta)

Create a meeting with the given properties.

Create meeting engagement

Create note engagement

Define a new object schema, along with custom properties and associations.

Create object schema

Create a product in your Hubspot account.

Create product

Create property

Create a new property group for an object type.

Create property group

Create task engagement

Create ticket

If contact already exists update their data. Create a new contact if not i.e. Upsert

Create/update contact

If a marketing event already exists update the data. Create a new marketing event if it does not i.e. Upsert

Create/update marketing event (beta)

Delete all associations between two records.

Delete associations from CRM objects

Delete blog post

Delete comment

Delete company

Delete contact

Delete contact list

Delete custom object association

Delete deal

Delete line item

Delete a schema. NB: Any existing records of this schema must be deleted first, otherwise this request will fail.

Delete object schema

Delete product

Delete ticket

Retrieve the current settings for the application.

Get app settings (beta)

Get blog post

Get company

Get a specific company property by its (internal) name.

Get company property

Get contact by ID

Return a contact by the given email address.

Get contact by email

Get contact list

Get contact property

Get deal

Get file import status

Get line item

Retrieve details of the specified marketing event.

Get marketing event

Get owner

Get product

Retrieve the email subscription information for the given email address and portal.

Google BigQuery and HubSpot integration + automation

Popular Google BigQuery and HubSpot integrations

Google BigQuery and HubSpot Connector Details

Google BigQuery

HubSpot

Tray.io is the leader in low-code automation

Similar connectors to Google BigQuery and HubSpot

Try Tray today and see for yourself. No strings attached.