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,917
questions
-1
votes
0
answers
11
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
vote
1
answer
29
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. ...
0
votes
1
answer
23
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 ...
0
votes
1
answer
34
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 ...
0
votes
1
answer
13
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, ...
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
21
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....
0
votes
0
answers
29
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
24
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 ...
0
votes
1
answer
29
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
20
views
appscript Session.getActiveUserLocale not working when i tested it on my iphone
i am working on a gmail add-on i am trying to get the user's local language from the gmail settings using Session.getActiveUserLocale()
this is my function
function getUserLanguage() {
const ...
-1
votes
0
answers
13
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 ...
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 ...
-1
votes
0
answers
17
views
Value discrepancy between GA4 data in the interface versus the Analytics API [closed]
So I sent a single event via Postman for testing purposes with a value of 99.99. This is reflected in a custom report I created in the GA4 interface.
However, when I pulled that data via AppScript, it'...