Search code examples
postgresqlgoogle-apps-scriptgoogle-cloud-sql

Trying to connect to connect Google Sheet script to a Postgres Google Cloud SQL instance


I'm writing a script to connect a Google sheet to GCP Postgres instance, unfortunately I only see documentation for MySQL. Do you know if there is support for Google scripting/Postgres integration?

Thanks.


Solution

  • Google Apps Script has JDBC connectors but they do not have support for Postgres as yet.

    Currently Apps Script's JDBC connectors only support Cloud SQL(MySQL), MySQL, MSSQL, and Oracle databases as listed in the opening paragraph of the JDBC documentation.