Updated date:

Data Connectors: Connect to Google Sheets

Heng Kiong teaches Information Technology, including business analytics and management information systems, at a tertiary institute.

Sample Data

In order to learn Google Data Studio, you would need a data set to work with. By following the step-by-step guide provided in this tutorial, you will be able to create sample company Sales Reports with dummy data provided for you.

The YHK Store Sample Data is made possible using free online text and number generator tools.


http://random-date-generator.com/

https://www.random.org/

YHK Store Sample Data

connect-to-google-sheets

Download YHK Store Sample Sales Data

Copy This Google Sheet Data File To Your Google Account

Make a copy of this YHK Store Sample Data and store it under the same Google Account which you will be using for Google Data Sheet later.

What's In The Data?

  • Transaction ID – Sale Transaction Number generated by the Company. There are total 3000 transactions in the data
  • Order Date – Date the order was made by the customer
  • Customer – Customer’s name on the order.
  • Deliver To – State the Country of Delivery
  • Sales Representative – Sales representatives working at YHK Store
  • Item – Item the customer ordered
  • Quantity – Quantity of the item ordered

Prepare Your Data

Cells should only contain data

The first row of the data should contain column headers

How to connect to Google Sheets?

The first step in creating a data source is to establish a connection with the data in Google Sheets.

After you have signed in to Google Data Studio, click on CREATE on the Top Left Corner.


Create button

connect-to-google-sheets

Create Data Source

Choose Create Data Source

Choose Create Data Source

Choose Google Sheets as your Google Data Connector

Choose Google Sheets As Your Data Connector

Choose Google Sheets As Your Data Connector

Choose and type an appropriate name for this Data Set. Browse to the YHK Store Sample Data which you have downloaded under your own Google Account

connect-to-google-sheets

Ensure <Use First Row As Headers> and <Include Hidden and Filtered Cells" are checked.

connect-to-google-sheets

Next, click on CONNECT at the Top Right corner. You should now see a table like the one below.

connect-to-google-sheets

Check to ensure that Google Data Studio has correctly identified the data type for each field. Usually data types which require amendments or corrections are "Country", "Date" and "Currency".

Once everything is in order, click on the "CREATE REPORT" button.

Add Data to Report

connect-to-google-sheets

Click ADD TO REPORT to continue.

Congratulations, you have successfully connected to the YHK Store Sample Data. Read on to find out how you can create your first Visualisation Report.

Navigation

Learn How to Use Google Data Studio to Visualise Data Easily

Google Data Studio - Getting Started

Data Connectors - Connect to Google Sheets

Your First Visualisation Report using Google Data Studio

Richer Interactive in Google Data Studio

About Filter Control In Google Data Studio

Using Charts as Interactive Filters in Google Data Studio

Managing Data Sources in Google Data Studio

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2020 Heng Kiong Yap