Top "Google-sheets" questions

Use this tag for questions about interacting with Google Sheets programmatically.

How to convert Google spreadsheet's worksheet string id to integer index (GID)?

To export google spreadsheet's single worksheet to CSV, integer worksheet index(GID) is required to be passed. https://spreadsheets.google.…

google-sheets gdata-api google-spreadsheet-api gdata-python-client
Using Google Docs and Google Spreadsheet APIs for Android

I am planning on using the Google Documents List, and Google Documents Spreadsheet API's for uploading a database from my …

java android google-sheets google-apps google-sheets-api
Access Google spreadsheet API without auth token

I have created Google Spreadsheet, and given edit access to all (can edit even without login). Here is the link. …

google-sheets google-spreadsheet-api google-authentication google-developers-console
List names of sheets in Google Sheets and skip the first two

I found code to list the names of all the sheets in Google Sheets (from here): function SheetNames() { // Usage as …

google-apps-script google-sheets google-spreadsheet-api
I got this message (CANNOT_GROUP_WITHOUT_AGG) from a simple query

I how to fix this error message? Unable to parse query string for Function QUERY parameter 2: CANNOT_GROUP_WITHOUT_AGG …

google-sheets spreadsheet google-query-language
How to get scripts to work with phones and tablets

I'm writing scripts for a google docs spreadsheet that run when cells are edited using the onEdit function. So far …

google-apps-script google-sheets triggers mobile-devices
Google Sheets query doesn't display all values

I have a Google Sheet with the following query formula: =QUERY('Contact Changes'!B1:T,"SELECT C,D,E,F,…

google-sheets google-sheets-query
Google Sheets count how many cells contain a specific word / words?

I'm trying to look at all cells in a set of columns/cells to count how many of them contain …

google-sheets google-sheets-formula
External API call in Google Spreedsheet is possible?

I have created a Google Spreadsheet with five columns; Once the user filled the values in the first three columns, …

google-sheets spreadsheet google-spreadsheet-api
Google Sheets API v4 - How to get the last row with value?

How to get the last row with value in the new Google Sheets API v4 ? i use this to get …

android google-sheets google-drive-api google-spreadsheet-api