teaser
Albato Embedded, the AI-first iPaaS, is officially live on Product Hunt!Support our launchright

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
How to Connect Peerbie to Albato
3 min. read

How to Connect Peerbie to Albato

By linking Peerbie with Albato, you can automate your workflows and sync data across 800+ apps, including AI tools like ChatGPT and Claude.

How to Connect ElevenLabs to Albato
4 min. read

How to Connect ElevenLabs to Albato

By connecting ElevenLabs with Albato, you can integrate voice solutions into over 800+ apps, including AI tools.

How to Connect Softr to Albato
4 min. read

How to Connect Softr to Albato

By connecting Softr with Albato, you can automate data flows and integrate with over 800+ apps, including AI tools like ChatGPT and Claude.

How to Connect Cognito Forms to Albato
4 min. read

How to Connect Cognito Forms to Albato

By connecting Cognito Forms with Albato, you can automate form submissions, sync data across 800+ apps, including AI tools, and streamline your lead collection process.

How to Control AI Agents with Automation Flows
11 min. read

How to Control AI Agents with Automation Flows

In this article, you will learn how you can control AI agents with automation flows for low precision and high precision tasks.

How to Connect Passcreator to Albato
3 min. read

How to Connect Passcreator to Albato

By connecting Passcreator to Albato, you can automate your customer engagement and loyalty programs.

How to Connect Grist to Albato
3 min. read

How to Connect Grist to Albato

Connect Grist with other apps, including AI tools, using Albato, to automate your marketing tasks and streamline your data workflow.

Giftsenda Automates Mass Gifting with Albato Embedded
Embedded
3 min. read

Giftsenda Automates Mass Gifting with Albato Embedded

Giftsenda, the global gifting platform, has partnered with Albato to offer powerful embedded integrations that automate and effortlessly scale gifting.

Top 14 iPaaS Solutions for 2025: A Complete Guide to Integration Platforms
20 min. read

Top 14 iPaaS Solutions for 2025: A Complete Guide to Integration Platforms

Explore the top iPaaS solutions of 2025, including Boomi, Celigo, Tray.io, Workato, and Albato, with insights on features, pricing, and suitability for your business needs.

How to Connect ConvertBox to Albato
4 min. read

How to Connect ConvertBox to Albato

By connecting ConvertBox to Albato, you can automate lead and conversion workflows.

How to Connect ZenRows to Albato
4 min. read

How to Connect ZenRows to Albato

By connecting ZenRows to Albato, you can automate your data workflows and send parsed content directly to your preferred tools.

How to Connect NocoDB to Albato
4 min. read

How to Connect NocoDB to Albato

By connecting NocoDB with Albato, you can automate data updates and streamline internal processes.