PHPackages                             hopper/g\_sheet - 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. hopper/g\_sheet

ActiveLibrary[API Development](/categories/api)

hopper/g\_sheet
===============

google sheet api tool

v1.0(5y ago)08MITPHPPHP >=7.0

Since Jun 21Pushed 4y ago1 watchersCompare

[ Source](https://github.com/pengan95/g_sheet)[ Packagist](https://packagist.org/packages/hopper/g_sheet)[ RSS](/packages/hopper-g-sheet/feed)WikiDiscussions master Synced 3w ago

READMEChangelogDependencies (1)Versions (4)Used By (0)

g\_sheet
========

[](#g_sheet)

google sheet api for meikai

### Example

[](#example)

```
include_once "./vendor/autoload.php";

use MeiKaiGsuit\GSheet\GClient;

$client = (new GClient(GClient::SHEET_WRITE_SCOPE_GROUP))->getClient();

$data = [
    '2021-06',
    '=AB`BR1`',
    [
        'value' => 0.1,
        'number_format' => [
            'type' => \MeiKaiGsuit\GSheet\GSheetCell::FIELDS_NUMBER_FORMAT_TYPE_PERCENT,
//            'pattern' => '',
        ]
    ],
    '123.11',
    '=SUM(`BC3``CR`:`BC1``CR`)',
];

$gfile = new \MeiKaiGsuit\GSheet\GSheet($client, '1jYiRxggd3T2iBDpkin97p5p9q5SX7172ReH_aS9VsKg');

$sheets = $gfile->getSheets();

foreach ($sheets as $sheet) {
    if (!preg_match('/^[A-Z]{3}$/', $sheet->getProperties()->getTitle())) {
        continue;
    }
    $row_index = $gfile->getSheetLastRow($sheet);
    $gfile->addCurrencyNumberRow($sheet->getProperties()->getSheetId(), $sheet->getProperties()->getTitle(), $row_index, $data);
}
```

###  Health Score

22

—

LowBetter than 21% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity49

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

Every ~0 days

Total

2

Last Release

1838d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/99029368?v=4)[pidan](/maintainers/pidan)[@Pidan](https://github.com/Pidan)

---

Top Contributors

[![pengan95](https://avatars.githubusercontent.com/u/10327949?v=4)](https://github.com/pengan95 "pengan95 (1 commits)")

### Embed Badge

![Health badge](/badges/hopper-g-sheet/health.svg)

```
[![Health](https://phpackages.com/badges/hopper-g-sheet/health.svg)](https://phpackages.com/packages/hopper-g-sheet)
```

###  Alternatives

[flow-php/flow

PHP ETL - Extract Transform Load - Data processing framework

85036.3k](/packages/flow-php-flow)[tomshaw/google-api

A Laravel Google API Client.

601.8k](/packages/tomshaw-google-api)[fleetbase/core-api

Core Framework and Resources for Fleetbase API

1235.9k20](/packages/fleetbase-core-api)[spatie/analytics-statistics

An opinionated php package to retrieve Google Analytics data.

794.8k](/packages/spatie-analytics-statistics)[chameleon-system/chameleon-base

The Chameleon System core.

1028.6k5](/packages/chameleon-system-chameleon-base)

PHPackages © 2026

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