CODEWITHSUNDEEP
c#pythonnode.jsgoogle-apigoogle-sheets-api
Delgado
Delgado

Reputation: 47

Syncing Google Sheets with a database

Does anyone know if there is a way to have google sheets run from a database like Oracle, Microsoft SQL, etc.? When the values in the database table(s) are updated, the spreadsheet will show those changes the next time it's opened. Also, possibly writing back to the DB. Is this possible? Any suggestions?

Thanks,

Upvotes: 0

Views: 3777

Answers (2)

howMuchCheeseIsTooMuchCheese
howMuchCheeseIsTooMuchCheese

Reputation: 1780

I've had trouble with this before so I built a solution in case you don't want to roll your own. SeekWell lets you automatically send data from SQL to Sheets and can also sync changes from Sheets back to a database. Apps Script can do pieces of this, but I found it buggy and limited for our use case, so built something else. There are both free and paid plans.

Upvotes: 1

MαπμQμαπkγVπ.0
MαπμQμαπkγVπ.0

Reputation: 6737

You can use Apps Script to connect to external database through JDBC Services.

In Apps Script, the JDBC service supports Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle databases.

Just follow the procedure specified in the documentation.

There is also a provided sample on how to:

Upvotes: 0

Related Questions