Top "Google-sheets" questions

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

Use a Google Forms to update existing Google Sheets

I'm trying to build a Google Forms that fills out certain cells of an existing Google Sheets with the responses …

forms google-apps-script google-sheets google-forms
Script import local CSV in Google Spreadsheet

How do I import a CSV file from local hard drive in a Google Spreadsheet document I own? (I want …

google-apps-script google-sheets import-from-csv
Is it possible to populate a google form from a google spreadsheet?

I'd like to create a form that uses the data from the spreadsheet, so that it's dynamic. Is it possible …

google-apps-script google-sheets google-forms
Write data into Google Spreadsheet w/ Java

I'm lost on this one. I'm trying to connect Java with Google spreadsheet, and although the API's documentation is complete …

java google-sheets google-drive-api google-spreadsheet-api
IMPORTRANGE function not refreshing new entries in linked Google sheet

My IMPORTRANGE function is not refreshing with new data once the linked spreadsheet is added to. Instead, I am having …

google-apps-script google-sheets google-forms importrange
How to export a csv from Google Sheet API?

I can't find any reference to an API that enables Rest API clients to export an existing Google Sheet to …

google-sheets r-googlesheets google-sheets-api
Python/gspread - how can I update multiple cells with DIFFERENT VALUES at once?

To update a range of cells, you use the following command. ## Select a range cell_list = worksheet.range('A1:A7…

python google-app-engine google-sheets gspread
FORECAST formula needed

I have this spreadsheet with some data in column A - Date, column B (keyword usage on a specific date …

google-sheets google-sheets-formula forecast
Extracting rootdomains from URL string in Google Sheets

Hi I am trying to extract the rootdomain from URL string in Google Sheets. I know how to get the …

web google-sheets spreadsheet
Debugging a custom function in Google Apps Script

I am trying to create my first custom function for a Google Spreadsheet in Apps Script and I am having …

debugging google-apps-script google-sheets google-docs google-sheets-custom-function