{"repo":"theoephraim/node-google-spreadsheet","free":true,"listed":false,"github":"https://github.com/theoephraim/node-google-spreadsheet","clone":"git clone https://github.com/theoephraim/node-google-spreadsheet.git","description":"Google Sheets API wrapper for Javascript / Typescript","language":"TypeScript","stars":2490,"topics":["google-spreadsheets","nodejs","google","google-sheets","google-sheets-api-v4","typescript"],"license":"MIT","category":"api-integrations-sdks","readme_excerpt":"google-spreadsheet The most popular Google Sheets API wrapper for javascript / typescript - multiple auth options (via google-auth-library) - service account, OAuth, API key, ADC, etc - cell-based API - read, write, bulk-updates, formatting - row-based API - read, update, delete (based on the old v3 row-based calls) - managing worksheets - add, remove, resize, update properties (ex: title), duplicate to same or other document - managing docs - create new doc, delete doc, basic sharing/permissions - export - download sheet/docs in various formats - automatic retries with exponential backoff for failed/rate-limited requests (powered by ky, customizable) Docs site - Full docs available at https://theoephraim.github.io/node-google-spreadsheet --- 🌈 Installation - npm i google-spreadsheet (or pnpm / yarn / bun /etc...) Examples The following examples are meant to give you an idea of just some of the things you can do IMPORTANT NOTE - To keep the examples concise, I'm calling await at the top level which is not allowed in some older versions of node. If you need to call await in a script at the root level and your environment does not support it, you must instead wrap it in an async function like so: The Basics More info: - GoogleSpreadsheet - GoogleSpreadsheetWorksheet - Authentication Working with rows Row methods support explicit TypeScript types for shape of the data More info: - GoogleSpreadsheetWorksheet Working With Rows - GoogleSpreadsheetRow Working with cells More info: ","default_branch":null,"files":null,"tree":[],"storefront":"/r/theoephraim","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/theoephraim/node-google-spreadsheet/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}