Top "Google-sheets" questions

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

How can I check if the values of multiple cells are equal?

Let's say I have 6 different cells (that are not all in a line). I want to check if the values …

google-sheets worksheet-function formulas
Filter a range by array

I have a Google Spreadsheet containing the teams of the UEFA EURO 2012, and their scores: Team Points Goals scored ------ …

filter google-sheets google-sheets-formula
How to extract URL from Link in Google Sheets using a formula?

I have copied from a website a series of hyperlinks and pasted them in a google sheet. The values show …

google-sheets formula
Create Google Calendar Events from Spreadsheet but prevent duplicates

I'm trying to write a script that will take data from a Google spreadsheet and create events in my Google …

google-apps-script google-sheets google-calendar-api
How do I edit the response of a form submission in Google Forms/Sheets?

Recently, I've been conducting a survey. I began creating it in Excel Forms Online but switched to Google Forms after …

google-apps-script google-sheets google-forms editing
Pushing data to Google spreadsheet through JavaScript running in browser

I am working on an web application where I would like to allow the user to push data to her …

javascript jsonp google-sheets cors google-spreadsheet-api
Import JSON data into Google Sheets

I am pulling data from a web service and it is formatted as JSON. I am writing a Google Apps …

json google-apps-script google-sheets
How to assign a unique ID to a google form input?

Google Forms - I have set up a google form and I want to assign a unique id each of …

google-sheets google-forms
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
On Google Spreadsheet how can you query 'GoogleFinance' for a past exchange rate?

I'd like to know if it is possible to query a past exchange rate on Google Spreadsheet. For example; using …

google-sheets google-docs currency-exchange-rates