PHPackages                             laraditz/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. [API Development](/categories/api)
4. /
5. laraditz/google-sheets

ActiveLibrary[API Development](/categories/api)

laraditz/google-sheets
======================

Wrapper for Google Sheets API V4

1.0.0(3y ago)06MITPHPPHP ^8.0

Since Sep 20Pushed 3y ago1 watchersCompare

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

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

Laravel Google Sheets API
=========================

[](#laravel-google-sheets-api)

[![Latest Version on Packagist](https://camo.githubusercontent.com/a33d46a9d08801972a4fb080d74b950d3ec2681995e0054948747cd5922b0c95/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f6c6172616469747a2f676f6f676c652d7368656574732e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/laraditz/google-sheets)[![Total Downloads](https://camo.githubusercontent.com/e6d36990824cf3a6bcc29f9a9a404e667340df2419adb385dacfcd2dc6289902/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6c6172616469747a2f676f6f676c652d7368656574732e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/laraditz/google-sheets)[![GitHub Actions](https://github.com/laraditz/google-sheets/actions/workflows/main.yml/badge.svg)](https://github.com/laraditz/google-sheets/actions/workflows/main.yml/badge.svg)

A simple wrapper for Google Sheets API V4.

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

[](#installation)

You can install the package via composer:

```
composer require laraditz/google-sheets
```

Setup
-----

[](#setup)

1. This api uses Authentication with Service Accounts. Follow the instructions to [Create a Service Account](docs/oauth-server.md#creating-a-service-account).
2. Download the JSON credentials.
3. By default the path to the credentials is at storage `app/credentials.json`. You can set your own path by overwrite the value through `GOOGLE_SHEETS_AUTH_CONFIG` env.
4. There are also other `.env` value that you can overwrite to suites your need as below:-

```
GOOGLE_SHEETS_APP_NAME="Google Sheets"
GOOGLE_SHEETS_ACCESS_TYPE=offline
GOOGLE_SHEETS_AUTH_CONFIG="app/credentials.json"

```

Usage
-----

[](#usage)

```
$spreadsheetId = "XXxXXxXXXXXx_XXxXXxXXXXXx_XXxXXxXXXXXx"; // this will be your spreadsheet ID
$range = "Sheet 1"; // here we use the name of the Sheet to get all the rows

// read all the rows of given sheet, sheet will return a Collection and you may use any of Collection method such as all(), toArray(), etc
$sheets = app('google-sheets')->spreadsheet($spreadsheetId)->sheet($range)->all();
```

### Testing

[](#testing)

```
composer test
```

### Changelog

[](#changelog)

Please see [CHANGELOG](CHANGELOG.md) for more information what has changed recently.

Contributing
------------

[](#contributing)

Please see [CONTRIBUTING](CONTRIBUTING.md) for details.

### Security

[](#security)

If you discover any security related issues, please email  instead of using the issue tracker.

Credits
-------

[](#credits)

- [Raditz Farhan](https://github.com/laraditz)
- [All Contributors](../../contributors)

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE.md) for more information.

Package Dependencies
--------------------

[](#package-dependencies)

This package depends on

###  Health Score

23

—

LowBetter than 27% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity53

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

1335d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/1203676?v=4)[Raditz Farhan](/maintainers/raditzfarhan)[@raditzfarhan](https://github.com/raditzfarhan)

---

Top Contributors

[![raditzfarhan](https://avatars.githubusercontent.com/u/1203676?v=4)](https://github.com/raditzfarhan "raditzfarhan (5 commits)")

---

Tags

google-sheetslaraditz

###  Code Quality

TestsPHPUnit

### Embed Badge

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

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

###  Alternatives

[thujohn/analytics

Google Analytics for Laravel 4

113108.7k1](/packages/thujohn-analytics)[esign/laravel-conversions-api

A laravel wrapper package around the Facebook Conversions API

69145.4k](/packages/esign-laravel-conversions-api)[schulzefelix/laravel-search-console

A Laravel package to retrieve data from Google Search Console

5037.8k1](/packages/schulzefelix-laravel-search-console)[didww/didww-api-3-php-sdk

PHP SDK for DIDWW API 3

1218.2k](/packages/didww-didww-api-3-php-sdk)

PHPackages © 2026

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