Questions tagged [google-apps-script]
Use for questions about Google Apps Script, Google's server side Javascript V8-based cloud scripting platform for automating tasks across Google products and third-party services. Use in addition to relevant product-specific (e.g. [google-sheets], [google-docs]) or API-specific (e.g. [google-drive-api]) tags where applicable
google-apps-script
54,899
questions
0
votes
0
answers
11
views
How do I do Radio Buttons on Google Sheets with Check Marks across the entire page instead of one column or row?
So, I have some various sheets setup stuff. so on the sheet. I have checkboxes across the sheet in multiple places:
1. Cells (these are merged 2x2 i.e. C6,C7,D6,D7) C6:C17
2. Cells E19:E25, L19:L25, ...
-1
votes
0
answers
17
views
Cannot get .getRange nor .getDataRange to work
I cannot figure out why my script generates the same error regardless of what I try.I have attached a copy of my appscript as well as my google sheet.
Order ID Lineitem sku Email Lineitem name ...
- 1
1
vote
1
answer
32
views
HTML Templates Overlapping in Google Sheets
Previously, when I created two HTML templates, opening the second template would automatically close the previous one, ensuring that only one HTML template was visible on the screen at any time. ...
- 11
0
votes
1
answer
25
views
Convert a MS DOCX file to Google Docs using a narrow Drive.file scope using google apps script [duplicate]
Question
I'm working with the Google Drive API and Google Picker API to convert DOCX files to Google Docs format. However, I'm encountering issues when using the narrow drive.file scope for ...
- 3,179
0
votes
1
answer
35
views
Error: Service Invoked too many times (Email Send)
I have a script that gets the specific draft from Gmail to send the email. It sent 10-15 emails and then started throwing error:
Service invoked too many times for one day: email.
Here is the code ...
- 419
0
votes
1
answer
14
views
How to Automate Exporting Google Docs to Markdown Using Google Apps Script?
I'm trying to automate the process of exporting Google Docs to Markdown format using Google Apps Script. I have noticed that when I go to a Google Doc, there are several export options available, ...
- 385
0
votes
0
answers
11
views
doPost Triggered by Slack Not Calling Function from Different File in Same Project
I'm facing an issue with my Google Apps Script project and could use some help.
Short Summary: I have a project with three .gs files. One of them contains a doPost function that is triggered by Slack. ...
0
votes
1
answer
23
views
How can I "get" a Google sheet through App Scripts?
I'm trying to connect a Google Sheet to Qualtrics. And keep running into this error: Sheet "Completion_Codes" not found.
Here's the script:
function doGet() {
var sheet = SpreadsheetApp....
- 1
0
votes
0
answers
30
views
Time zone settings in Google Apps Script inaccurate
I can not get google sheets and google apps script to align with the current time zone. Daylight Saving appears to throw it off. Does this happen automatically? Currently, apps script "Central ...
0
votes
0
answers
26
views
Unable to terminate script from executions UI
I'm running into an issue where I am attempting to terminate my script from the executions tab UI, however, when I click on the three dots related to the running unction the terminate option is grayed ...
- 1
0
votes
1
answer
30
views
Can someone help me fix/improve this code to send automatic emails to clients for their birthdays
Right now the main issue is that it is not recognizing the birthdays and labeling them as invalid. So it is not sending the emails. This is from google sheets to google appscripts.
In the spread sheet ...
0
votes
1
answer
23
views
appscript Session.getActiveUserLocale not working when i tested it on my iphone
I'm working on a gmail add-on and I'm trying to get the user's local language from the gmail settings using Session.getActiveUserLocale()
The code:
function getUserLanguage() {
const locale = ...
-1
votes
0
answers
14
views
Is it possible to attach or create an audience or audience segment to an existing video campaign or ads group
I'm trying to mutate campaigns and ad groups using my platform, but i keep getting 'Mutate not allowed' when the type of the campaign is Video. So is there any possibility to at least attach or create ...
0
votes
1
answer
18
views
I want to place 3 items in the Google tables dialog box with a choice of the answer from the text
For some reason, the dialog box currently works with only one list. The rest of the lists are ignored and do not want to appear in the specified cells. I tried to solve the problem in various ways and ...
- 1
0
votes
0
answers
20
views
Google sheets weekly data tracking of cell changes
I am looking for a way to track changes to cells on a weekly basis. As you will see from the photo, a variety of cells have numbers in them, which will change every day. I need a way to track changes ...
