Ever needed to get data from a Google Sheet into a database, Or share data from a DB to people who 'want the raw data'? DuckDB GSheets is a read/write SQL interface for Google Sheets. It's a community extension for DuckDB.
Hi Product Hunt,
I've so often been in the situation where non-technical folks in my organization want to interact with data in the database. Either they need to maintain and upload lookups with context they have in their heads, or they just want some kind of "data dump" either one time, or on a schedule.
DuckDB-GSheets is for this
Read data
SELECT * FROM 'https://docs.google.com/spreadsh...
Write data
COPY TO 'https://docs.google.com/spreadsh...' (FORMAT gsheet);
Hi Product Hunt,
I've so often been in the situation where non-technical folks in my organization want to interact with data in the database. Either they need to maintain and upload lookups with context they have in their heads, or they just want some kind of "data dump" either one time, or on a schedule.
DuckDB-GSheets is for this
Read data
SELECT * FROM 'https://docs.google.com/spreadsh...
Write data
COPY TO 'https://docs.google.com/spreadsh...' (FORMAT gsheet);
Evidence