ConditionalVisibility

new-products-promo

Automation inspiration

automate-google-bigquery-00-hero

Google BigQuery

With Zapier's workflows, you can automate data transfers and build seamless connections between BigQuery and thousands of other apps.

5 ways to automate Google BigQuery with Zapier

Keep your team informed about new data in your Google BigQuery dataset by automatically sending channel messages in Slack. This workflow saves time and ensures consistent communication, so you never miss any important updates or insights from your BigQuery rows. Create seamless collaboration and stay in the loop with this efficient automation.

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

Triggers when a query job has completed processing successfully.

Query Job Completed (With Row Data)

Triggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.

New Row

Triggers when a query job has completed processing successfully or unsuccessfully.

New Job Completed

Triggers when an existing row is updated in a table in BigQuery.

Updated Row

Find a row by specifying a table, a WHERE clause, an optional ORDER BY.

Find One Row

Find row(s) by specifying a table, a WHERE clause, an optional ORDER BY, and a LIMIT.

Find Row(s)

Gets batch of rows from completed jobs in BigQuery

Get Rows for Job Completed

Runs a SQL query against a table in BigQuery.

Run a Query

Find or Create Record

Creates a new row of data in a table. *Note:* Does not create a job.

Create Row

Creates new rows of data in a table (accepts line items). *Note:* Does not create a job.

Create Rows

Deletes row(s) in an existing table in BigQuery

Delete Rows

Imports data into a table. The data must be in JSON format.

Import Data

Updates new row(s) to an existing table in BigQuery

Update Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Slack is a platform for team communication: everything in one place, instantly searchable, available wherever you go. Offering instant messaging, document sharing and knowledge search for modern teams.

Slack

Triggers when a new message is posted to any public channel.

New Public Message Posted Anywhere

New Channel

Triggers when a new message is posted to a specific #channel you choose.

New Message Posted to Channel

Triggers when a custom emoji has been added to a team.

New Team Custom Emoji

Triggers when a new file is uploaded to your workspace.

New File

Triggers when a username or highlight word is mentioned in a public #channel.

New Mention

Triggers when a new message is found that matches the query.

New Message From Query

Triggers when a new message is posted to a specific #private-channel or multi-dm.

New Message Posted to Private Channel

Triggers when a Message is pushed from Slack.

New Pushed Message

Triggers when a reaction (aka reactji) is added to a message in a public #channel.

New Reaction Added

New Saved Message

Triggers when a new Slack user is created / first joins your org.

New User

Finds a Slack message using the Slack Search feature.

Find Message

Finds a user by matching against their email instead of their username.

Find User by Email

Find User by ID

Finds a user by matching against their real name instead of their username.

Find User by Name

Find User by Username

Adds a reminder for yourself or a teammate, just like the `/remind` slash command.

Add Reminder

Invite an existing User to an existing Channel. You must be a member of the channel to invite someone to it.

Invite User to Channel

Posts a message to the specific #channel you choose. Message delivery can be scheduled for later.

Send Channel Message

Sends a direct message to a user or yourself from the Slackbot. Can also schedule a message for later.

Send Direct Message

Create Channel

Post a new message to a private channel you choose. Can also schedule a message for later.

Send Private Channel Message

Set Channel Topic

Update basic profile fields such as name or title

Update Profile

Sets your Slack status to the given text and emoji.

Set Status

Invite a new User to your Slack workspace. Uses legacy tokens.

Invite New User

Post Slack messages for new Google BigQuery rows.

When it comes to query jobs, you need to keep your data analysis team in the know. Don't waste time with email threads or endless meetings, though. When Google BigQuery jobs complete processing, this integration automatically sends a new message to a specified Slack channel. The team is instantly updated, and you don't have to compose a single email or organize even one meeting!

Post new messages to a Slack channel once Google BigQuery successfully complete

Gmail is the communications nervous system for many companies, but it can't read minds. This integration might make it seem like that, though, by automatically sending emails in Gmail once Google BigQuery query jobs finish processing. Save the time it takes you to address, craft, edit, and send Gmail, while keeping your team members and stakeholders in the loop.

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Gmail

Triggers when you receive a new attachment.

New Attachment

New Label

Triggers when you receive a new email and label it within two days.

New Labeled Email

Triggers when a new email appears in the specified mailbox.

New Email

Triggers when you receive a new email that matches a search string you provide.

New Email Matching Search

Triggers when you receive a new email and star it within two days.

New Starred Email

New Thread

Find Email

Find or Send Email

Add Label to Email

Delete Email

Create Draft

Create a draft reply to an existing email.

Create Draft Reply

Create Label

Send Email

Remove Label From Email

Reply to Email

Send emails from Gmail when Google BigQuery jobs are done

Data wrangling should be about analysis, not time-consuming content management. That's the idea behind this integration, which automatically creates a new row of data in a Google BigQuery table as soon as a webhook is detected at a specified URL. Customize your data import workflows and avoid the hassle of tedious manual data management.

