API | True Light Designs Blog

Get a service account key from https://console.cloud.google.com/apis/credentials (You can here also restrict what this keys is allowed todo)
1. When creating, make sure you click the Furnish a new private key
2. Select JSON when it asks you how to download the key.
The service account key you have just generated includes a client_email.
1. Go to you google spreadsheet and allow this client_email to have write access on this document

$sheet_name = "Sheet1";
$google_client = new \Google_Client();
$google_client->setApplicationName('Google Sheets Updater');
$google_client->setScopes([\Google_Service_Sheets::SPREADSHEETS]);
$google_client->setAuthConfig(storage_path('jsondownload.json'));
$service = new \Google_Service_Sheets($google_client);
$spreadsheet_id = 'your_sheet_id';
$range = $sheet_name.'!A:C';
$params = [
   'valueInputOption' => "USER_ENTERED"
];
$value_array = ["1","2","3","4","5","6"];
$body = new \Google_Service_Sheets_ValueRange([
   'values' => [$value_array]
]);
$service->spreadsheets_values->append($spreadsheet_id, $range, $body, $params);

$sheet_name = "Sheet1";

$google_client = new \Google_Client();

$google_client->setApplicationName('Google Sheets Updater');

$google_client->setScopes([\Google_Service_Sheets::SPREADSHEETS]);

$google_client->setAuthConfig(storage_path('jsondownload.json'));

$service = new \Google_Service_Sheets($google_client);

$spreadsheet_id = 'your_sheet_id';

$range = $sheet_name.'!A:C';

$params = [

'valueInputOption' => "USER_ENTERED"

];

$value_array = ["1","2","3","4","5","6"];

$body = new \Google_Service_Sheets_ValueRange([

'values' => [$value_array]

]);

$service->spreadsheets_values->append($spreadsheet_id, $range, $body, $params);

https://stackoverflow.com/questions/44045183/access-google-spreadsheet-api-without-auth-token

The illusive Reference String. A client needed to pull their reviews from google and after research I found out that I needed to use the getDetails() method to gather this information. Upon going to their API docs, I was left with this

This method takes a request, containing the desired Place’s reference value.

If only they told you how to get the value…ugh… After playing around with it, I found that the textSearch() method included this value in its response. I put together a client side script that uses a jQuery geocomplete plugin to get the lat/lng to pass the textSearch() method to retrieve the Reference String. You only need to know the address of place you are searching for.

I am not going to provide the script for it, but if you view source you can pull the appropriate code. ——> Find Google Places Reference String Now

Category Archives: API

How to write to Google Sheet with API in PHP

Finding the Google Places Reference String

Categories

Recent Posts