Skip to main content

Google Sheets

Fancified

Google Sheets for fancy-flow — as four imported, versioned packages, one per runtime. Not vendored source: a copy cannot be upgraded, and third-party APIs change.

Runtime Package Install
Authoring surface (every host) @particle-academy/google-sheets-ui npm install @particle-academy/google-sheets-ui
Node @particle-academy/google-sheets-js npm install @particle-academy/google-sheets-js
PHP 8.4+ particle-academy/google-sheets-php composer require particle-academy/google-sheets-php
Python 3.11+ fancy-google-sheets pip install fancy-google-sheets

The ui package is the editor surface and is React on every host — a PHP or Python project installs it and its own runtime package, and never the js one.

What it costs you

One dependency: @particle-academy/fancy-connector-core (or particle-academy/fancy-connector-core on Composer), which the js and php packages pull in themselves. The Python package has zero runtime dependencies.

No Google Sheets SDK. Plain HTTP, deliberately: a vendor SDK is third-party code subject to the kit's full approval bar, and one per provider is hundreds of dependencies nobody is tracking.

Setting it up

Everything below is generated from provider/manifest.json, so it cannot disagree with what the packages do.

Credentials

A Google Sheets connection holds 4 values.

Two kinds of value, and mixing them up matters. A provider credential is ONE value for the whole installation — an OAuth app's client secret serves every connected account. An account credential is one per connected account. A host that stores the second where it stores the first lets one account's credentials reach another's.

Field Scope Secret Where it comes from
OAuth client ID per installation not secret From Google Cloud Console -> APIs & Services -> Credentials. ONE value for the whole installation, not per connected account.
OAuth client secret per installation secret The client secret for the same OAuth app. One value for the whole installation.
Access token per connected account secret Per connected Google account, and it expires after ONE HOUR. The host refreshes it with the refresh token.
Refresh token per connected account secret Per connected Google account. Google issues one only when the consent request asks for offline access; without it the connection dies within the hour.

Authorising

Google Sheets uses OAuth2 (authorization_code). The package DECLARES the exchange; the HOST performs it — a consent screen needs a browser, a redirect URI and somewhere to persist the result, and all three belong to the host.

One consent grant, shared (grant: "google"). Every connector declaring the same grant can run on ONE OAuth client, with one consent and one refresh token per person.

  • Authorize with access_type=offline, include_granted_scopes=true. Ask for a feature's scopes when it is first used; the new token covers every scope granted before. A refresh token comes back only on the FIRST exchange, so keep the stored one when an exchange returns none.
  • Revoke — POST https://oauth2.googleapis.com/revoke with token. It removes the WHOLE grant: every connector sharing it, not only this one. A per-feature disconnect stops using that feature's scopes locally; only a full disconnect revokes.
  • Identify the account by sub: request openid, then verify the token response's id_token (issuer https://accounts.google.com or accounts.google.com, keys at https://www.googleapis.com/oauth2/v3/certs, audience = clientId). Never key a connection by email.
  • No restricted scopes in this connector.

The refresh tokens do not rotate: the same one is reusable, so a refresh may safely be retried and may run concurrently. Stated rather than assumed, because the opposite — a provider that spends the token and revokes the grant on a replay — looks identical until it happens.

The estate

Google Sheets has no test estate, and somebody checked. Everything this connector does is real. Use the faker to build against it.

Google has no sandbox for Sheets. A test spreadsheet is a real one in a real Drive, so every append is real -- point this at a scratch sheet, not a production one. The faker is the only way to develop against it without touching a document.

What it can do

Actions

row_append — Google Sheets row

Append a row to a Google Sheet.

POST /v4/spreadsheets/{spreadsheetId}/values/{range}:append · unsafe to replay — a retried durable run does it TWICE

