maatify / google-sheet

5.0.1 2025-08-10 05:15 UTC

Requires

• google/apiclient: ^2.15
• maatify/logger: ^5

proprietary

• Mohamed Abdulalim
• Ahmed Fawzy
• Ahmed Abdullah
• Elmokhtar Ahmed

• php
• google
• handler
• sheet

Published on Packagist.org on 2025-08-10 05:16 UTC

README

GoogleSheet

maatify.dev Google Sheet handler, read and write to google sheet, known by our team

Installation

composer require maatify/google-sheet

Usage 1- Create Class

    <?php

    namespace GoogleSheet;

    use Maatify\GoogleSheet\SheetHandler;

    class GSheet extends SheetHandler
    {
        protected string $credentials_file = __DIR__ . 'Json credintals location',
            $spread_sheet_Id = 'sheet id 1uxGes9CR1mvdshgsdfhg',
            $spread_sheet_range = 'sheet!A:Z';

        private static self $instance;

        public static function obj(): self
        {
            if(empty(self::$instance))
            {
                self::$instance = new self();
            }
            return self::$instance;
        }
    }

• to read sheet as array

    GoogleSheet\GSheet::obj()->ReadAll();

• to insert array to row

    GoogleSheet\GSheet::obj()->WriteRow();