2 ms·
DuckDB GSheets is a DuckDB extension that allows you to read and write data from Google Sheets. -- Install install gsheets from community; load gsheets; --
by archiewood 2y ago
DuckDB 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);