PHPackages                             optiwariindia/gsheet - 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. optiwariindia/gsheet

ActiveLibrary

optiwariindia/gsheet
====================

A library to connect google sheet from web applications.

1.0.0(4y ago)015MITPHP

Since Jul 8Pushed 4y ago1 watchersCompare

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

READMEChangelog (1)Dependencies (1)Versions (2)Used By (0)

GSheet : A library to connect your application with google sheet
================================================================

[](#gsheet--a-library-to-connect-your-application-with-google-sheet)

### Install

[](#install)

`composer require optiwariindia/gsheet`

### Getting Started

[](#getting-started)

#### Create Credentials at google cloud

[](#create-credentials-at-google-cloud)

1. Open \[Google Cloud Console\]:
2. Create a new project
3. Navigate to API And Services > Credentials
4. Click on "Create Credentials" link
5. Select Credential type "Service Account"
6. Fill the form and Grant the access
7. Navigate to IAM & Admin > Service Accounts
8. Click on Action link in front of service account just created.
9. Select manage keys
10. Now click on add key button and select key type "JSON"
11. Save the file as credentials.json in the project root directory

#### Grant access to sheet

[](#grant-access-to-sheet)

1. Open "credentials.json" file you have downloaded from google.
2. Find key named "Client\_email" and copy the email besides it.
3. Go to sheet you want to access
4. Share that sheet with "Client\_email" which you have just coppied.

#### Getting Google Sheet ID

[](#getting-google-sheet-id)

1. Check the url of your sheet [https://docs.google.com/spreadsheets/d/\_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX\_/edit#gid=0](https://docs.google.com/spreadsheets/d/_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX_/edit#gid=0)
2. Copy the part after `" till next "/"
3. Use this part as sheet id in the code.

#### Initializing Sheet

[](#initializing-sheet)

`use optiwariindia\gsheet`

`gsheet::init("credentials.json",{SHEET_ID})`

#### Add Data into new row

[](#add-data-into-new-row)

`gsheet::addData("{Sheet Name}!{First Column Name}{Row Number}:{Last Column Name}",{Data to be inserted})`

#### Search in specific column

[](#search-in-specific-column)

`gsheet::find("{Sheet Name}!{First Column Name}{Row Number}:{Last Column Name}",{keyword},{column number}})`

#### Update Data in specific row

[](#update-data-in-specific-row)

`gsheet::updateData("{Sheet Name}!{First Column Name}{Row Number(to be updated)}:{Column Name}",{Data to be updated})`

#### Delete Data from a row

[](#delete-data-from-a-row)

`gsheet::deleteData("{Sheet name}!{First Column Name}{Row Number}:{Last Column Number}{Row Number}")`

###  Health Score

23

—

LowBetter than 27% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity51

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

1766d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/fbe7a52e3d1cfef83fb9c467650e5553acb525bd67e0106c222f1444a1797010?d=identicon)[optiwariindia](/maintainers/optiwariindia)

---

Top Contributors

[![optiwariindia](https://avatars.githubusercontent.com/u/4514495?v=4)](https://github.com/optiwariindia "optiwariindia (2 commits)")

### Embed Badge

![Health badge](/badges/optiwariindia-gsheet/health.svg)

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

###  Alternatives

[flow-php/flow

PHP ETL - Extract Transform Load - Data processing framework

81733.7k](/packages/flow-php-flow)[fleetbase/core-api

Core Framework and Resources for Fleetbase API

1225.0k10](/packages/fleetbase-core-api)[chameleon-system/chameleon-base

The Chameleon System core.

1026.5k3](/packages/chameleon-system-chameleon-base)[voidagency/vactory_starter_kit

Vactory is a custom Drupal profile which is developed and released by VOID Agency.

1019.7k](/packages/voidagency-vactory-starter-kit)

PHPackages © 2026

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