I'm trying to connect to Amazon Selling Partner API using Google Apps Script. The first step based on the documentation is to generate an access token if we don
There are four ways to create a new file: DocsList - Shown as DocsList in the Main List. Built in to Apps Script. DriveApp - Shown as Drive in the Main List. B
I am trying to create a Google Form for an event registration. The admission charges to the event vary for the adults and children. An user can specify the numb
I would like to know if there's a way to automatically trigger a script every time a specific sheet, inside a worksheet, is selected. Looking around I found the
I'm running a templated google script that constructs an html page with the contents of a google spreadsheet. When I run the script with the spreadsheet https:
I'm Thomas and pretty new to appscript. I managed to use it in order to translate cells in a google sheet using DeepL API. I did it thanks to this post : https:
I've just learnt about arrayformula and continue for keeping formulas into new rows, now im trying to get a single string to copy into new rows "N". How can I a
I have a problem with my code. It seems fine but it doesn't work and I really don't know why. I tried everything. I want sync my google excel with my google c
enter image description here I want to import data from a table within an HTML page. Used IMPORTHTML =IMPORTHTML("https://www.fpi.nsdl.co.in/web/Reports/FPI_For
I have a simple form and I want to forward the response pages to my email address so I can click through straight to the result of that form submission. Using t
The spreadsheet has some cells with cell contents that are separated by commas, or a new line. 123, 876, 456 Column "C" is the column that determines whet
The spreadsheet has some cells with cell contents that are separated by commas, or a new line. 123, 876, 456 Column "C" is the column that determines whet
Good Day! I would like the Purchase Order ID repeated upon submission of a form in an earlier sheet. My current code however repeats this throughout the length
I am trying to show an alert popup when cell selection is changed, using the new trigger onSelectionChange. For some reason it is not showing any alerts. Am i d
I cant move my other contacts to my system group contacts via GAS var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var group = Co
Looking for some help please, I've been tinkering with the code now most of the day and im stuck, and this seems about the best solution I have found so far. I'
When creating a spreadsheet ex novo, Google's SpreadsheetApp allows one to specify the number of rows and columns of said spreadsheet: var spreadsheet = Spread
so basically the task is quite simple, but I didn't find any workable solution for my problem. I have a huge upload script on my website (at the moment localhos
In Google Drive I am trying to compare an id in a file name against folders named with that id, and if they match, to move that file to that folder. Some of the
I have a Google Apps Script custom function, very simple: function sharesBurned(sharesToSell) { return "tree" } Obviously, this works when I test it in