Use this tag for questions about interacting with Google Sheets programmatically.
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-apiGoal: I'm using QUERY() in gSheets to combine data from multiple sheets in the same workbook. The data is an …
google-analytics google-sheets google-query-languageI want to calculate the product of two different columns (e.g., A & B) for each row on my …
google-sheetsHow do I add a formula like: =SUM(A1:A17) to a range of fields using the Google Apps Script …
google-apps-script google-sheets google-docsIs it possible in Google Spreadsheets to reach the value of the cell just above? Meaning: In one cell A2 …
reference google-sheets relative-pathI have a sheet with a column of unix epoch times (in seconds): 1500598288 How can I convert these into normal …
javascript datetime google-apps-script google-sheets epochThe employee sheet contains the name of the employee in cell C2. The name of the employee should also be …
google-apps-script google-sheets google-docs row-numberHow to create a new sheet in a Google Sheets with Google Apps Script? I know it seems obvious but …
google-apps-script google-sheetsThe scenario goes: Via email, a Google Form is sent to a respondent. Via this sent email, the respondent answers …
forms google-apps-script google-sheets google-formsI have a Google Sheet (example) with a basic vlookup to create a summable column. It returns "#N/A" for …
google-sheets