Easy analysis sharing with re: dash, an open source data visualization tool Part 3 ~ Google Spreadsheets

• Easy analysis sharing with re: dash, an open source data visualization tool Part 1-Installation
• Easy analysis sharing with re: dash, an open source data visualization tool Part 2 ~ Graph
• Easy analysis sharing with re: dash, an open source data visualization tool Part 3 ~ Google Spreadsheets
• Easy analysis sharing with re: dash, an open source data visualization tool Part 4 ~ pivot table

Until the last time, it was connected to MySQL, but this time I will connect it to Google Spreadsheets

How Google Spreadsheets can be handled with re: dash

There is a document in here, but in re: dash from Google Spreadsheets using python modules gspread and oauth2client I'm getting the data.

Procedure outline

1. Create a project in Google Developer Console
2. Issuance of Service account key
3. Enable the API
4. Creating a Google Spreadsheets data source
5. Prepare the dataset and give it to Google Spreadsheets
6. Visualization

Create a project in the Google Developer Console

To connect from re: dash to Google Spreadsheets, you need to issue a Service account key from the Google Developer Console.

First, create a project. This time I named it redash-sample.

Issuance of Service account key

Next, issue a Service account key in the API menu. This procedure will eventually download the json format file. Save it in a suitable location as you will use it later.

Enable API

Next, find the Drive API from Overview and set it to enalbed.

Creating a data source for Google Spreadsheets

Create as follows

Prepare a dataset and give it to Google Spreadsheets

Middle classification index (January 1970) on the page of 2010 Consumer Price Index ~ Latest month) is downloaded by csv and posted on Google Spreadsheet.

After that, format the data as follows. I changed A1 because I thought that YYYYMM would be more appropriate.

Then share this to the email inside the json of your Service account key

Visualization

The URL of Google Spreadsheet is as follows.

At that time, enter the following in the value created by New Query. You can separate the "key in the URL" and the "spreadsheet number (starting with 0)" with a "|".

With proper visualization, it looks like this: On the other hand, the rent is going down, isn't it?

Summary

I got the data of Google Spreadsheets with re: dash and went to visualization. It seems that it is possible to import Google Analytics with Google Spreadsheets and visualize it with re: dash. The downside is that Spreadsheets load slowly. When I used it this time, it took more than 20 seconds to import.