Sheet to BigQuery

🚀A few clicks to have your Google Sheet in BigQuery

BEFORE

Your Google Sheet

🪄AFTER

Table in BigQuery

How to put Google Sheet's data to BigQuery table

🚀 Dear Business Leaders,

In today's business landscape, data isn't just a component; it’s the foundation upon which we build our decisions and strategies. It’s the compass that guides us through the operational maze. 

The question: 

But how do we interpret this data accurately? How do we make it not just numbers and charts, but actionable intelligence that drives results?

The solution

 With our revolutionary Cooltables add-on, the answer to your problems is as easy as 1-2-3. 

 1️⃣ Send your important information housed in Google Sheets to Google BigQuery, handoff is done here. 

 How? 

A) Install the add-on from the Marketplace

1

Choose sheet to upload

2

Set BigQuery endpoints:

3. Load!

Finally, click the button:

Detailed Instruction

1. Click on the direct link to the Cooltables add-on installation screen.

2. Confirm the installation by clicking on 'Install'.

3. Open the Google sheet where you intend to use the add-on.

4. Click 'Extensions' at the top menu, navigate to 'Cooltables', and then click on 'Show Sidebar'.

5. In the open sidebar, navigate to the 'Add Task' tab.

6. Select 'Sheet to BigQuery'.

7. Select a sheet and the details of your Google BigQuery destination, then click 'Run'.

After the task runs successfully, the data from Google Sheet will be loaded into your BigQuery. Remember to check the 'Home' tab in the Cooltables add-on for the list of your tasks. You can rename, re-run tasks, and see task statistics.

Watch the video-tutorial