How to share data with Google BigQuery

How to share data with Google BigQuery
Google BigQuery
·
1/26/2022
·
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 Is an iPaaS? All About Integration Platform as a Service
Embedded
5 min. read

What Is an iPaaS? All About Integration Platform as a Service

An iPaaS is an integration platform as a service that helps businesses connect applications, data, and systems seamlessly for streamlined workflows.

Connect Digital Samba with Albato | Elevate Your Webinar Experiences
3 min. read

Connect Digital Samba with Albato | Elevate Your Webinar Experiences

Digital Samba is a powerful platform for hosting and managing webinars, designed with user-friendly features and scalability in mind. See how Albato can help you enhance the app’s usability!

Connect Intento with Your Favorite Apps | Optimize Your Translations with Albato
3 min. read

Connect Intento with Your Favorite Apps | Optimize Your Translations with Albato

Intento is an AI-powered platform for managing multilingual content and optimizing translation workflows. See how Albato can help you enhance the app’s usability!

How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide
4 min. read

How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide

Learn how to set up ClickUp integrations with Albato in our step-by-step guide. Unlock powerful ClickUp integrations & automate workflows to boost productivity.

Integrate Ortto with 800+ Apps | Enhance Your Marketing Automation with Albato
3 min. read

Integrate Ortto with 800+ Apps | Enhance Your Marketing Automation with Albato

Ortto redefines the landscape of marketing automation with its intuitive service that simplifies email marketing, customer journey mapping, and targeted messaging. See how Albato can help you enhance the app’s usability!

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato
4 min. read

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato

Zendesk offers a comprehensive customer service solution, designed for ease of use and scalability. See how Albato can help you enhance the app’s usability!

How to use Claude Artifacts: 7 Ways with examples | Guide 2025
Claude AI
10 min. read

How to use Claude Artifacts: 7 Ways with examples | Guide 2025

Learn how to use Claude Artifacts with our detailed guide. Explore 7 best ways with real Artifact examples: web pages, prototypes, presentations and visualizations.

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato
3 min. read

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato

Gumlet is best way to stream ad-free videos on internet. It has powerful CMS to organise videos and hollywood grade DRM. See how Albato can help you enhance the app’s usability!

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy
3 min. read

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy

With Octopush, businesses are well equipped to propel their brand, promote their offers and services at scale. See how Albato can help you enhance the app’s usability!

Connect DocuSign with 800+ Apps | Simplify Document Management on Albato
3 min. read

Connect DocuSign with 800+ Apps | Simplify Document Management on Albato

DocuSign is a top electronic signature and digital transaction management platform, helping organizations manage contracts and agreements securely and efficiently. See how Albato can help you enhance the app’s usability!

Chili Piper Alternatives 2024: Top 6 Scheduling & Lead Management Tools
CalendarHero
4 min. read

Chili Piper Alternatives 2024: Top 6 Scheduling & Lead Management Tools

Discover the top 6 Chili Piper alternatives for scheduling and lead management. Compare features, pros & cons of Calendly, Dashly, Cal.com & more. Find the best fit for your business.

Customer Service Skills: Essential Guide to Handling Discount Requests
1 min. read

Customer Service Skills: Essential Guide to Handling Discount Requests

Learn essential customer service skills for handling different types of discount requests. Discover proven strategies for maintaining customer loyalty while protecting your business interests.