Top "Google-sheets" questions

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

email notification if cell is changed

need help with google script. I have multiple row spreadsheet. Need a script that does the following: If any cell …

google-apps-script google-sheets google-spreadsheet-api
Getting Google Spreadsheet CSV into A Pandas Dataframe

I uploaded a file to Google spreadsheets (to make a publically accessible example IPython Notebook, with data) I was using …

python pandas google-sheets google-drive-api google-apps
How to convert a number into hours in Google Sheets

1950 minutes is 32.5 hours. How do I calculate this using a formula in Google Sheets? I am logging the number of …

google-sheets google-sheets-formula
Google spreadsheet API, 400 error bad request : unable to parse range

I am trying to access Google spreadsheets using a spreadsheet example. When I run the example code it worked fine. …

java google-sheets google-api-client
Conditional Formatting from another sheet

I'm trying to have a cell on Sheet A check if it's either > or < the value in a …

google-sheets gs-conditional-formatting
I need to capture the IP Address to google spreadsheet via google web form

I have designed a Google web form. This form is sent to number of clients. All the fields that are …

google-apps-script google-sheets google-forms
Spreadsheets get unique names but ignore blank cells

I would like to use spreadsheets to get all unique names from Column A in a table but in the …

google-sheets spreadsheet google-docs
Google Spreadsheet multiple column filter using OR

I have a Google Spreadsheet with 3 columns that are either blank or have a value. I want to get the …

google-sheets google-sheets-formula
Google Drive Spreadsheets: Combining IF and VLOOKUP

I'm trying to work out a formula for combining an IF statement and a VLOOPUP. Basically, I want the formula …

google-sheets gs-vlookup