{"library":"google-spreadsheet","type":"library","category":null,"description":"The `google-spreadsheet` package provides a robust and easy-to-use JavaScript/TypeScript interface for interacting with the Google Sheets API. It simplifies common tasks like reading, writing, and manipulating data within spreadsheets, as well as managing sheets and documents themselves. The current stable version is `5.2.0`, and the project maintains an active development cycle with frequent minor and patch updates for new features, bug fixes, and dependency synchronization. Key differentiators include comprehensive support for multiple authentication methods via `google-auth-library` (service account, OAuth 2.0, API key, ADC), both cell-based and row-based APIs for flexible data interaction, extensive methods for managing worksheets and documents (e.g., adding, removing, resizing, updating properties, setting permissions), and built-in automatic retries with exponential backoff for API requests, enhancing reliability against transient network issues and rate limits. It aims to be the most popular wrapper, abstracting away the complexities of the underlying Google Sheets API.","language":"javascript","status":"active","version":"5.2.0","tags":["javascript","google spreadsheets","google sheets","google","spreadsheet","spreadsheets","sheets","gdata","api","typescript"],"last_verified":"Wed May 27","install":[{"cmd":"npm install google-spreadsheet","imports":["import { GoogleSpreadsheet } from 'google-spreadsheet';","import { JWT } from 'google-auth-library';","import type { GoogleSpreadsheetWorksheet } from 'google-spreadsheet';"]},{"cmd":"yarn add google-spreadsheet","imports":[]},{"cmd":"pnpm add google-spreadsheet","imports":[]}],"homepage":"https://theoephraim.github.io/node-google-spreadsheet","github":"https://github.com/theoephraim/node-google-spreadsheet","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/google-spreadsheet","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"18–22","success_rate":0,"avg_install_s":null,"avg_import_s":null,"wheel_type":null},"url":"https://checklist.day/v1/registry/google-spreadsheet/compatibility"}}