PHPackages                             ibnuhalimm/laravel-google-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. ibnuhalimm/laravel-google-sheet

ActiveLibrary[API Development](/categories/api)

ibnuhalimm/laravel-google-sheet
===============================

Google Sheet API wrapper for Laravel

v1.2.1(4y ago)0374MITPHPPHP ^7.3|^8.0

Since Feb 10Pushed 4y ago1 watchersCompare

[ Source](https://github.com/ibnuhalimm/laravel-google-sheet)[ Packagist](https://packagist.org/packages/ibnuhalimm/laravel-google-sheet)[ Docs](https://github.com/ibnuhalimm/laravel-google-sheet)[ RSS](/packages/ibnuhalimm-laravel-google-sheet/feed)WikiDiscussions 1.x Synced 1mo ago

READMEChangelogDependencies (6)Versions (6)Used By (0)

Laravel Google Sheet
====================

[](#laravel-google-sheet)

[![Latest Version on Packagist](https://camo.githubusercontent.com/6a50f1a752f5976b2465bcf7143136339277952576bf1eb0b14893d3ac2f0079/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f69626e7568616c696d6d2f6c61726176656c2d676f6f676c652d73686565742e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/ibnuhalimm/laravel-google-sheet)[![Total Downloads](https://camo.githubusercontent.com/833f8bbf890aa835bf7d6feb1c60a792f424c5bf189f2ac2e5ecbeed1934a289/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f69626e7568616c696d6d2f6c61726176656c2d676f6f676c652d73686565742e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/ibnuhalimm/laravel-google-sheet)

Google Sheet API Wrapper for Laravel. Easiest way to interact with your sheet.

Contents
--------

[](#contents)

- [Requirements](#requirements)
- [Installation](#installation)
- [Usage](#usage)
- [Testing](#testing)
- [Changelog](#changelog)
- [Contributing](#contributing)
- [Security](#security)
- [Credits](#credits)
- [License](#license)

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

[](#requirements)

1. [Create a Google Cloud project](https://developers.google.com/workspace/guides/create-project). If you want to use your existing project, you can jump to the next step.
2. [Create Service Acount Credentials](https://developers.google.com/workspace/guides/create-credentials#service-account) on Google Developer Console and share your Google Sheet file to these service account email.
3. Place your downloaded service account json file to `storage/app/google-sheet/` folder, then rename these file to `credentials.json`.
4. [Enable `Google Sheet API`](https://developers.google.com/workspace/guides/enable-apis) on Google Workspace APIs.

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

[](#installation)

You can install the package via composer:

```
composer require ibnuhalimm/laravel-google-sheet
```

Optionally, you can publish the config file of this package with this command:

```
php artisan vendor:publish --provider="Ibnuhalimm\LaravelGoogleSheet\GoogleSheetServiceProvider"
```

or by mention the config tag

```
php artisan vendor:publish --tag=google-sheet-config
```

Usage
-----

[](#usage)

### Fetch the data

[](#fetch-the-data)

You can use `GoogleSheet` facade (the alias or class itself).

```
use GoogleSheet;

$spreadSheetId = '1cyUalLbuw_TpAIgkf76JcU-BbsYCSwtVqJuf_gCNzYA';
$sheetName = 'Class Data';
$cellRange = 'A1:E5';

GoogleSheet::useDocument($spreadSheetId)->fetchData($sheetName, $cellRange);
```

This method will returns the subset of array data

```
=> [
     [
       "Student Name",
       "Gender",
       "Class Level",
       "Home State",
       "Major",
     ],
     [
       "Alexandra",
       "Female",
       "4. Senior",
       "CA",
       "English",
     ],
    ...
```

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 `ibnuhalim@pm.me` instead of using the issue tracker.

Credits
-------

[](#credits)

- [Ibnu Halim Mustofa](https://github.com/ibnuhalimm)
- [All Contributors](../../contributors)

License
-------

[](#license)

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

Laravel Package Boilerplate
---------------------------

[](#laravel-package-boilerplate)

This package was generated using the [Laravel Package Boilerplate](https://laravelpackageboilerplate.com).

###  Health Score

27

—

LowBetter than 49% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity12

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity58

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

Total

5

Last Release

1481d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/14322078?v=4)[IBNU HALIM MUSTOFA](/maintainers/ibnuhalimm)[@ibnuhalimm](https://github.com/ibnuhalimm)

---

Top Contributors

[![ibnuhalimm](https://avatars.githubusercontent.com/u/14322078?v=4)](https://github.com/ibnuhalimm "ibnuhalimm (23 commits)")

---

Tags

ibnuhalimmlaravel-google-sheet

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/ibnuhalimm-laravel-google-sheet/health.svg)

```
[![Health](https://phpackages.com/badges/ibnuhalimm-laravel-google-sheet/health.svg)](https://phpackages.com/packages/ibnuhalimm-laravel-google-sheet)
```

###  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)[scottybo/laravel-google-my-business

A package for Laravel which implements the Google My Business API

3360.3k](/packages/scottybo-laravel-google-my-business)[didww/didww-api-3-php-sdk

PHP SDK for DIDWW API 3

1218.2k](/packages/didww-didww-api-3-php-sdk)[surface/laravel-webfinger

A Laravel package to create an ActivityPub webfinger.

113.8k](/packages/surface-laravel-webfinger)

PHPackages © 2026

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