Go to https://developers.google.com/sheets/quickstart/php
Follow the first step.
Put your client_secret.json in to /app/config/
Execute command
app/console google-spreadsheet:set-credentials
$googleSpreadsheet = $this->container->get('dreamlex_google_spreadsheet');
$tableData = $googleSpreadsheet->getTable('1_ApzX0ZEpN79EL4v_rSpU1PxpgYYOCDKfet7_le0suM', 'IP!A2:B');Functions
getTable($spreadsheetId, $range = null)
createTable($title)
addPermissionTable($spreadsheetId, $email, $type = 'user', $role = 'writer', $sendNotificationEmail = false)
addRowTable($spreadsheetId, $range, $values)
updateRowTable($spreadsheetId, $range, $values)