Add New sheet and data

controller.php

public function addOrderProperty()
{
    $sheets = Sheets::spreadsheet(config('sheets.post_spreadsheet_id'))->sheetList();
    $now = now()->year . '/' . now()->month;
    $id = Arr::get(array_flip($sheets), $now);

    if (is_null($id)) {

        $body = new \Google_Service_Sheets_BatchUpdateSpreadsheetRequest(array(
            'requests' => array(
                'addSheet' => array(
                    'properties' => array(
                        'title' => $now
                    )
                )
            )
        ));

        Sheets::getService()->spreadsheets->batchUpdate(config('sheets.post_spreadsheet_id'), $body);

        Sheets::spreadsheet(config('sheets.post_spreadsheet_id'))
            ->sheet($now)
            ->append([['SOURCE', 'USER/NAME', 'DEVICE', 'Date Of Arrival', 'Date Of Dispatch', 'Post Code', 'NOTE', 'Label', 'CANCELLED']]);

    }

    Sheets::spreadsheet(config('sheets.post_spreadsheet_id'))
        ->sheet($now)
        ->append([['BBC', 'ORRRR111', 'SAMPLE', '2/10', '03/13', 'RH1 111', '-', 'L', '']]);

    return ['success'];
}

public function getOrdersProperty()
{
    $sheets = Sheets::spreadsheet(config('sheets.post_spreadsheet_id'))
        ->sheet('Sheet1')
        ->get();

    $header = $sheets->pull(0);
    $values = Sheets::collection($header, $sheets);

    return $values->reverse();

// Blade
// @foreach($values as $value)
// {{ data_get($value, 'name') }}
// @endforeach
}