duckdb_gsheets
DuckDB extension to read and write Google Sheets using SQL
AI Summary
DuckDB GSheets
A DuckDB extension that enables reading and writing Google Sheets using SQL.
Target Users
Intermediate to advanced data engineers and analysts who leverage SQL and DuckDB for analytics and need automated integration with Google Sheets data.
Problems Solved
Importing Google Sheets data into analytical workflows usually requires custom API integrations or ETL, adding complexity and maintenance overhead.
Tags
Main Features
Direct SQL Read/Write
The `read_gsheet` function and `COPY ... TO` syntax let users treat Google Sheets like any other table or file accessible from DuckDB.
Multiple Authentication Methods
Supports browser-based OAuth, access tokens, and service-account key files, making the extension usable in both interactive sessions and automated pipelines.
Flexible Write Options
Provides options for sheet and range selection, overwrite vs. append behavior, and header control when writing data back to Google Sheets.
Usage Examples
Due to the lack of public information on Google Apps Script integration, a runnable GAS code example cannot be provided.