Share data with Google BigQuery

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

In this article

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

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
5 Ways to Automate Claude with Albato
4 min. read

5 Ways to Automate Claude with Albato

In this article, you will learn five practical ways to connect and automate Claude AI with Albato. Learn how to boost workflows, integrate apps, and streamline business tasks.

5 Best No-Code Web Scrapers For Online Businesses
6 min. read

5 Best No-Code Web Scrapers For Online Businesses

Discover 5 top no-code web scrapers for online businesses. Automate competitor tracking, SEO monitoring, and market research without coding.

State of Integrations Report 2025: Key Trends and Strategic Insights
5 min. read

State of Integrations Report 2025: Key Trends and Strategic Insights

In this report, you will learn about the 2025 state of integrations in 2025 with data, trends, and recommendations. Learn how businesses can leverage integrations to boost efficiency and stay competitive.

Zapier vs. Make vs Albato: Full Comparison
6 min. read

Zapier vs. Make vs Albato: Full Comparison

In this article, you will learn how Zapier, Make, and Albato compare to each other to see which SaaS automation platform suits your needs. Explore capabilities, pricing, features, and use cases.

Our Automation Builder Has Just Leveled Up
3 min. read

Our Automation Builder Has Just Leveled Up

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

Best Accounting Apps to Manage Your Business Finances
7 min. read

Best Accounting Apps to Manage Your Business Finances

In this article, you will learn about the top accounting apps like Sage, QuickBooks, Zoho Books, and more to simplify bookkeeping, automate workflows, and grow your business.

How to Connect LinkDeal to Albato
3 min. read

How to Connect LinkDeal to Albato

Connect LinkDeal with Albato to integrate it with over 800+ apps, including AI tools like Grok and Gemini.

How to Connect Workday to Albato
5 min. read

How to Connect Workday to Albato

Connect Workday with Albato to integrate it with over 1000+ apps, including AI tools like Grok and Claude.

How to Connect DeepL to Albato
5 min. read

How to Connect DeepL to Albato

Connect DeepL with Albato to integrate it with over 1000+ apps.

How to Connect Mobilo to Albato
5 min. read

How to Connect Mobilo to Albato

Connect Mobilo with Albato to integrate it with over 1000+ apps, including AI tools like Grok and Claude.

How to Connect Utalk to Albato
5 min. read

How to Connect Utalk to Albato

Connect Utalk with Albato to integrate it with over 1000+ apps, including AI tools like Grok and Claude.

How to Connect DeepSeek to Albato
4 min. read

How to Connect DeepSeek to Albato

Connect DeepSeek with Albato to integrate it with over 1000+ apps.