All Questions
Tagged with google-apps-script google-workspace
595 questions
-5
votes
0
answers
50
views
Creating a conditional function in Apps Script (Sheets) that auto-populates a new entry [closed]
I'm in the very early stages of building out this script, so any guidance is appreciated.
I have a Sheets document that inventories devices such as laptops. Each entry has a variety of columns ...
1
vote
0
answers
54
views
TypeError: dataTable.addRows is undefined in Charts.newDataTable() [closed]
I'm encountering a very strange issue in Google Apps Script and I'm hoping someone can shed some light on it. I'm getting a TypeError: dataTable.addRows is not a function when trying to build a ...
1
vote
0
answers
22
views
How connect by JDBC Service Apps Script to Oracle Database [duplicate]
In the JDBC Service documentation
'This service allows scripts to connect to JDBC-compliant databases, including Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle. See also the JDBC Guide .'
...
1
vote
0
answers
37
views
Issue with URL Whitelisting in Review Environment vs. Local Testing
I'm encountering an issue with my Google Workspace Marketplace app submission. The app was rejected because, during the review, an external URL appears to not be whitelisted. However, when I run the ...
0
votes
1
answer
50
views
Deployment not working upon switching accounts
I'm currently working on a Google Sheet that receives emails, and uses an app script to automate sending confirmation emails back. However, the email being used to send these confirmation emails out ...
0
votes
1
answer
67
views
Function to insert an image on a spreadsheet doesn't work well
I wrote code using GAS to summarize data and draw a graph.
I run this process every month and it had been working fine until now, but starting today it suddenly started giving errors.
The error ...
- 1
0
votes
0
answers
48
views
How to move my columns with my rows when trying to Autosort by due date
I am trying to Autosort some data by range so it can make my life easier. I don't know anything about coding and have been asking my friends. The main problem is when I manually start I can see the ...
0
votes
0
answers
70
views
"Access denied" when accessing Google Apps Script deployed web page, even with "Anyone" access setting
I have a web page deployed using Google Apps Script with access permissions set to "Anyone". However, when I try to access the page, I get an "Access denied" message and cannot ...
- 11
0
votes
0
answers
42
views
Correct 'from' field for sequential email sending in a thread using GmailApp
I work on problem sending main email and few reminders (not spam) after some time into same email address and thread.
I use google app scripts and it has built-in GmailApp. So this is my messaging ...
0
votes
0
answers
59
views
SpreadsheetApp getLastRow() returns an exception when other users are viewing the google sheet
We have been running an app script to clear a shared google sheet for many years. All teachers are able to view this sheet as it is used for after school dismissal. The script has always been ...
0
votes
0
answers
22
views
Authorization Error When Running Google Apps Script [duplicate]
I'm trying to run a script that sends emails to recipients listed in a Google Sheet. However, when I attempt to execute the script, I encounter an issue:
The "Authorization Required" prompt ...
0
votes
0
answers
30
views
Google scripts authentication access errors
I have a Google Script app running on my Google Sites pages. The app is essentially a form that collects data from external users and sends it to my Firebase account. I want all external users to be ...
0
votes
1
answer
102
views
CORS in google apps script
I wanted to know how to implement CORS in google apps script. I am facing issue while fetching data(GET REQUEST) from google sheet using web app of google apps script.
GET request :
Sending get ...
2
votes
1
answer
151
views
Google Forms & AppsScript : How to programmatically set "Collect Email Addresses" to VERIFIED
we have a Google Workspace, and in it I have written a script that dynamically generates Google Forms. I want the forms to collect the respondent's verifiable email address. However when I set form....
- 29
0
votes
0
answers
58
views
Issue with Automating Google Ads (Pmax Campaign) Budget Using Google Ads Script
I am trying to use Google Ads Script to automate budget adjustments for only Pmax campaigns. The idea is to use a Google Sheet as a centralized planning tool where we manually specify campaign names ...
- 1