Connect ClickHouse to Google Sheets and Automatically Export Data

Connect ClickHouse to Google Sheets
Reading Time: 5 minutes

Connect ClickHouse to Google Sheets and automatically export data from the ClickHouse data warehouse without any lines of code. This way you can not only perform a more microscopic analysis and generate insights from your data but also save a significant chunk of your time by eliminating manual tasks. And by automating the task, the chance of error is significantly 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. With Amigo we can integrate ClickHouse and Google Sheets from the web (also possible with the Amigo addon) without any coding. And after creating a ClickHouse and Google Sheets, we can easily and automatically pull data from ClickHouse to Google Sheets.

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

How to connect ClickHouse to Google Sheets

Below are the steps to connect ClickHouse to Google Sheets and export ClickHouse data to Google Sheets.

Connect ClickHouse to Google Sheets

Log in to Amigo. Sign in with your Google account.

Sign in to Amigo to connect ClickHouse to Google Sheets

Add a ClickHouse-Google Sheets connection by clicking “Create new connections”.

Add a new ClickHouse and Google Sheets connection

Select ClickHouse from the sources list to create a ClickHouse and Google Sheets integration.

Select ClickHouse to connect to Google Sheets

Enter the ClickHouse credentials and click “Connect” to connect ClickHouse to Google Sheets.

Enter the ClickHouse credentials to connect ClickHouse to Google Sheets

On clicking “Connect”, a ClickHouse and Google Sheets integration will be created. If the connection is successful, it will show up on the connections dashboard.

Export ClickHouse data to Google Sheets

There are two ways you can export data from ClickHosue to Google Sheets. One is a no-code method that allows users to move data easily and quickly from ClickHouse to Google Sheets directly from tables. The other is more versatile but also more technical. It uses SQL to retrieve data from single or multiple tables from ClickHouse to Google Sheets. Both methods are covered in the subsequent sections.

We’ll start with the non-code method to export data from ClickHouse to Google Sheets.

No-code data export from ClickHouse to Google Sheets

Click the connection you’ve created.

Click the ClickHouse and Google Sheets connection to export ClickHouse data to Google Sheets

Choose whether to export from table or using SQL query. Click “Import from Tables”.

Exporting ClickHouse data to Google Sheets from tables

Select the table from which to export ClickHouse data to Google Sheets.

Tables to export ClickHouse data to Google Sheets

Be default all metrics are selected. Unselect the metrics to omit; or simply uncheck the “Select all” option and select the metrics you want to export.

Metrics for the selected ClickHouse table

Then set the row limit. The row limit is set to 50 by default. Name the report. And then click “Import to Google Sheets” to pull the ClickHouse data to Google Sheets.

Exporting the ClickHouse data to Google Sheets

If you’re using Amigo for the first time you need to connect Amigo to Google Drive to export the data to Google Sheets (you can also connect to multiple accounts). Add a connection to export the ClickHouse data to Google Sheets.

Snippet of the data exported from ClickHosue to Google Sheets
The exported data

Export ClickHouse data to Google Sheets using SQL query

On clicking the ClickHouse Google Sheets connection you’ve created, you’ll be presented with an option to export from tables or with a custom SQL query. If you don’t see the SQL query option, click this link and select the connection.

Export ClickHouse data to Google Sheets using SQL query

Clicking the SQL query option takes you to a page where you can enter the SQL query to extract ClickHouse data and export to Google Sheets.

Example SQL query to retrieve ClickHouse data

Enter the SQL query and click “Run” to preview the data. Then click “Import to Google Sheets” to export the ClickHouse data to Google Sheets. You can export the data to the Google account that you have connected previously or add a new account.

Bonus:

Automate data exports from ClickHouse to Google Sheets

Amigo can automatically update the exported data regularly–hourly, daily, weekly, or on certain days of the week. This option is not yet available on the web version however. So you’ll have to use the Amigo addon in Google Sheets. You can get it from the Google Workspace Marketplace. Click here to install the Amigo add-on.

Get alerts of the ClickHouse data exported to Google Sheets

If you want to get the exported data sent to your email or Slack, you can set up an alert and add the email addresses of all the people you want to share the data with and the Slack channels to which you want the alert to be sent. Then Amigo will update you and your team with the latest data. This feature is also, for now, only available with the add-on.

Click this link to learn more about how to set a refresh schedule and create an alert.

Amigo can connect Google Sheets to multiple sources and allows you to export 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

Leave a Reply