I have exactly the same issue, and it seems that so far (March 2018) Sheets v4 API does not allow to search by value, returning cell address. The solution I found somewhere here on StackOverflow is to use a formula. The formula can be created in an arbitrary sheet each time you want to find … Read more
Firstly delete the credentials files ~/.credentials/sheets.googleapis.com-nodejs-quickstart.json (depending on your setting) Change the scope variable used for reading cells from Google Spreadsheets from var SCOPES = [‘https://www.googleapis.com/auth/spreadsheets.readonly’]; to var SCOPES = [‘https://www.googleapis.com/auth/spreadsheets’]; After the execution of code, API will authenticate again and then the issue will be resolved.
(Jun-Dec 2016) Most answers here are now out-of-date as: 1) GData APIs are the previous generation of Google APIs, and that’s why it was hard for @Josh Brown to find that old GData Docs API documentation. While not all GData APIs have been deprecated, all newer Google APIs do not use the Google Data protocol; … Read more
According to the .NET user guide: Download the .NET client library: Add these using statements: using Google.GData.Client; using Google.GData.Extensions; using Google.GData.Spreadsheets; Authenticate: SpreadsheetsService myService = new SpreadsheetsService(“exampleCo-exampleApp-1”); myService.setUserCredentials(“jo@gmail.com”, “mypassword”); Get a list of spreadsheets: SpreadsheetQuery query = new SpreadsheetQuery(); SpreadsheetFeed feed = myService.Query(query); Console.WriteLine(“Your spreadsheets: “); foreach (SpreadsheetEntry entry in feed.Entries) { Console.WriteLine(entry.Title.Text); } Given … Read more
I have created a simple javascript library that retrieves google spreadsheet data (if they are published) via the JSON api: https://github.com/mikeymckay/google-spreadsheet-javascript You can see it in action here: http://mikeymckay.github.com/google-spreadsheet-javascript/sample.html
To solve this issue, try to: Create a service account: https://console.developers.google.com/iam-admin/serviceaccounts/ In options, create a key: this key is your usual client_secret.json – use it the same way Make the role owner for the service account (Member name = service account ID = service account email ex: thomasapp@appname-201813.iam.gserviceaccount.com Copy the email address of your service … Read more