PHPackages manish-manghwani/google-spreadsheet-acolyte - 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. [Database & ORM](/categories/database) 4. / 5. manish-manghwani/google-spreadsheet-acolyte ActiveLibrary[Database & ORM](/categories/database) manish-manghwani/google-spreadsheet-acolyte =========================================== Package to insert data from google spreadheet into database v1.0.0(6y ago)134124[7 PRs](https://github.com/manish-manghwani/google-spreadsheet-acolyte/pulls)MITPHPPHP ^7.4 Since Jun 24Pushed 3y ago1 watchersCompare [ Source](https://github.com/manish-manghwani/google-spreadsheet-acolyte)[ Packagist](https://packagist.org/packages/manish-manghwani/google-spreadsheet-acolyte)[ Docs](https://github.com/manish-manghwani/google-spreadsheet-acolyte)[ RSS](/packages/manish-manghwani-google-spreadsheet-acolyte/feed)WikiDiscussions master Synced 3w ago READMEChangelog (1)Dependencies (1)Versions (10)Used By (0) google-spreadsheet-acolyte ========================== [](#google-spreadsheet-acolyte) [![Latest Version on Packagist](https://camo.githubusercontent.com/ee7e677add7169bb0c7919315b539931dc47eada2b07e3a3c53a20290313fbfa/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f6d616e6973682d6d616e676877616e692f676f6f676c652d73707265616473686565742d61636f6c7974652e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/manish-manghwani/google-spreadsheet-acolyte)[![Total Downloads](https://camo.githubusercontent.com/90e8d8ec398d16b130f8c655db1cc8d860634d90373f4c70ebcaaad7e727d7b6/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6d616e6973682d6d616e676877616e692f676f6f676c652d73707265616473686565742d61636f6c7974652e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/manish-manghwani/google-spreadsheet-acolyte) Laravel package to insert records from Google Spreadsheet This package allows you to hassle-free insert records directly from Google Spreadsheet into your desired table. It saves time to download the sheet into csv format and then write sql script to insert it into your database. Pre requisite ------------- [](#pre-requisite) 1. You need to have google account. 2. Login to your account via link 3. Create one project. 4. Enable Google Sheet API 5. Create Service Account 6. Download Credentials.json 7. Create one spreadsheet and shared it with your service account email id Add credentials.json file to your root directory and add it in .gitignore list Installation ------------ [](#installation) You can install the package via composer: ``` composer require manish-manghwani/google-spreadsheet-acolyte ``` Usage ----- [](#usage) 1. Get the Google Spreadsheet Url. It may look similiar to this 2. You should have name of the credential file that was dowloaded from service account (for eg: credentials.json) 3. You should have table name in which data will be inserted (for eg: dummy) With above things in place you can run below command. ``` php artisan import:sheet --file-url=https://docs.google.com/spreadsheets/d/1auqTdpciifOA6PH5JbSoxRFegdgdr48icvgwqsfWqrqI/edit#gid=0 --table-name=dummy --credentials-file-name=credentials ``` NOTE: 1. If sheet is not shared with service account email id, it will fail. 2. First row of spreadsheet must be exactly same as of columns present in table. 3. Spreadsheet name should not be changed it must be Sheet1 4. Data to be inserted must be present in Sheet1 Changelog --------- [](#changelog) Please see [CHANGELOG](CHANGELOG.md) for more information on what has changed recently. Contributing ------------ [](#contributing) Please see [CONTRIBUTING](CONTRIBUTING.md) for details. Security -------- [](#security) If you discover any security related issues, please email instead of using the issue tracker. Credits ------- [](#credits) - [Manish Manghwani](https://github.com/manish-manghwani) - [All Contributors](../../contributors) License ------- [](#license) The MIT License (MIT). Please see [License File](LICENSE.md) for more information. ### Health Score 32 — LowBetter than 69% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity22 Limited adoption so far Community13 Small or concentrated contributor base Maturity61 Established project with proven stability Bus Factor1 Top contributor holds 70.6% 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 2193d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/7fd221bfaefcd7ecf783cacc7447a68773b4e4cf0844996c56e4995124aa44fe?d=identicon)[manish-manghwani](/maintainers/manish-manghwani) --- Top Contributors [![manish-manghwani](https://avatars.githubusercontent.com/u/17725637?v=4)](https://github.com/manish-manghwani "manish-manghwani (12 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (3 commits)")[![rpandey1234](https://avatars.githubusercontent.com/u/336303?v=4)](https://github.com/rpandey1234 "rpandey1234 (2 commits)") --- Tags manish-manghwanigoogle-spreadsheet-acolyte ### Embed Badge ![Health badge](/badges/manish-manghwani-google-spreadsheet-acolyte/health.svg) ``` [![Health](https://phpackages.com/badges/manish-manghwani-google-spreadsheet-acolyte/health.svg)](https://phpackages.com/packages/manish-manghwani-google-spreadsheet-acolyte) ``` ### Alternatives [forkcms/forkcms Fork is an open source CMS that will rock your world. 1.2k45.2k](/packages/forkcms-forkcms)[flow-php/flow PHP ETL - Extract Transform Load - Data processing framework 84735.1k](/packages/flow-php-flow)[fleetbase/core-api Core Framework and Resources for Fleetbase API 1232.2k16](/packages/fleetbase-core-api)[chameleon-system/chameleon-base The Chameleon System core. 1027.9k4](/packages/chameleon-system-chameleon-base) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)