Use this tag for questions about interacting with Google Sheets programmatically.
I have made a form to capture 2 data. Email address. Group which user wants to subscribe to. Each group has …
google-apps-script google-sheets google-formsI'm looking for a clean(er) way (than using SUMIF with a third row) to calculate the sum of the …
google-sheets gs-vlookupI have a Google spreadsheet with basically a dictionary of key/value pairs. Keys are unique. In a second sheet …
google-sheets array-formulas gs-vlookupI can't get which libs i should use for developing an Android app that menages Google spreadsheet. I need connecting, …
java android api google-sheets google-drive-apiI have a google app script which submits info to an organized sheet and would like to create a pivot …
google-apps-script google-sheets pivot-tableDoes anyone have a good C# example for updating a cell with the v4 API? I have the get cell …
c# google-sheets google-api google-sheets-api google-api-dotnet-clientI have 15 sheets that use the same template, for 15 different users. I would like to make a query on all …
google-sheets google-sheets-queryI want to highlight the cell in column A if it is repeated anywhere in column B. For example: A | …
google-sheets gs-conditional-formatting google-sheets-formulaI am trying to connect google sheet with power bi using R Studio, there is a video on youtube by …
google-sheets powerbi powerbi-datasourceConverting from an Excel file (where this works fine), I have a SUMIFS formula that is returning an error "Array …
google-sheets sumifs