TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

DuckDB-GSheets: Read and Write Google Sheets in Pure SQL

11 pointsby archiewood7 months ago

1 comment

archiewood7 months ago
DuckDB GSheets is a DuckDB extension that allows you to read and write data from Google Sheets.<p>-- Install<p>install gsheets from community;<p>load gsheets;<p>-- Authenticate with the browser<p>create secret (type gsheet);<p>-- Read<p>select * from &#x27;<a href="https:&#x2F;&#x2F;docs.google.com&#x2F;spreadsheets&#x2F;d&#x2F;11QdEasMWbETbFVxry-SsD8jVcdYIT1zBQszcF84MdE8" rel="nofollow">https:&#x2F;&#x2F;docs.google.com&#x2F;spreadsheets&#x2F;d&#x2F;11QdEasMWbETbFVxry-Ss...</a>&#x27;<p>-- Write<p>COPY &lt;table_name&gt; to &#x27;<a href="https:&#x2F;&#x2F;docs.google.com&#x2F;spreadsheets&#x2F;d&#x2F;11QdEasMWbETbFVxry-SsD8jVcdYIT1zBQszcF84MdE8" rel="nofollow">https:&#x2F;&#x2F;docs.google.com&#x2F;spreadsheets&#x2F;d&#x2F;11QdEasMWbETbFVxry-Ss...</a>&#x27; (format gsheet);