I know how it feels when waiting for somebodies support to handle an API bug while your application is going to not met deadlines defined. The issue you described really sound like a bug, so for “clean” solution you will have to wait until Google Sites team guys will resolve this bug (I already upvoted … Read more
Set/change your product name, I had this issue until I created a product name as same as project name. The product name can be set in the Consent screen section of the Google Developers Console for your project. Look under APIs & auth in the left navigation and select Consent screen. You need also to … Read more
It’s the API key as listed under ‘API Access’, the ‘Simple API Access’ box.
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