Connect ClickHouse to Google Sheets and Automate Data Retrieval Process

Connect ClickHouse to Google Sheets
Reading Time: 3 minutes

Connect ClickHouse to Google Sheets and automatically import data from the ClickHouse data warehouse without any lines of code. This way you can not only perform a more microscopic analysis but also save a significant chunk of your time by eliminating manual tasks. And by automating the task, the chance of error is reduced.

Another benefit of connecting ClickHouse to Google Sheets is the ability to easily share the data and collaborate with team members and clients.

We can easily and quickly connect ClickHouse to Google Sheets using Amigo. Amigo is a Google Sheets add-on that lets us connect various data sources to Google Sheets and automate the data retrieval process. The installation link is given below.

Following are the steps to connect ClickHouse to Google Sheets and import ClickHouse data to Google Sheets.

Steps to connect ClickHouse to Google Sheets

Install the Amigo extension in Google Sheets

The Amigo add-on acts as a bridge allowing you to move data from ClickHouse to Google Sheets.

Get it from the Google Workspace Marketplace by clicking the link given below.

Amigo Data in Google Workspace Marketplace

Amigo installation link

Alternatively, you can get it from within Google Sheets itself.

  • Open a Google Sheets document
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo and install

Once the installation is complete, the Amigo add-on should appear in your Google Sheets Extensions list.

Connect ClickHouse to Google Sheets

Open Google Sheets and launch Amigo by clicking Extensions→Amigo: Data Exports and Reports→Connect.

Connecting to Amigo

From the list of available sources to connect select ClickHouse and click Import from Tables.

Select source to connect
Connect ClickHouse to Google Sheets

Import ClickHouse Data to Google Sheets

On the dashboard to the left is a list of data tables. Click on any one of them to preview.

List of data tables

All metrics will be selected automatically. Unselect those that you don’t require. And use the Filter and Sort options to filter and/or sort the report by one or more of the metrics.

Preview of the data

Name the report if you need to and then click the IMPORT button. After a few seconds the data from ClickHouse will be imported into Google Sheets.

Snippet of the imported data

If you want the data to be updated periodically, set a refresh schedule by clicking the Yes, set a refresh timing. Or you can set it up later. To learn more on how ot set a refresh schedule and set up alerts to receive the report in your inbox or Slack, click here.

Amigo can connect Google Sheets to multiple sources and allows you to import data automatically. It is a convenient and versatile tool to import and export data to Google Sheets. Visit our blog to discover more.

Some related articles you may find useful:
Importing MySQL Data to Google Sheets

Import Data From Amazon Redshift To Google Sheets

Export Data From Snowflake To Google Sheets

Transfer data from BigQuery to Google Sheets Automatically