Image for post
Image for post

Connecting Google Sheets → BigQuery → Google Data Studio

The NoOps analysis workflow for non-technical teams

Sam Thurman
Dec 22, 2020 · 10 min read

Overview

Introduction

Advantages of this workflow:

Steps We’ll Follow

The Process

project-name/
dataset-for-project/
table1/ (this will be our Google Sheet, could be anything)
...
table2/
...

Log into BigQuery and navigate to Cloud Console

Image for post
Image for post

Create a new project

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Enable BigQuery Connection API

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Create a new dataset

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Connect your Google Sheet as a table

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Log into Google Data Studio

Image for post
Image for post

Create a new data source, connect our data using BigQuery connector

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Use data in a report

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Fin

The Startup

Medium's largest active publication, followed by +775K people. Follow to join our community.

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store