PHPackages ceytek-labs/google-services-lite - 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. ceytek-labs/google-services-lite ActiveLibrary[API Development](/categories/api) ceytek-labs/google-services-lite ================================ A lightweight library for seamless integration with various Google APIs in PHP. v1.7.1(1y ago)051MITPHPPHP ^7.0|^8.0 Since Oct 1Pushed 1y agoCompare [ Source](https://github.com/ceytek-labs/google-services-lite)[ Packagist](https://packagist.org/packages/ceytek-labs/google-services-lite)[ Docs](https://github.com/ceytek-labs/google-services-lite)[ RSS](/packages/ceytek-labs-google-services-lite/feed)WikiDiscussions 1.x Synced 1mo ago READMEChangelogDependencies (1)Versions (27)Used By (0) [![Google Services Lite](https://raw.githubusercontent.com/ceytek-labs/google-services-lite/refs/heads/1.x/art/banner.png)](https://raw.githubusercontent.com/ceytek-labs/google-services-lite/refs/heads/1.x/art/banner.png) [![Total Downloads](https://camo.githubusercontent.com/b65166fc88ac7d92e74a4d4b58274f8e58df3d11b57627a8cc5bc8c48126f9f0/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f63657974656b2d6c6162732f676f6f676c652d73657276696365732d6c697465)](https://packagist.org/packages/ceytek-labs/google-services-lite) [![Latest Version](https://camo.githubusercontent.com/70a555df6a7a159fa4bbd0f271afe4633dcdd326da6acdb0b066166d68c9981f/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f63657974656b2d6c6162732f676f6f676c652d73657276696365732d6c697465)](https://packagist.org/packages/ceytek-labs/google-services-lite) [![Size](https://camo.githubusercontent.com/055e6ce8429749995ef6ad48f596a293e236d9060be0fca6cc37d01ad0140f86/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f7265706f2d73697a652f63657974656b2d6c6162732f676f6f676c652d73657276696365732d6c697465)](https://packagist.org/packages/ceytek-labs/google-services-lite) [![License](https://camo.githubusercontent.com/89777ee265380c9a109cee6913aeb9a7aa1734f38edc58fe8572aafae2170f95/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f6c2f63657974656b2d6c6162732f676f6f676c652d73657276696365732d6c697465)](https://packagist.org/packages/ceytek-labs/google-services-lite) --- Google Services Lite - Google API for PHP ========================================= [](#google-services-lite---google-api-for-php) **Google Services Lite** is a lightweight and extendable library designed to help you manage data easily using the Google Sheets API in your PHP projects. Currently, it only supports the Google Sheets API, but future versions will include support for YouTube and other Google services. > **Disclaimer:** This package is not an official product of Google. The developers accept no responsibility for any issues, discrepancies, or damages that may arise from its use. Requirements ------------ [](#requirements) - PHP 7.0 or higher (including PHP 8) Installation ------------ [](#installation) You can add this package to your projects via Composer: ``` composer require ceytek-labs/google-services-lite ``` Services -------- [](#services) - [Google Sheets](#google-sheets) - [How to use](#google-sheets-how-to-use) - [Update](#google-sheets-update) - [Update in chunks](#google-sheets-update-in-chunks) - [Batch update](#google-sheets-batch-update) - [Batch update in chunks](#google-sheets-batch-update-in-chunks) Google Sheets ------------- [](#google-sheets) This package offers a streamlined integration with the Google Sheets API for PHP, focusing on effortless data updates within Google Sheets. Perfect for automating and enhancing your application’s data management. ### Example Usage [](#example-usage) The following example demonstrates how to manage data in a **Google Sheets** document: **[⬆ Back to services](#services)** #### Google Sheets: How to use [](#google-sheets-how-to-use) To use the Google Sheets API, you need to download the required authentication file and add it to your project’s root directory. Follow the steps below to set this up: - Create a project in the Google Cloud Console. - Enable the Google Sheets API for your project. - Create authentication credentials for a "Service Account." - Download the authentication JSON file and save it in your project’s root directory as `credentials.json`. - Share the email address from the service account with the Google Sheets document you want to modify, giving it edit access. - Don’t forget to note the sheet’s ID and the name of the tab you want to modify: - `https://docs.google.com/spreadsheets/d/` **[⬆ Back to services](#services)** #### Google Sheets: Update [](#google-sheets-update) Updates the specified Google Sheets tab with the provided data, replacing all existing values. It returns the number of cells that were updated. ``` use CeytekLabs\GoogleServicesLite\GoogleSheets; $result = GoogleSheets::make('SPREADSHEET_ID') // Set the ID of the Google Sheets document ->setCredentials(__DIR__.'/credentials.json') // Set the authentication file ->update('Sheet1', [ // Set the name of the tab where data will be updated ["Data 1", "Data 2", "Data 3"], // Add the data to be updated ["Data 4", "Data 5", "Data 6"], ["Data 7", "Data 8", "Data 9"], ]); echo 'Number of updated cells: ' . $result['updated_cells_count']; ``` **[⬆ Back to services](#services)** #### Google Sheets: Update in chunks [](#google-sheets-update-in-chunks) Similar to `update`, but handles large datasets by splitting the data into smaller chunks to prevent exceeding API limits. It returns the total number of updated cells. ``` use CeytekLabs\GoogleServicesLite\GoogleSheets; $result = GoogleSheets::make('SPREADSHEET_ID') // Set the ID of the Google Sheets document ->setCredentials(__DIR__.'/credentials.json') // Set the authentication file ->updateInChunks('Sheet1', [ // Update data in smaller chunks ["Data 1", "Data 2", "Data 3"], // Add the data to be updated ["Data 4", "Data 5", "Data 6"], ["Data 7", "Data 8", "Data 9"], // For large datasets, the data will be split into chunks ], 50); // Define the chunk size (e.g., 50 rows) echo 'Number of updated cells: ' . $result['updated_cells_count']; ``` **[⬆ Back to services](#services)** #### Google Sheets: Batch update [](#google-sheets-batch-update) Updates specific cells in a Google Sheets tab using a batch request, allowing more granular control over each cell. It returns the status of the update (success or failure). ``` use CeytekLabs\GoogleServicesLite\GoogleSheets; $result = GoogleSheets::make('SPREADSHEET_ID') // Set the ID of the Google Sheets document ->setCredentials(__DIR__.'/credentials.json') // Set the authentication file ->batchUpdate('Sheet1', [ // Set the name of the tab where data will be updated ["Data 1", "Data 2", "Data 3"], // Add the data to be updated ["Data 4", "Data 5", "Data 6"], ["Data 7", "Data 8", "Data 9"], ]); echo 'Batch update status: ' . ($result['status'] ? 'Success' : 'Failed'); ``` **[⬆ Back to services](#services)** #### Google Sheets: Batch update in chunks [](#google-sheets-batch-update-in-chunks) Similar to `batchUpdate`, but handles large datasets by splitting the data into smaller chunks to prevent exceeding API limits. It returns the status of the update (success or failure). ``` use CeytekLabs\GoogleServicesLite\GoogleSheets; $result = GoogleSheets::make('SPREADSHEET_ID') // Set the ID of the Google Sheets document ->setCredentials(__DIR__.'/credentials.json') // Set the authentication file ->batchUpdateInChunks('Sheet1', [ // Update data in smaller chunks ["Data 1", "Data 2", "Data 3"], // Add the data to be updated ["Data 4", "Data 5", "Data 6"], ["Data 7", "Data 8", "Data 9"], // For large datasets, the data will be split into chunks ], 750); // Define the chunk size (e.g., 750 rows) echo 'Number of updated cells: ' . $result['updated_cells_count']; ``` Contributing ------------ [](#contributing) Feel free to submit a **pull request** or report an issue. Any contributions and feedback are highly appreciated! License ------- [](#license) This project is licensed under the MIT License. ### Health Score 29 — LowBetter than 60% of packages Maintenance38 Infrequent updates — may be unmaintained Popularity8 Limited adoption so far Community6 Small or concentrated contributor base Maturity54 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 ~1 days Total 26 Last Release 549d ago PHP version history (4 changes)v1.0.0PHP ^7.4 v1.0.1PHP ^7.2 v1.3.0PHP ^7.0 v1.7.0PHP ^7.0|^8.0 ### Community Maintainers ![](https://www.gravatar.com/avatar/dd04f7a68c28475cb5493f3d841a7ae95ad200188efb658e1a37e30a5f2ba6db?d=identicon)[ceyhun-celik](/maintainers/ceyhun-celik) --- Top Contributors [![ceyhun-celik](https://avatars.githubusercontent.com/u/112348956?v=4)](https://github.com/ceyhun-celik "ceyhun-celik (25 commits)") --- Tags automationdata-updatesgoogle-apigoogle-servicesgoogle-services-litegoogle-sheetslite-libraryphpsheets-automationphpautomationgoogle apigoogle-sheetslite librarydata updatesGoogle Servicessheets automationgoogle-services-lite ### Embed Badge ![Health badge](/badges/ceytek-labs-google-services-lite/health.svg) ``` [![Health](https://phpackages.com/badges/ceytek-labs-google-services-lite/health.svg)](https://phpackages.com/packages/ceytek-labs-google-services-lite) ``` ### Alternatives [x-fran/g-trends Google Trends API for PHP 11955.6k](/packages/x-fran-g-trends)[happyr/google-api-bundle A Symfony2 Wrapper for the Google APIs Client Library for PHP 48196.1k](/packages/happyr-google-api-bundle)[sahusoftcom/youtube-livestream-api PHP (Laravel) Package for Google / YouTube API of Video Live Streaming with Google Auth 451.1k](/packages/sahusoftcom-youtube-livestream-api) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)