DuckDB GSheets
Read and write Google Sheets in pure SQL
Listed in categories:
GitHubData & AnalyticsSpreadsheets
Description
DuckDB GSheets is an experimental extension that allows users to read and write Google Sheets using SQL commands. It provides a seamless integration between DuckDB and Google Sheets, enabling users to manipulate spreadsheet data directly through SQL queries.
How to use DuckDB GSheets?
To use DuckDB GSheets, install the extension, authenticate with your Google account, and use SQL commands to read from or write to Google Sheets. Follow the setup guide to create a Google API access token and share your Google Sheet with the service account email.
Core features of DuckDB GSheets:
1️⃣
Read Google Sheets by full URL or spreadsheet ID
2️⃣
Write data to Google Sheets from DuckDB tables
3️⃣
Support for reading specific sheets by name or ID
4️⃣
Authentication via Google API access token
5️⃣
Community-maintained extension with ongoing updates
Why could be used DuckDB GSheets?
| # | Use case | Status | |
|---|---|---|---|
| # 1 | Data analysis using SQL queries on Google Sheets data | ✅ | |
| # 2 | Automating data entry into Google Sheets from DuckDB | ✅ | |
| # 3 | Integrating Google Sheets data into larger data workflows | ✅ | |
Who developed DuckDB GSheets?
DuckDB GSheets is a community-driven project maintained by Evidence, aimed at enhancing the functionality of DuckDB by integrating it with Google Sheets for easier data manipulation and analysis.