Share data with Google BigQuery

How to share data with Google BigQuery
Google BigQuery
·
12/9/2021
·
3 min. read

In this tutorial, you will learn how to share data with Google BigQuery on example with Google Sheets and Google BigQuery automation scenario. You can also transfer data to Google BigQuery from various systems.

Connect the app

Firstly, set up the BigQuery connection. In this case, we need only one Google connection. Go the Apps section and click the Add a connection button. Select Google BigQuery from the list and click «Add a connection» button. 

Create your own name and click the «Continue» button. The next step is to grant Albato access to your Google account.

If the data is not loaded for some reason, click the «Update» button or «Grant access to Albato».

IMPORTANT!!! Make sure Google BigQuery is ready to receive your data. For the automation to work successfully, we need to add Project, Data Set, Table to Google BigQuery. Adding these elements is beyond article.

For example, look on the screenshot:

Create an automation

Secondly, we create an automation. Open the Automations page and click the New button.

Step 1.  Select Google Sheets to send the data from and the «New sheet row» event.  Specify your connection, the spreadsheet and the sheet to take the data.

Click «Continue» button.

Step 2.  Select BigQuery,  «Insert Rows» action and your connection. Please notice, that three blocks highlighted on the screenshot can be filled with data only if they are set up and connected correctly in BigQuery. If you do not see your data, click the «Update» button. After updating, you will be able to select the required options.

Click «Continue» button.

Step 3. Now we need to fill in the fields. In our example, we are matching columns from Google BigQuery spreadsheet to columns from Google Sheets.

The field «Skip invalid rows» has two values: Yes (1) and No (0). This setting affect the readability of the data.

The fields that are highlighted in red Albato takes from the BigQuery spreadsheet settings, so the user’s task is to match them with the data from his Google Sheets.

Then click the «Continue» button and you will get the following result:

pub-img-7765-9.png

The automation is ready! You can start it now.

Now you know how to send information to a scalable and flexible database using the automation example of Google Sheets + Google BigQuery.


Google BigQuery

Related articles

Show more
We’re Celebrating a Big Win!
2 min. read

We’re Celebrating a Big Win!

Explore what’s new in Albato: features, apps, and improvements

How to Automate Blog Creation from Google Sheets Using OpenAI
8 min. read

How to Automate Blog Creation from Google Sheets Using OpenAI

With this Solution, every new row in a designated Google Sheet triggers a series of actions to create SEO-friendly blog content, generate images, and notify your team—without writing a single line of code.

Best Workflow Management Software for Teams 2025
11 min. read

Best Workflow Management Software for Teams 2025

In this article, you will learn the top workflow management tools to boost team efficiency. Compare features, pricing, and find the perfect fit for your team.

Tired of Missed Follow-Ups? Here’s Why CRM SMS Integration Matters
5 min. read

Tired of Missed Follow-Ups? Here’s Why CRM SMS Integration Matters

This article breaks down why missed follow-ups happen so often, how CRM SMS integration solves the root of the problem, and what steps you can take to put your follow-up process on autopilot without losing the human touch.

What Tools To Connect to OpenAI with Albato
3 min. read

What Tools To Connect to OpenAI with Albato

In this article, you will learn what tools you can connect to ChatGPT(Open AI) with Albato to set up automated workflows for different use cases.

Artificial Intelligence Automation for Lead scoring, Sales, Marketing & Content
8 min. read

Artificial Intelligence Automation for Lead scoring, Sales, Marketing & Content

In this article, you will learn how to use AI and AI agents to automate your business processes. Discover top tools, benefits, and implementation strategies in this 2025 guide

How to Connect Fomo to Albato
4 min. read

How to Connect Fomo to Albato

Connect Fomo with Albato and sync your data with 800+ apps, including AI tools like ChatGPT and Gemini. This integration will help you to automate marketing campaigns, personalize user experiences, and boost engagement.

How to Connect Reply.io to Albato
4 min. read

How to Connect Reply.io to Albato

Connect Reply.io with Albato to integrate it with over 800+ apps, including AI tools like Grok and Claude. Follow the steps below to set it up.

How to Connect EventMobi to Albato
4 min. read

How to Connect EventMobi to Albato

Connect EventMobi with Albato and sync your data with 800+ apps. This integration will help you to automate event planning, guest management, and customer communication workflows.

Top LinkedIn Automation Tools for 2025
20 min. read

Top LinkedIn Automation Tools for 2025

Discover the best LinkedIn automation tools to boost your outreach and lead generation efforts in 2025.

How to Connect MixMax to Albato
4 min. read

How to Connect MixMax to Albato

By connecting Mixmax with Albato, you can sync data across 800+ apps, including AI tools like Grok and Claude.

How to Connect Teachable to Albato
3 min. read

How to Connect Teachable to Albato

By connecting Teachable with Albato, you can automate data syncing across 800+ apps, including AI tools like Gemini and Claude.