Download the PHP package particle-academy/google-sheets-php without Composer
On this page you can find all versions of the php package particle-academy/google-sheets-php. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download particle-academy/google-sheets-php
More information about particle-academy/google-sheets-php
Files in particle-academy/google-sheets-php
Package google-sheets-php
Short Description Google Sheets for PHP — the service descriptor, its faker, its webhook verification, one class per operation, and a fancy-flow-php executor per node. Plain HTTP on particle-academy/fancy-connector-core; no vendor SDK.
License MIT
Homepage https://github.com/Fancy-Friends/google-sheets
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package google-sheets-php
Google Sheets
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.
- Authorize URL — https://accounts.google.com/o/oauth2/v2/auth
- Token URL — https://oauth2.googleapis.com/token
- Scopes —
https://www.googleapis.com/auth/spreadsheets - Access token lifetime — 3600 seconds (1 hours). A host that never refreshes works all afternoon and is broken by morning.
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.
