PHPackages                             iainp999/gbot-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. [Utility & Helpers](/categories/utility)
4. /
5. iainp999/gbot-google-sheets

ActiveGlitcherbot-package[Utility & Helpers](/categories/utility)

iainp999/gbot-google-sheets
===========================

Writes GlitcherBot data to Google sheets.

v0.2-BETA(5y ago)16PHP

Since Mar 18Pushed 5y ago1 watchersCompare

[ Source](https://github.com/iainp999/gbot-google-sheets)[ Packagist](https://packagist.org/packages/iainp999/gbot-google-sheets)[ RSS](/packages/iainp999-gbot-google-sheets/feed)WikiDiscussions main Synced today

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

GlitcherBot Google Sheets Subscriber
====================================

[](#glitcherbot-google-sheets-subscriber)

Listens for glitcherbot crawling events, gathers data, and will write data to Google sheets at the end of the crawl.

The sheet is written to Google Drive in the root folder, and has the title 'GlitcherBot Data' (unless you specify an existing sheet ID - see below).

Configuration
-------------

[](#configuration)

You will need to create a new application via the Google developer's console and create some OAUTH2 credentials with permissions to write to Google sheets. The type should be 'Desktop App'.

Once done, download your credentials.json file and place it in the GoogleSheets folder.

On first run, you will be given a URL to authenticate against. Open this in a browser. You'll receive a code that you'll need to copy and paste into the console window. Once authorised, a refresh token is stored in `token.json` in the `GoogleSheets` folder. You may be required to repeat this process from time to time.

### Re-using an existing sheet

[](#re-using-an-existing-sheet)

To append data to an existing sheet, create a `config.yaml` file in the `GoogleSheets` folder and set the value of `sheet_id` to the ID of the sheet you want to use. See `example.config.yaml` for the format.

If `config.yaml` does not exist, on the first run, a sheet will be created and the `config.yaml` file will be created and populated so that the same sheet is used on subsequent runs.

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity39

Early-stage or recently created project

 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

1878d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/86462d257ccf1f343e5ecc17451fcbca4244d8a57172369e897a3c4b79396de1?d=identicon)[iainp999](/maintainers/iainp999)

---

Top Contributors

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

### Embed Badge

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

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

###  Alternatives

[spatie/laravel-google-calendar

Manage events on a Google Calendar

1.4k1.5M21](/packages/spatie-laravel-google-calendar)[tomatophp/filament-seo

Manage and generate SEO tags and integrate your website with Google SEO services

112.6k1](/packages/tomatophp-filament-seo)[infoweb-internet-solutions/yii2-cms-analytics

Analytics module for Yii2

112.4k1](/packages/infoweb-internet-solutions-yii2-cms-analytics)

PHPackages © 2026

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