PHPackages sil-org/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. sil-org/google-sheets-php ActiveLibrary sil-org/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)103101MITPHPPHP ^7.4||^8.1 Since May 28Pushed 6mo ago5 watchersCompare [ Source](https://github.com/sil-org/google-sheets-php)[ Packagist](https://packagist.org/packages/sil-org/google-sheets-php)[ RSS](/packages/sil-org-google-sheets-php/feed)WikiDiscussions main Synced 1mo ago READMEChangelog (7)Dependencies (5)Versions (8)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 47 — FairBetter than 94% of packages Maintenance64 Regular maintenance activity Popularity23 Limited adoption so far Community20 Small or concentrated contributor base Maturity69 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 235d 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/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) ![](https://www.gravatar.com/avatar/1948ad6f3cf2b7f0b3ca357e8014830ceb955d79f8e13777288c6bd3ed1b8545?d=identicon)[Schparky](/maintainers/Schparky) ![](https://www.gravatar.com/avatar/4af996082efafeccd517cb8e86c671d40d492f2b7a2a0202aabf49153272ca3c?d=identicon)[devon-sil](/maintainers/devon-sil) --- 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/sil-org-google-sheets-php/health.svg) ``` [![Health](https://phpackages.com/badges/sil-org-google-sheets-php/health.svg)](https://phpackages.com/packages/sil-org-google-sheets-php) ``` ### 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)