e.preventDefault(); // Prevent form submission input.blur(); // remove focus input.value = ""; // optional: clear the input

How to Pull Data from Google Spreadsheets in Redash and Create Chart?

Basics of Redash

Redash is an open source data visual image tool for Business Analysts to query, visualize and collaborate. Redash is fast to line up and works with any data source you might need so you can query from anyplace in no time. Redash was engineered to permit quick and straightforward access to billions of records. Redash supports querying of multiple databases as well as Google Spreadsheets. In this blog, you will learn how to pull data from Google Spreadsheets in Redash and visualize your business data.

Steps to pull data from Google Spreadsheets in Redash

  1. Create a Google Service Account
  2. Write a query
  3. Add visualization

To add the Google sheets as an information supply to Redash you initially need to produce a Google Service Account

  • Open the API Credentials page
  • Click the “Create Credentials” button
  • Create a project
  • For Project role; choose Project > Viewer
  • Under key type, choose JSON and click on “create”
  • After this JSON file will be downloaded
  • In Redash add a new data source for Google Spreadsheets. Name the test connection and upload JSON file
  • After setting up the data source, you can load the spreadsheets into Redash. Share the spreadsheets with the service account’s email address
  • An email address can be found in the Google Sheets API Credentials page. After sharing the spreadsheet with your service account email address create a new query in Redash
  • In query editor text box, enter your Spreadsheet ID and execute the query
  • Add visualizations and customize it in line with the requirement like a Bar chart, Pie Chart, etc

Learn here the basic steps to configure Redash on AWS server (EC2 Instance)

Related Posts

Latest Posts

  • All Posts
  • Generative AI
  • manufacturing
  • News
  • Portfolio
    •   Back
    • Android
    • iOS
    • Java
    • PHP
    • MEAN
    • Ruby
    • DotNet
    • IoT
    • Cloud
    • Testing
    • Roku
    • CMS
    • Python

India

Plot No. 11/2, Phase 3, Hinjewadi Rajiv Gandhi Infotech Park, Pune, India – 411057.
info@tudip.com
+91-96-8990-0537

United States

1999 S. Bascom Ave Suite 700, Campbell CA. 95008, USA.
info@tudip.com
+1-408-216-8162

Canada

64 Caracas Road North York, Toronto Ontario M2K 1B1, Canada.
info@tudip.com

Mexico

Calle Amado Nervo #785 Interior B Colonia Ladron De Guevara 44600 Guadalajara, Jalisco, Mexico.
info@tudip.com

Colombia

Cra. 9 # 113-53 Of. 1405 Bogotá D.C., Colombia.
info@tudip.com

UAE

Tudip Information Technologies L.L.C Office No 109, ABU HAIL BUILDING 13, Abu Hail, Dubai, UAE.
info@tudip.com

Nigeria

22 Kumasi Crescent, Wuse 2, Abuja, Nigeria.
info@tudip.com