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
What Are the Best iPaaS Tools for Seamless Connectivity
3 min. read

What Are the Best iPaaS Tools for Seamless Connectivity

In this article, you'll find the breakdown of the best iPaaS tools for seamless connectivity that will help you make an informed choice about what's best for your business.

How to Connect FormCan to Albato
3 min. read

How to Connect FormCan to Albato

By connecting FormCam to Albato, you can streamline data flows from form submissions to your favorite business apps.

Chatfuel Cuts Churn by 25% and Integration Time by 80% with Albato Embedded
Press Releases
3 min. read

Chatfuel Cuts Churn by 25% and Integration Time by 80% with Albato Embedded

Chatfuel, a leading US-based B2B messaging platform with AI agents, has partnered with Albato Embedded to deliver seamless native integrations, significantly improving user experience and operational efficiency.

Model Context Protocol: Understanding the Future of Automations
7 min. read

Model Context Protocol: Understanding the Future of Automations

In this article, you will learn how Model Context Protocol helps connect AI tools, data sources, and workflows across SaaS apps—no code required.

How to Connect to Care. With Albato
3 min. read

How to Connect to Care. With Albato

By utilizing both Care. and Albato, you can automate routine tasks like job post updates, applicant tracking, and communication management—saving time and reducing manual effort.

How to Connect Keen to Albato
3 min. read

How to Connect Keen to Albato

Here’s a simple guide to help you connect Keen with Albato and automate your lead management workflows.

VoiceDrop and Albato Join Forces to Enhance Ringless Voicemail Integrations
Press Releases
3 min. read

VoiceDrop and Albato Join Forces to Enhance Ringless Voicemail Integrations

VoiceDrop, the #1 fastest-growing AI-powered ringless voicemail platform, has partnered with Albato Embedded to offer native, customer-facing integrations directly within their platform.

How to Connect Drip to Albato
3 min. read

How to Connect Drip to Albato

Create integrations with Drip in Albato to automate email marketing, personalize customer journeys, and keep your contact data in sync.

How to Connect OneDrive to Albato
3 min. read

How to Connect OneDrive to Albato

By connecting OneDrive to Albato, you can automate file organization, synchronize data across applications, and optimize your workflows.

How to Connnect to Forms.app via Webhook
3 min. read

How to Connnect to Forms.app via Webhook

Create integrations with Forms.app in Albato to automate form submissions, streamline response management, and connect your form data with the tools you already use.

Enterprise AI Strategy: Practical Ways to Integrate AI into Your Workflows
10 min. read

Enterprise AI Strategy: Practical Ways to Integrate AI into Your Workflows

Discover best practices for building a successful enterprise AI strategy and see how Albato can help you in this process.

Want to Learn Automation Tricks?
2 min. read

Want to Learn Automation Tricks?

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