Top "Google-sheets-api" questions

The Google Sheets API lets developers write third-party applications that read and modify any aspect of spreadsheets.

How can I access Google Sheet spreadsheets only with Javascript?

I want to access Google Spreadsheets using JavaScript only (no .NET, C#, Java, etc.) I came here and was shocked …

javascript google-api google-sheets-api google-data-api google-api-js-client
Accessing Google Spreadsheets with C# using Google Data API

I'm having some information in Google Spreadsheets as a single sheet. Is there any way by which I can read …

c# google-sheets google-api-dotnet-client google-data-api google-sheets-api
How do I access (read, write) Google Sheets spreadsheets with Python?

I am wondering if you can point me to an example of reading/writing to/from a google doc/spreadsheet …

python google-sheets google-api google-api-python-client google-sheets-api
How to connect Google Sheets to Database

I'm trying to auto-populate some raw data on a sheet in my google sheets file with a query. It doesn't …

google-sheets google-sheets-api
Google Sheets API returns "The caller does not have permission" when using server key

I've generated a server key in the API Manager and attempted to execute the following on my Mac: curl 'https://…

google-api google-sheets google-sheets-api
Hyperlink to a specific sheet

I would like to open a specific sheet of a Google Sheets from a hyperlink in another spreadsheet. I have …

google-sheets hyperlink google-api google-sheets-api
Import google spreadsheet data into google forms with app script

I searched the internet and I can't find a response to this nor the documentation for it. I need to …

javascript google-apps-script google-sheets google-sheets-api google-forms
Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential

I am trying to update Google sheet values. "Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or …

google-sheets-api
Linking to another tab in Google Sheets

I have a Google Sheets workbook with more than 70 tabs, or sheets, in it. In one of them, I have …

google-sheets google-sheets-api
How to convert Time into decimal float in Google Sheets using Script?

I want to convert the time HH:MM into H.xx Like I am getting it in this format: Sat …

google-apps-script google-sheets google-sheets-api