Input Required What it is
spreadsheetId yes The long id from the sheet's URL: docs.google.com/spreadsheets/d/THIS_PART/edit.
range yes Where to append, in A1 notation. Google finds the last row of this range and writes below it.
values yes The cells of the row, comma separated. Left to right from the start of the range.
valueInputOption no USER_ENTERED parses the cells the way typing them would -- so =SUM(A1:A2) becomes a formula and 1/2/26 becomes a date. RAW stores exactly the characters given.
insertDataOption no INSERT_ROWS pushes existing rows down. OVERWRITE writes into them.

values_get — Read Google Sheets values

Read the cell values of a range.

GET /v4/spreadsheets/{spreadsheetId}/values/{range} · reads only — safe to replay

Input Required What it is
spreadsheetId yes The long id from the sheet's URL: docs.google.com/spreadsheets/d/THIS_PART/edit.
range yes In A1 notation, the same shape row_append accepts.
valueRenderOption no How to render values
majorDimension no Whether the outer array of the result is rows or columns.

values_update — Write Google Sheets values

Overwrite the cell values of a range. Existing values in that range are replaced, not pushed down.

PUT /v4/spreadsheets/{spreadsheetId}/values/{range} · idempotent — safe to replay

Input Required What it is
spreadsheetId yes Spreadsheet ID
range yes In A1 notation. The values written fill this range from its top-left cell -- more rows or columns than the range covers are written anyway, following Google's own documented behavior; fewer leave the rest of the range untouched.
values yes The cells to write, comma separated, left to right, one row. For more than one row, call this action once per row.
valueInputOption yes USER_ENTERED parses the cells the way typing them would -- so =SUM(A1:A2) becomes a formula. RAW stores exactly the characters given.

Run it before you have credentials

Every operation ships a faker, whether or not Google Sheets has a sandbox. Set a node's mode to fake and it returns the shape Google Sheets actually publishes — the same field names, deterministically — so you can wire the downstream nodes before touching an account, a key, or a network.

This repository is generated

provider/ is the source. Everything under packages/ is emitted from it and must not be hand-edited — CI regenerates and diffs on every push, and the next protocol sync destroys anything it finds. See AGENTS.md.

Two namespaces, which do not match on purpose

The repo is github.com/Fancy-Friends/google-sheets; the packages publish under particle-academy. Nothing derives one from the other — the names come from weaver's friends.json and nowhere else.

Licence

MIT.

Metadata

Release files for fancy-google-sheets 0.6.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for fancy-google-sheets 0.6.0
File Size Uploaded Provenance Actions
fancy_google_sheets-0.6.0.tar.gz 25.6 kB Without provenance Details for fancy_google_sheets-0.6.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for fancy-google-sheets 0.6.0
File Interpreter ABI Platform Actions
fancy_google_sheets-0.6.0-py3-none-any.whl Python 3 none any Details for fancy_google_sheets-0.6.0-py3-none-any.whl

Total release size: 51.4 kB

Release files / fancy_google_sheets-0.6.0.tar.gz

Download URL fancy_google_sheets-0.6.0.tar.gz
Size 25.6 kB
Tags Source
SHA-256 checksum
How to use checksums
eecbdfcb2b5097fef3d545c155165165fad340b21d528f10a3870daed8ec3032
BLAKE2b-256 checksum
How to use checksums
88b6c514b9a337ec40b3e94c0f3653b53372fc103356b0b06146695a3d335d43
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.18

Release files / fancy_google_sheets-0.6.0-py3-none-any.whl

Download URL fancy_google_sheets-0.6.0-py3-none-any.whl
Size 25.9 kB
Tags Python 3
SHA-256 checksum
How to use checksums
83adb5bdc03fd6c79dbb000b16805abff701fe4f92f82e347bf1e30e389b9396
BLAKE2b-256 checksum
How to use checksums
36427b10546b96468fafa83cd31a9e1ce31fac559cd10c41a089c8130671df8a
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.18

Security for fancy-google-sheets 0.6.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page