PHPackages                             lozemc/simple-google-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. [PDF & Document Generation](/categories/documents)
4. /
5. lozemc/simple-google-sheets

ActiveLibrary[PDF & Document Generation](/categories/documents)

lozemc/simple-google-sheets
===========================

An easy way to manage data in Google Sheets using PHP

1.1.1(1y ago)2145MITPHPPHP >=7.4.33||^8.0||^8.1||^8.2||^8.3

Since Jan 2Pushed 1y ago1 watchersCompare

[ Source](https://github.com/lozemc/simple-google-sheets)[ Packagist](https://packagist.org/packages/lozemc/simple-google-sheets)[ Docs](https://github.com/lozemc/)[ RSS](/packages/lozemc-simple-google-sheets/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (3)Dependencies (2)Versions (4)Used By (0)

[![Google Sheets](./icon.svg)](https://www.google.ru/intl/ru/sheets/about/)

GoogleSheet
===========

[](#googlesheet)

`GoogleSheet` is a convenient wrapper for the standard [`google/apiclient`](https://github.com/googleapis/google-api-php-client) package, providing an easy-to-use interface for working with Google Sheets.

Installation
------------

[](#installation)

Require the package using [Composer](https://packagist.org/packages/lozemc/simple-google-sheets):

```
composer require lozemc/simple-google-sheets
```

Usage
-----

[](#usage)

#### Creating an Instance

[](#creating-an-instance)

```
use Lozemc\GoogleSheet;

// Replace 'your_table_id' and 'path/to/your/credentials-config.json' with actual values

$table_id = 'your_table_id';
$credentials = 'path/to/your/credentials-config.json';

$table = new GoogleSheet($table_id, $credentials);
```

### Setting the Sheet

[](#setting-the-sheet)

```
$table->set_sheet('YourSheetName');
```

### Getting Rows

[](#getting-rows)

```
// Get all rows
$rows = $table->get_rows();

print_r($rows);

// [
//    [ 'A1 value', 'B1 value', 'C1 value' ],
//    [ 'A2 value', 'B2 value', 'C2 value' ],
//    [ 'A3 value', 'B3 value', 'C3 value' ]
// ]

// Get rows from a specific range
$range = 'B2:C3';
$rows = $table->get_rows($range);

print_r($rows);

// [
//    [ 'B2 value', 'C2 value' ],
//    [ 'B3 value', 'C3 value' ]
// ]
```

### Updating Rows

[](#updating-rows)

```
$table->update([['A1 value', 'B1 value']]);

//

$range = 'A4';
$table->update([['A4 value', 'B4 value']], $range);

//

$table->update([
    ['A1 value', 'B1 value'],
    ['A2 value', 'B2 value', 'C3 value'],
    ['A3 value', 'B3 value', '', 'D4 value'],
]);
```

### Appending Rows

[](#appending-rows)

```
$table->append([['Value 1', 'Value 2']]);

//

$table->append([['Value 1', 'Value 2']], 'A10');
```

### Simple Example

[](#simple-example)

```
require_once __DIR__ . '/vendor/autoload.php';

use Lozemc\GoogleSheet;

$table_id = '1gncMRlsonFj2YzYw79QnfVA4Go5UcYkmfgG1T7Vb5Q';
$credentials = __DIR__ . '/credentials-config.json';

$table = new GoogleSheet($table_id, $credentials);

// Set the sheet name if not provided during initialization
$table->set_sheet('Sheet1');

// Append new rows
$table->append([
    ['Lisa', 'Anderson'],
    ['Jane', 'Jones'],
]);

// Get all rows
$rows = $table->get_rows();

// Display the retrieved rows
print_r($rows);

// Get rows from a specific range in another sheet
$rows = $table->set_sheet('Sheet2')->get_rows('B10:C20');

print_r($rows);

// Update data in a specific range
$table->update([['New value']], 'B10');
$row = $table->get_rows('B10');

print_r($row);
```

Requirements
------------

[](#requirements)

- PHP >=7.4.33

Dependencies
------------

[](#dependencies)

- [google/apiclient ^2.15.0](https://github.com/googleapis/google-api-php-client)

License
-------

[](#license)

This package is licensed under the [MIT License](LICENSE).

###  Health Score

31

—

LowBetter than 68% of packages

Maintenance33

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity59

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 ~96 days

Total

3

Last Release

667d ago

PHP version history (2 changes)1.0.0PHP >=7.4.33

1.1.1PHP >=7.4.33||^8.0||^8.1||^8.2||^8.3

### Community

Maintainers

![](https://www.gravatar.com/avatar/8e34f1dc417ca9493590aec620c02eeb79538a19a78391a35aac6216ee5bae3a?d=identicon)[lozemc](/maintainers/lozemc)

---

Top Contributors

[![lozemc](https://avatars.githubusercontent.com/u/44927153?v=4)](https://github.com/lozemc "lozemc (7 commits)")

---

Tags

excelgooglegoogle-api-clientgoogle-api-v4google-sheetsgoogle-sheets-apigoogle-spreadsheetshelpers-librarylibraryphpsheetsheetssheets-apispreadsheetspreadsheetstablewrapperphpgooglelibraryexcelspreadsheetwrappertablegoogle-sheetsgoogle api clientsheetssheetspreadsheetsgoogle-spreadsheetshelpers-librarygoogle-sheets-apisheets-apigoogle-api-v4

###  Code Quality

Static AnalysisPHPStan

Type Coverage Yes

### Embed Badge

![Health badge](/badges/lozemc-simple-google-sheets/health.svg)

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

###  Alternatives

[openspout/openspout

PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

1.1k57.6M128](/packages/openspout-openspout)[avadim/fast-excel-writer

Lightweight and very fast XLSX Excel Spreadsheet Writer in PHP

2951.2M7](/packages/avadim-fast-excel-writer)[avadim/fast-excel-reader

Lightweight and very fast XLSX Excel Spreadsheet Reader in PHP

104608.4k6](/packages/avadim-fast-excel-reader)[avadim/fast-excel-templator

Lightweight and very fast Excel Spreadsheet generator from XLSX-templates in PHP

20106.6k](/packages/avadim-fast-excel-templator)[alexandrainst/php-xlsx-fast-editor

PHP library to make basic but fast read & write operations on existing Excel workbooks

1311.4k](/packages/alexandrainst-php-xlsx-fast-editor)

PHPackages © 2026

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