3 ms·
DuckDB-GSheets: Read and Write Google Sheets in Pure SQL
- archiewood 2y agoDuckDB GSheets is a DuckDB extension that allows you to read and write data from Google Sheets. -- Install install gsheets from community; load gsheets; -- Authenticate with the browser create secret (type gsheet); -- Read select * from 'https://docs.google.com/spreadsheets/d/11QdEasMWbETbFVxry-SsD8jVcdYIT1zBQszcF84MdE8 https://docs.google.com/spreadsheets/d/11QdEasMWbETbFVxry-Ss...' -- Write COPY <table_name> to 'https://docs.google.com/spreadsheets/d/11QdEasMWbETbFVxry-SsD8jVcdYIT1zBQszcF84MdE8 https://docs.google.com/spreadsheets/d/11QdEasMWbETbFVxry-Ss...' (format gsheet);