PHPackages                             olegv/sheets - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [API Development](/categories/api)
4. /
5. olegv/sheets

ActiveLibrary[API Development](/categories/api)

olegv/sheets
============

Google sheets manager

v1.0.1(1y ago)23MITPHPPHP ^8.2CI passing

Since Mar 8Pushed 1y ago2 watchersCompare

[ Source](https://github.com/OlegVashkevich/sheets)[ Packagist](https://packagist.org/packages/olegv/sheets)[ RSS](/packages/olegv-sheets/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependencies (3)Versions (2)Used By (0)

Sheets
======

[](#sheets)

Lib for work with google sheets

Features
--------

[](#features)

- lightweight
- dependency-free(only curl and openssl)
- 90+% test coverage
- phpstan max lvl
- phpstan full strict rules

Install
-------

[](#install)

```
composer require olegv/sheets
```

Usage
-----

[](#usage)

1. You must create project and add to project `service account` [here](https://console.cloud.google.com/projectselector2/iam-admin/serviceaccounts?hl=ru&inv=1&invt=AbreJg&supportedpurview=project)
2. In `service account` must create `key` in kes tab, after that your credentials will be downloaded as a json file
3. Put json file with credentials somewhere, for example `/path_to/credentials.json`
4. Ydoou may need to add the email address from your credentials to sheet access
5. Code example

```
use OlegV\Sheet;

$sheet = new Sheet("sheets_id",'/path_to/credentials.json');

//append
$response = ->setSheet('Sheet9')->append([[1,2,"Text","Текст","many words many words many words",6,7,8,9]], 'R1C1');
print_r($response);

//clear
$data = json_decode($response, true);
$range = explode('!', $data['updates']['updatedRange']);
$response = $sheet->clear($range[1]);
print_r($response);

//get
$response = $sheet->get(
    'A6:C6',
);
print_r($response);

//update
$response = $sheet->update(
    [[1, 2, 3]],
    'A6:C6',
);
print_r($response);
```

###  Health Score

29

—

LowBetter than 59% of packages

Maintenance44

Moderate activity, may be stable

Popularity6

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity50

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

437d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/791b13b30e50e389b5dc53f9badbf7b5614b81a54404ead08495bae08c06d178?d=identicon)[OlegVashkevich](/maintainers/OlegVashkevich)

---

Top Contributors

[![OlegVashkevich](https://avatars.githubusercontent.com/u/13260371?v=4)](https://github.com/OlegVashkevich "OlegVashkevich (12 commits)")

---

Tags

apigooglelibrarylightweightsheetsdependency-free

###  Code Quality

TestsPHPUnit

Static AnalysisPHPStan

Type Coverage Yes

### Embed Badge

![Health badge](/badges/olegv-sheets/health.svg)

```
[![Health](https://phpackages.com/badges/olegv-sheets/health.svg)](https://phpackages.com/packages/olegv-sheets)
```

###  Alternatives

[statickidz/php-google-translate-free

Google Translate Free library for PHP

289258.8k6](/packages/statickidz-php-google-translate-free)[ozankurt/google-analytics

Laravel Google Analytics

7616.7k](/packages/ozankurt-google-analytics)[skeeks/yii2-google-api

Component for work with google api based on google/apiclient

1243.1k1](/packages/skeeks-yii2-google-api)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)