Show HN: Query Google Sheet data using PostgreSQL clients • Hacker News Board

Re: Show HN: Query Google Sheet data using PostgreSQL clients

#21

Post by mritchie712 » Tue, May 31, 2022, 4:16 PM UTC

silvershell wrote: post #20

mritchie712 wrote: post #16

Earlier quoted context omitted.

I founded https://seekwell.io/ because I had that same wish a few years backs. Also worth checking out https://equals.app/

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

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

Re: Show HN: Query Google Sheet data using PostgreSQL clients

#22

Post by jdonaldson » Tue, May 31, 2022, 4:21 PM UTC

Using this with materialized views could be very useful!

Re: Show HN: Query Google Sheet data using PostgreSQL clients

#23

Post by Aaronstotle » Tue, May 31, 2022, 4:35 PM UTC

nathanwallace wrote: post #17

Steampipe [1] is an open source Postgres Foreign Data Wrapper with 73 plugins [2] including Google Sheets support [3]. A lot of our users use it to connect custom metadata with other systems - e.g. join ownership info in Google Sheets with tags on AWS resources. Notes: I'm a lead on the project, it's focused on read only. 1 - https://steampipe.io 2 - https://hub.steampipe.io/plugins 3 - https://hub.steampipe.io/plugi…

unrelated: I used steampipe to easily automate some compliance audits on AWS, was great to do be able to look at all s3 buckets and make sure they're encrypted.

Re: Show HN: Query Google Sheet data using PostgreSQL clients

#24

Post by hbarka » Wed, Jun 01, 2022, 3:03 PM UTC

cocothem wrote: post #18

hbarka wrote: post #2

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.

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

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.