All Questions
Tagged with google-workspace google-apps-script
551
questions
0
votes
1
answer
15
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
-1
votes
0
answers
27
views
Having trouble sending mails from google app script [closed]
I'm trying to build a simple CRM for my small business with as many processes automated as possible. I'm building it in Google Sheets. I have two problems at this time.
I want the system to send me an ...
- 1
-1
votes
0
answers
20
views
Connecting a google sheets to a google calendar [closed]
I'm working on our marketing campaign master plan that has a lot of moving pieces including types of campaigns, platforms to post, person in charge and date it needs to go out. I want to put into a ...
0
votes
0
answers
25
views
Error: Service invoked too many times for one day: premium gmail [closed]
I am running a manual Apps Script from the Editor on GMAIL and I keep getting
9:29:26 AM Notice Execution started
9:29:35 AM Info Error: Service invoked too many times for one day: premium gmail....
0
votes
1
answer
33
views
Google Doc eSignatures Break App Scripting
TLDR: Adding Google's eSignature field to documents revokes script access. I used openById to be sure this was the issue and it was...
I was creating a script to pull dates from a set of google docs. ...
-2
votes
0
answers
20
views
Sorry, unable to open the file at this time. Please check the address and try again [closed]
How do I fix this issue? I already tried logging out, logging back in, using incognito, using other devices.
This is my webapp. After logging in this is what it says.
I've already tried every ...
-1
votes
0
answers
17
views
Exception: The document is inaccessible. Please try again later
I am having issue to run auto fill in spreadsheet. So basically I want data in my spreadsheet to be auto filled in my google docs. Can someone help me to resolve this issue? Thank you. Below I attach ...
0
votes
1
answer
24
views
App Script Project deleted - how to restore it?
I deleted a project by mistake and can't retrieve it. Is there any way to restore it?
I tried restoring an earlier version of the gsheet file to which the app script project was linked. I have tried ...
0
votes
0
answers
29
views
AppScript WebApp File Upload Error: "Cannot read properties of undefined (reading 'getFoldersByName')"
I'm developing an Apps Script WebApp that includes an upload function. This function should allow users to upload a file from their machine to Google Drive and allocate it to a specific folder based ...
-1
votes
0
answers
31
views
Service invoked too many times in a day: urlfetch
Today suddenly my app script stopped working with the message "Service invoked too many times in a day: urlfetch" though I haven't reached the daily limit yet. I've checked the execution ...
-3
votes
1
answer
40
views
Which user account’s authorizations are used by a calendar sync function?
I think the title is self-explanatory, but here are some options I can think of:
the account of the calendar owner
The account of the user who created the calendar event
- 19
1
vote
1
answer
35
views
"Invalid deployment ID" error while setting configuration of Google Chat API
I am trying to create a google chat app but I am getting "Invalid deployment ID" error
I am trying to create a google chat app and publishing using the instructions written in https://...
0
votes
1
answer
74
views
How does the execution happen when a Google Apps Script is run as a webapp?
I'm trying to understand how an Google Apps Script deployment actually work, and my question has two parts:
When an Apps Script is run as a web application, and multiple users access it using the ...
- 7,973
1
vote
1
answer
25
views
Google Apps Script is not exporting PDF blob correctly
I am scripting a tool that creates a copy from Google Slide file (a template) and replaces some data in the Slides with data from a Spreadsheet. Then it adds the link to the file in the same ...
-1
votes
1
answer
26
views
onEdit event triggers when a row is deleted
I am using onEdit trigger in Google Sheet to send an email notification based on cell changes with certain conditions. That works fine, but the trigger also fires when a row is deleted and I get an ...
0
votes
1
answer
31
views
How do I stop trigger error notiification email messages
How do I stop these messages? I have not used this for years and I do not see where to resolve. I click on the "click here" and it says that I have no triggers set up.
I click on the "...
-2
votes
1
answer
76
views
Google Workspace sandbox environment
I'd like to test a Google Apps Script that I'm building and I'm looking for a place to test it. It's a script that will be executed by a service account and collecting information on users in an OU. ...
- 1
0
votes
1
answer
30
views
Server Error when trying to use LockService functions
I have a Looker Studio custom connector written in Google Apps Script. In the connector, I am using the LockService's tryLock(), hasLock(), and releaseLock() functions to prevent concurrent execution ...
1
vote
0
answers
61
views
Avoid/Clear UrlFetchApp cache when fetching a RSS feedin Google Script
I encounter a problem on Google Apps Script.
The use of the script is to get RSS feed URLs to fetch from a Google Sheet and if new article(s) are detected (comparing the GUIDs from the fetch to a GUID ...
- 11
0
votes
0
answers
18
views
createSubscription is not working for the meeting recorded through different account of same domain
I have an appscript code to get notification with recording details on an endpoint of our application whenever a google meet recording gets created. This code is working fine when I use the same ...
0
votes
1
answer
33
views
Google workspace add-on install trigger with toolbar failed
It is very weird! The same code(attached below), user take diff installation ways, diff effects.
Success situation:
User A -> click menu item in Add-on menu to install trigger(Google sheet onEdit ...
- 1
0
votes
1
answer
41
views
Onedit update cells use row ID in B2 to locate row line
I'm trying to make a customer profile page to make viewing selected clients easy on the eye and to edit. I want to edit and update on edit the data from the easy on the eye section (cells B3, B5, C3, ...
- 21
1
vote
1
answer
214
views
Getting an Internal Server Error when I try to edit my App Script
I have been working on a Google Sheet linked to a Google Form. I created a app script and tested it to work fine. Then I closed the App script editor and cannot get it to open again. Everytime I try ...
0
votes
2
answers
27
views
How can i automate export of all users and status (Active, Suspended, Archived) on GWS and then have the report sent to a list of users
Im trying to automate user reports on my Google workspace account showing their statuses and have the report sent via email to a list of recipients monthly.
I am trying to get all users with their ...
- 3
0
votes
0
answers
66
views
Looker Studio not showing html output from embeded Apps Script
I've a Google Sheet with an Apps Script. That Apps Script takes the index.html and creates a diagram inside a modal dialog.
Basically:
function updateGraph() {
const ui = SpreadsheetApp.getUi();
...
- 327
0
votes
1
answer
56
views
How to assign Google Workspace licences using Appscript and a Service Account (SA)?
Is there a way to assign a Google Workspace Business Standard Licence to a user of a domain, using Appscript and a service account, but without having to use the rights of the user executing the ...
0
votes
1
answer
26
views
How do I give a user permission to run the Apps Script in a Google Sheet?
I have created a pair of Apps Sheet files which run fine for me. I have shared the Google Sheets with other users. But those users cannot execute the scripts. How do I give them permission?
I thought ...
0
votes
0
answers
18
views
Gmail inbox window isn't updating after mail deleted successfully using gmail API
My issues is updating the UI of gmail inbox window when i delete mail using Gmail delete api by google workspace add-on, and app script
i am expecting when i click on report button in google workspace ...
0
votes
1
answer
34
views
Generating multiple EmbeddedChart in Appscript based on a filter
Based on the sheet here, I want to be able to generate a line graph for every Breakdown in the sheet.
Using the code below, I was able to list and split the rows I want into tuples and create a ...
- 317
-1
votes
2
answers
43
views
Apps Script Mailapp.sendEmail not working from Google Workspace account
We are a non-profit Organisation that has been using Sheets, Forms and Apps Script, some of which send out emails using MailApp.sendEmail() from a standard Google account for a number of years with no ...
