How to connect Google Sheets to a database hosted on Google Cloud

[DUOTOHIRE]

Hi,

In the past I used to connect ms excel sheets to any DB via OleDB drivers and used Msquery to edit my sql queries and get results into my sheet...

From now I would like to do the same thing into a Google environment

So I ve setup a mysql db on Google Cloud (Postgres and mssql are also possible choices)

But Ive tried to install MySQL Workbench on a debian partition on my chromebook with NO  success !

So Someone could help me to find the right way to : 

- be able to upload csv data files into any database

- be able to host this DB on Google Cloud

- be able to write SQL query from any tools

- andable to get query results into my google data sheets

Any tuto or video would be much appreciated

Cheers

[mcbsalceda]

Hi @DUOTOHIRE,

Welcome to Google Cloud Community!

You might want to check out Google Cloud’s integration connectors and Connected Sheets.

With Google Cloud, you can easily link your MySQL, Postgres, or MSSQL databases to Google Sheets using Connected Sheets. This lets you run SQL queries directly from Sheets and pull in the results without all the extra hassle. It’s a pretty seamless way to get data into your Google Sheets from your cloud databases.

To upload CSV files into your database, you can use tools like BigQuery. They have built-in features for importing data, making it easier to manage. Plus, you can run SQL queries and import the results straight into Sheets—no complicated setup required.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.