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
Best Productivity Apps 2025 – Streamline Your Daily Tasks
13 min. read

Best Productivity Apps 2025 – Streamline Your Daily Tasks

In this article, you will learn about the top productivity apps—task managers, timers, note tools, and more—to streamline your daily workflow and boost efficiency in 2025.

How Email Marketing Automation Helps Boost Engagement
20 min. read

How Email Marketing Automation Helps Boost Engagement

In this article, you will learn how email marketing automation can increase engagement, save time, and deliver personalized content to your audience more effectively.

How Weeztix Scaled Native Integrations for 300+ Event Organizers with Albato Embedded
6 min. read

How Weeztix Scaled Native Integrations for 300+ Event Organizers with Albato Embedded

By embedding Albato, Weeztix made it way easier to integrate and automate workflows for hundreds of their event organizers.

Best Albato Use Cases for Marketing and Sales Automation
8 min. read

Best Albato Use Cases for Marketing and Sales Automation

In this article, you will learn about the best Albato use cases for marketing and sales automation. Learn how to streamline workflows, boost productivity, and drive growth.

How to Automate Contact Migration from Quickbase to Google Contacts Using Albato
7 min. read

How to Automate Contact Migration from Quickbase to Google Contacts Using Albato

With this setup, not only can you transfer your contact database from Quickbase to Google Contacts in bulk, but you can also keep those records updated in real time.

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.

Why CRM SMS Integration Matters to Your Business
5 min. read

Why CRM SMS Integration Matters to Your Business

In this article, you will learn why missed follow-ups happen so often, why CRM SMS integration solves the root of the problem, and what steps you can take to put your follow-up process on autopilot.

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.

How to Connect Property Finder to Albato
3 min. read

How to Connect Property Finder to Albato

Integrate Property Finder with Albato to connect it with over 800+ apps, including AI tools like Gemini and Grok.

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