Show HN: Query Google Sheet data using PostgreSQL clients

Re:Show HN: Query Google Sheet data using PostgreSQL clients by hbarka on Tuesday May 31, 2022 @02:05AM (#31566558)

I spent years using Excel but I mostly use Google Sheets now. The cloud integration just feels much more effortless compared to Microsoft’s Office products ported to cloud. I’ve seen departments using GS as a system of record for quickly setting up master data like budgets and forecasts. I wish it had database connectivity the way Excel has ODBC.

[ Parent | on HN ]

Re:Show HN: Query Google Sheet data using PostgreSQL clients by mritchie712 on Tuesday May 31, 2022 @06:42AM (#31567991)

I founded https://seekwell.io/ because I had that same wish a few years backs.

Also worth checking out https://equals.app/

[ Parent | on HN ]

Re:Show HN: Query Google Sheet data using PostgreSQL clients by silvershell on Tuesday May 31, 2022 @11:20AM (#31570557)

Seekwell.io is giving me a 502 Error as of now.

[ Parent | on HN ]

Re:Show HN: Query Google Sheet data using PostgreSQL clients by mritchie712 on Tuesday May 31, 2022 @12:16PM (#31571365)

weird, GCP might have been down a moment? Is it working now?

[ Parent | on HN ]

Re:Show HN: Query Google Sheet data using PostgreSQL clients by cocothem on Tuesday May 31, 2022 @07:04AM (#31568160)

Have you looked at connected sheets? https://cloud.google.com/bigquery/docs/connected-sheets

[ Parent | on HN ]

Re:Show HN: Query Google Sheet data using PostgreSQL clients by hbarka on Wednesday June 01, 2022 @11:03AM (#31582848)

That article describes how to use GS as a front end for BigQuery data. I’m describing the opposite, which is ingesting spreadsheet data into databases.

[ Parent | on HN ]