56,955 questions
0
votes
0
answers
18
views
Replace headers and footers across multiple Google Docs from a template using Apps Script
I have a Google Docs template with:
A branded first‑page header (logo, text, etc.) with “Different first page” checked
A footer that will appear on all pages, including the first page.
I need to ...
- 1
0
votes
1
answer
48
views
Export data columns to text files named via cell reference?
I would like to export columns from a google sheet such that the exported .txt files are named after the column heading. Is it possible to change the value of "column" + index below to be ...
- 1
1
vote
1
answer
26
views
I am trying to use the value in a cell as an address to paste to another cell in google sheets via apps scripts. Use cell F8 which = C6 to paste to C6
I would like to paste from one tab to the address of a cell in another tab, where the value changes.
The problem I'm trying to solve is: how do I write the Apps Script code so that:
var spreadsheet = ...
- 13
-1
votes
0
answers
21
views
Is it the bug? "Manage Deployments" -> "New Version" erroneously archives active deployment and creates a new "Untitled" instance [closed]
Component: Apps Script > Deployment / Web App
Description: I am experiencing a critical issue with the "Manage deployments" feature in the new Apps Script editor. When attempting to ...
0
votes
0
answers
22
views
Apps Script custom function result in Google Sheets being cached for cells where it has already been evaluated [duplicate]
Google Apps Script/Google Sheets issue...
The custom function in code.gs:
function SHEETNAME() {
return SpreadsheetApp.getActiveSheet().getName();
}
Then in Sheet1 cell A1 put:
=SHEETNAME()
A1 ...
- 1,133
2
votes
1
answer
66
views
How can I execute an Google Apps Script function on behalf of an user using an HTTP request with an access token in the header from an Android app?
I'm trying to make an online service for my Android app using Google Apps Script. The users simple log in to their Google Account inside the app, grant necessary permissions to the corresponding GCP ...
- 301
0
votes
1
answer
72
views
Prevent a new tab from opening when opening WhatsApp from Googlesheet OnEdit
as per below code, from GoogleSheet, I wanted WhatsApp to open with some specific text ready to be sent when user sets a cell to "Ready to Print". The problem is every time a column in ...
- 11
0
votes
0
answers
41
views
Google Script Cannot Fetch Users With Licenses (Via SKU ID)
I have recently gotten into Google Scripting to manage a School's IT space. I am currently working on a script that should check any students who have left and remove their paid licenses. However, I ...
2
votes
1
answer
99
views
GmailApp.sendEmail not working when rows arre added to Google sheet
I have an application (running on an IoT Boron device from Particle) that posts error messages to a Google sheet via a Webhook Web Form. The sheet serves as a log of application faults and this has ...
- 1
1
vote
1
answer
53
views
Copy and paste with .getValues / .setValues, but clearing the array inbetween
I have a table which looks like this:
I want to copy the first two columns of data and insert them before the EOF, but empty them before the paste. The end result should look like this:
So far, my ...
- 181
-2
votes
1
answer
41
views
Generate PDF won't render images [closed]
I am trying to create a simple Invoice generator that includes our company logo, but the logo will NOT render in the final PDF.
I am designing the invoice template using HTML instead of a Google Doc ...
0
votes
1
answer
65
views
Google Cloud log-based alert policy not triggering any incidents
I’m having trouble getting a log-based alert policy to work in Google Cloud Monitoring. I can see the logs in the Logs Explorer and the filter seems to match correctly, but the alert never triggers ...
0
votes
1
answer
71
views
How to apply cell background color as Theme color in google sheets via apps script?
Hopefully, the title is clear.
What I am NOT asking.
How to update the cells background color to match the Theme via hex color code.
How to update the spreadsheet theme colors themselves via appscript....
- 43
0
votes
1
answer
60
views
How replace the content of the active document?
I’m building a Google Docs add-on using React + Google Apps Script (via clasp). From the sidebar, I receive a .docx file as a Base64 string (binary content).
I can successfully convert the .docx to a ...
1
vote
3
answers
157
views
Comparing multiple flags at once
I have a script which checks the value of a series of flags before deciding on an execution pathway. Because of the way the script executes, the flag values are held as script properties, therefore ...
- 181
