npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2026 – Pkg Stats / Ryan Hefner

@orgsdk/plugin-google-sheets

v1.0.5

Published

Google Sheets read/write + owns the shared google-oauth connect flow for google-sheets and google-tasks (first-party one-click or BYO)

Readme

Google Sheets for OrgSDK

Install in OrgSDK

Open your project's Plugins page, select this plugin and enable the pinned release. The default catalogue is https://orgsdk.ai/plugins/releases.json. The executor downloads the versioned bundle and verifies its SHA256. Configure the provider and attach the credential described below before running an action.

The plugin is Apache-2.0 licensed; see LICENSE, NOTICE and TRADEMARKS.md. The generated npm distribution is a separate publication surface. Installing npm files alone does not register a project plugin. Local builds do not publish it.

Credentials

Connect your own Google OAuth application in OrgSDK with https://www.googleapis.com/auth/spreadsheets. Enable the corresponding Google API and register the exact callback URL shown by OrgSDK in your Google Cloud OAuth client. Attach the resulting google-oauth credential to this project plugin. The host owns consent and token refresh; execution receives only {source: "byo", secret_accessToken}. Client and refresh secrets stay on the host. No hosted OAuth relay is supported.

A Google credential may be shared with another Google plugin only when its granted scopes cover both plugins. Provider consent, app verification and account permissions are required independently of installing this package.

Functions

  • appendToSheet — Append rows to a Google Sheet range. Always pass a 2D array: [[val1, val2], ...]. Spreadsheet ID + range are passed at runtime.
  • getSheetData — Read values from a Google Sheet range
  • clearSheet — Clear values in a Google Sheet range. Tip: use a range that excludes headers (e.g. Sheet1!A2:Z)
  • listSheetTables — List all structured tables in a Google Sheet. Returns array with tableId (string), name, sheetId, sheetTitle, range (GridRange), a1Range (A1 notation for debugging).
  • appendToTable — Append rows to a structured Google Sheet table. Pass rows as objects keyed by column name: [{ Provider: 'X', Amount: 100 }, ...]. Column names must match table headers exactly. Use listSheetTables to find tableId. Formula detection: strings starting with '='.
  • getTableData — Read all data rows from a structured Google Sheet table. Returns rows as objects with column names as keys. Each row includes _rowIndex for updates. Use listSheetTables to find tableId.
  • updateTableRow — Update specific columns in a row of a Google Sheet table. Use _rowIndex from getTableData. Pass updates as { columnName: newValue }.

Example action

return await googleSheets.getSheetData({ spreadsheetId: "your-spreadsheet-id", range: "Sheet1!A1:D20" });

Use named argument objects. Exact parameters and return types are in the release catalogue and the project tool contract.

Development

Use Bun 1.4 and Node.js 22.22.0 or newer. See npm distribution and verification. Run source checks, package, build:npm, test:executor and test:registration before release. Provider tests use synthetic data; no live account permissions are implied.