PHPackages silinternational/google-sheets-php - 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. silinternational/google-sheets-php Abandoned → [sil-org/google-sheets-php](/?search=sil-org%2Fgoogle-sheets-php)Library[Utility & Helpers](/categories/utility) silinternational/google-sheets-php ================================== A simple library for pushing data to a Google Sheet using the Google PHP API Client version 1 1.2.1(7mo ago)108.1k1MITPHPPHP ^7.4||^8.1 Since May 28Pushed 6mo ago5 watchersCompare [ Source](https://github.com/sil-org/google-sheets-php)[ Packagist](https://packagist.org/packages/silinternational/google-sheets-php)[ RSS](/packages/silinternational-google-sheets-php/feed)WikiDiscussions main Synced 1w ago READMEChangelog (7)Dependencies (5)Versions (9)Used By (0) Google Sheets PHP ================= [](#google-sheets-php) A simple library for pushing data to a Google Sheet using the Google PHP API Client **version 1**. Authorization ------------- [](#authorization) To use this library to push data to a Google Sheet... 1. Go to the Google Developers Console. 2. If you do not yet have a project that you plan to use this with, create one. 3. Enable the "Google Sheets API" for that project. 4. Create credentials for the project: - To use the Google Sheets API - From a web server - To access application data - Not using Google App Engine or Computer Engine - Give it a service account name - Don't give it a role - Select the JSON key option 5. Save that JSON file to some private folder where your code can access it. 6. Get the Spreadsheet ID of the Google Sheet that you want to push data to. It is shown in its URL after the "" prefix, up until the next "/". 7. Share that Google Sheet (cf. the spreadsheet ID) with the `client_email`value found in your Google credentials JSON file, giving it permission to edit the spreadsheet. Viola! You should now be able to push data to that Google Sheet. Testing ------- [](#testing) To test this library (and that your permissions are set up correctly)... 1. Clone this repo to your local machine. 2. Put your JSON credentials file in the "credentials" folder (Git is set to ignore that folder's contents... DO NOT COMMIT YOUR JSON FILE TO GIT). 3. Copy the `local.env.dist` file to `local.env`, giving it the requested values. 4. Open a terminal to the root of the repo and run `make`. 5. Look at your Google Sheet and verify that data has been appended. Resources --------- [](#resources) How to use the Google PHP API Client (v1) that this uses: - Documentation on the `append` Google Sheets API: - ### Health Score 48 — FairBetter than 94% of packages Maintenance65 Regular maintenance activity Popularity25 Limited adoption so far Community19 Small or concentrated contributor base Maturity70 Established project with proven stability Bus Factor2 2 contributors hold 50%+ of commits 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 ~324 days Recently: every ~392 days Total 7 Last Release 234d ago PHP version history (3 changes)1.0.0PHP ^7.2 1.0.2PHP ^7.4 1.1.0PHP ^7.4||^8.1 ### Community Maintainers ![](https://www.gravatar.com/avatar/a5e188393958c4505bb06d9e79ed99a47d1cd42551142f02ef364d8268449ef8?d=identicon)[fillup](/maintainers/fillup) ![](https://www.gravatar.com/avatar/836739aa4f60c754dc9a4a547ebd0c166e4b6e855d9f119df2be5aec92f3a375?d=identicon)[forevermatt](/maintainers/forevermatt) ![](https://www.gravatar.com/avatar/a0d56d7e6fc794910b03eff96448007ee05879ad38493f0b5f215c4fe61f4b30?d=identicon)[mtompset](/maintainers/mtompset) ![](https://www.gravatar.com/avatar/5256eacae3564eb6d3e954abc6552ed99a6d948d94d2b07cc1dc9dabb0bce108?d=identicon)[jason-jackson](/maintainers/jason-jackson) --- Top Contributors [![forevermatt](https://avatars.githubusercontent.com/u/6233204?v=4)](https://github.com/forevermatt "forevermatt (26 commits)")[![jason-jackson](https://avatars.githubusercontent.com/u/35783387?v=4)](https://github.com/jason-jackson "jason-jackson (15 commits)")[![mtompset](https://avatars.githubusercontent.com/u/10937901?v=4)](https://github.com/mtompset "mtompset (7 commits)")[![Baggerone](https://avatars.githubusercontent.com/u/8058522?v=4)](https://github.com/Baggerone "Baggerone (2 commits)")[![briskt](https://avatars.githubusercontent.com/u/3172830?v=4)](https://github.com/briskt "briskt (2 commits)")[![mend-bolt-for-github[bot]](https://avatars.githubusercontent.com/in/16809?v=4)](https://github.com/mend-bolt-for-github[bot] "mend-bolt-for-github[bot] (1 commits)") ### Code Quality TestsBehat ### Embed Badge ![Health badge](/badges/silinternational-google-sheets-php/health.svg) ``` [![Health](https://phpackages.com/badges/silinternational-google-sheets-php/health.svg)](https://phpackages.com/packages/silinternational-google-sheets-php) ``` ### 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) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)