Questions tagged [google-apps-script]

Use for questions about Google Apps Script, Google's JavaScript-based cloud scripting language for automating tasks across Google products and third party services.

0
votes
0answers
18 views

Write JSON from Hubspot Analytics API into a Google Spreadsheet - using google app scripts

I need your help.I'm trying to get analytics data from my Hubspot account into a Google Spreadsheet, so I can make some calculations with it and feed it into a Google Data Studio Dashboard.I'm ...
0
votes
0answers
20 views

Is it possible to pass variables between Javascript and Google Apps Script?

I have created a Google Apps Script Project including a Javascript script (as an HTML file as per Google Dev Best Practices). I do some simple arithmetic based on the location of click events within ...
0
votes
1answer
30 views

Get cell by value

How do I get the range of a cell using its value and column?Say I have this column:[ ][ A ][ 1 ][ hello ][ 2 ][ world ][ 3 ][ waaah ][ 4 ][ waaah ][ 5 ][ waaah ]Sheet: WALUIGI_SAYS_"HI"...
0
votes
1answer
22 views

How to create one spreadsheet for each row that also imports that whole row in Google Apps Script?

I'm a teacher looking to create individual spreadsheets for students based on an assessment. The students will be listed in column A, and I want each of them to receive the information from column A ...
-1
votes
1answer
26 views

write cell value based on an array of row numbers

I have the word "nice" that I want to write into a column. Normally I would get the range targetColumn.getRange(2, 7, sheetLR-1) and then just .setValue('nice') to write it into the desired rows of ...
0
votes
1answer
22 views

Apps Script : Timestamp is not copying properly

When I am copying timestamp from one sheet to another or in the same sheet only then it is not copying the time from the timestamp. It is only copying date. See the below image - Here is my code - ...
-1
votes
0answers
21 views

Query/Importrange via Google Apps Script

I have the below script working to 'importrange' from 1 sheet in an external google sheet.function myScriptedImportRange( ) { var values=SpreadsheetApp.openById('...
1
vote
1answer
36 views

Send data to google spreadsheet

I need to send my form data to Google spreadsheet so I stumbled upon this linkSubmit an HTML Form to Google SheetsIt all works fine. But when I change the name of the sheet it doesn't post data to ...
0
votes
1answer
30 views

Is it possible to copy a Google Document to Google AppScript?

Following line creates a new Google Document:DocumentApp.create('Hello, world!');Is it possible to create a copy of an existing Google Document using Google AppScript?
0
votes
0answers
21 views

Google Apps Script always failing due to permission issues

I have created a Google Apps Script file inside my Google Drive to perform daily backup of a Spreadsheet which I have shared with my colleagues. It works fine when I run it manually, but it fails when ...
0
votes
0answers
37 views

How to place this database (Ppto) on different sheets (MP04 / MP05)

Description:I have a sheet (Ppto) with a list of IDs, Credits(Cedente) and Debits(Receptor). I would like to move these transactions from this sheet to MP05, If Transaction amount and ID are equal....
0
votes
1answer
28 views

Sync Google Sheets with Web Page HTML

What is the easiest way I can sync a sync a google sheet with a web page form (see attached picture)? Ideally an example code or tutorial. Here is what I want: I want users to access my web page so ...
0
votes
1answer
59 views

Undocumented Sheet API limitation problems

I already looked at posts with people getting similar issues but couldn't find a clear answer.I try retrieve a 2D array of 264735 slots using this lines of code:var optionalArguments={...
1
vote
1answer
32 views

Compare two arrays, get rows numbers

I'm trying to break where I want to get to apart into smaller steps and questions so I can understand it better. I turned two columns (each containing email addresses, each from different sheets) into ...
1
vote
1answer
14 views

Data Studio Community Connector Deployment, Share and Access Questions

After we build a Data Studio Community Connector, we would deploy it.https://codelabs.developers.google.com/codelabs/community-connectors/#12And we will get a deployment ID.My Questions are:...
0
votes
0answers
24 views

Understanding doGet and doPost in GAS

I am new to deploying a Google App Script project as a web app. I am trying to use the doGet and doPost functions but the way they work is confusing, especially doPost. Here is my code:function ...
0
votes
1answer
24 views

Equations on numbers return NaN

The relevant bit of code is var cEnergy=Math.min(pEnergy-pwrCons+cCharge,totalBattCap);I run Logger.log(cEnergy) and it returns NaN. So I ran Logger.log(typeof()) on cEnergy, pEnergy, pwrCons, ...
0
votes
0answers
22 views

send chrome active URL from chrome extension to google app script(web app)

I want to send current active tab URL from chrome extension to google app script (deployed as a web app)at every 15 seconds to save it in google sheet. here is the code of chrome extension - ...
0
votes
1answer
26 views

programmatic access to google-sheets-api 'Insert Note' notes

Given a Google Sheets document, is there any way to programmatically access the notes produced from 'Insert Note' in the Google Sheets web interface?I searched in the Python v4 API documentation, ...
-2
votes
0answers
16 views

Google Sheets- Update row with new data from separate sheet

https://docs.google.com/spreadsheets/d/13YXoPeztK0w96B8Sjz_Jp-_BOmjYmlYKfb8QsYpt3Vg/edit?usp=sharingI would like to know how to have a separate sheet (New Data!) continually update the main sheet (...
0
votes
2answers
41 views

get first column in array

I have a sheet and need to get the values (email addresses) of a certain column, which is C in this case. Let's assume there are three emails in the column. The log gives me:"[[email1], [email2], [...
-1
votes
0answers
17 views

Google Apps Script Remove Duplicate rows

I have a script which currently splits one cell from form data which is working great.I simply need to remove any duplicate content before the script runs and splits out the data from the cell. They ...
0
votes
1answer
26 views

Script for BOM with multiple same item that need to be merged

I am new to coding, and working with google sheets and trying to write a script (or some other combination of formulas) that will spit out a BOM on a new sheet tab with all qty merged (we have ...
0
votes
0answers
20 views

Google Apps Script Chart vAxis.title not working

Something I'm writing in Google Apps Script for Google Sheets generates a chart. In trying to generate a graph I'd like to set axis titles so I can make the charts more understandable for people other ...
2
votes
0answers
17 views

Google Scripts User does not have sufficient permissions for this profile. Google Analytics

I am having issues with permissions while reading data from Google Analytics Demo Account to Google Sheets using Google Scripts.Here is my code:var tableId='ga:54516992'; // this is the correct ...
1
vote
0answers
23 views

Why am I receiving a CSP Error in my Google Apps Script File?

I'm having an issue with my Google Apps Script file. Its essentially mirroring a Room Reservation system and up until recently it started to have some issues. I'm having a Content Security Policy ...
0
votes
0answers
11 views

GAS - Building criteria for filter from range

I have a problem creating a criteria for the filter in the spreadsheet.My initial code worked for one creating a criteria for one variable. Basically i am taking a value from a cell and filter table ...
-1
votes
0answers
14 views

Can I edit googles default map labels and Landmarks info windows?

is there a way to edit googles default map labels and Landmarks info windows? For example, add my own text and images inside of the already existing info windows?Image with an info window:
0
votes
0answers
36 views

Offset text in HTML Select Option List

Can't work out why the following is happening in a selection list:<body><select><option value="This">This</option><option value="That">That</...
-2
votes
0answers
11 views

Need to translate one value into another value from a list

Full disclosure - not a programmer...I've just messed a good bit with Excel and Google Sheets, and am stuck trying to find a simple way to transform a specific set of data. Essentially, we have a ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,