Webhooks simply POST data (or JSON) to a specific URL every time we see something new. Webhooks can also accept data (or JSON) to kick off a workflow in Zapier.

Webhooks by Zapier

Triggers when a POST, PUT, or GET request is made to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.

Catch Raw Hook

Triggers when a POST, PUT, or GET request is madeto a Zapier URL.

Catch Hook

Triggers when a request to a URL returns new entries.

Retrieve Poll

Fire off a custom request by providing raw details. Very flexible but unforgiving.

Custom Request

Fire off a single GET request with optional querystrings.

Fire off a single POST request as a form or JSON.

POST

Fire off a single PUT request as a form or JSON.

Catch Webhooks to add new Google BigQuery data rows

When a new row is added to Google BigQuery, this workflow ensures its data is promptly shared via a POST request through Webhooks by Zapier. This efficient process eliminates the necessity for manual updates, ensuring vital information is disseminated swiftly and seamlessly. Make your data work smarter and faster while streamlining your operations with this powerful automation.

Create new webhooks when new rows are added in Google BigQuery

Data is useless unless it's analyzed. If your data comes from forms, you can automate analysis using this integration. Each time you get a new Typeform entry, a row with the form data appears on a Google BigQuery table. It's a simple way to make sure all your data gets processed.

Typeform helps you ask awesomely online! If you ever need to run a survey, questionnaire, form, contest etc. Typeform will help you achieve it beautifully across all devices, every time, using its next generation platform.

Typeform

New Entry

Retrieves ALL file(s) of a given form that are uploaded as part of form submission.

Retrieve ALL Files

Lookup Responses

Create an Empty Form

Duplicates an Existing Form

Update Dropdown, Multiple Choice or Ranking Question Options

Create Google BigQuery rows from new Typeform entries

Data analysis is important. With this automation, you can make analyzing data coming from forms easier. Each time someone responds to a Google Form, a row with the form data appears on a Google BigQuery table automatically. It's a simple way to make sure all your data gets dealt with.

Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!

Google Forms

Triggers when a new form response is received.

New Form Response

Triggers when a form response is added or modified.

New or Updated Form Response

Create Google BigQuery rows from new Google Forms responses

Move data from Unbounce to Google BigQuery seamlessly with this integration. When active, it turns Unbounce form submissions into data rows in a Google BigQuery table. Now, you can analyze data from leads, sales, and customers more efficiently.

Unbounce is a landing page platform that helps you convert more visitors into leads, sales, and customers. Unbounce Conversion Intelligence™ is AI powered-functionality that works with your marketing intuition to ensure the best campaign performance every time.

Unbounce

Triggers when a new Form Submission is received on a Landing Page, Overlay or Sticky Bar.

New Form Submission

Create Google BigQuery rows from new Unbounce form submissions

Do you analyze data you collect from your website forms? If so, this integration might be useful. It uses data from new Squarespace form submissions to create rows in a Google BigQuery table. With this integration set up, you'll be able to learn more about your leads and customers.

Squarespace is a website builder, blogging platform, hosting service, commerce platform, and domain name registrar.

Squarespace

Triggers when form submission is submitted.

Create Google BigQuery rows from new Squarespace form submissions

Data analysis is crucial to your company's success. But importing data is boring and time-consuming. The solution? This integration connecting Facebook and Google BigQuery. It detects new Facebook leads and turns them into rows of data in a Google BigQuery table. Start getting the insights you need without all the effort.

Facebook lead ads make signing up for business information easy for people and more valuable for businesses. The Facebook lead ad app is useful for marketers who want to automate actions on their leads.

Facebook Lead Ads

New Lead

Create Google BigQuery rows from new Facebook leads

Effortlessly track and manage your HubSpot deals by integrating them into your Google BigQuery database. With this automation, each time a new deal is created in HubSpot, it will seamlessly generate a corresponding row in Google BigQuery. This streamlined workflow ensures all your important deal data is up-to-date and organized, making it easier to analyze and maximize your sales performance.

HubSpot is your all-in-one stop for all of your marketing software needs.

HubSpot

New Company

New Contact

Triggers when a company recently created or updated.

Company Recently Created or Updated

Triggers when a contact recently created or updated.

Contact Recently Created or Updated

Triggers when a line_item recently created or updated.

Line_item Recently Created or Updated

Triggers when a product recently created or updated.

Product Recently Created or Updated

Triggers when new custom object is available.

New Custom Object

New Deal

Triggers when a specified property is provided or updated on a Deal.

Deal Property Change

Triggers when all, or some specific new email event is available.

New Email Event

Triggers when new email timeline subscription added for the portal.

Email Subscriptions Timeline

New Engagement

Triggers when new line_item is available.

New Line_item

Triggers when a calendar task is created. _(Marketing Hub Professional plans and above)_.

New Calendar Task

Triggers when a contact is added to the specified list.  _(Marketing Hub Starter plans and above)_.

5 ways to automate Google BigQuery with Zapier

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.