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,905
questions
0
votes
1
answer
13
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
13
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
13
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'...
0
votes
0
answers
13
views
DriveApp.searchFiles("createdDate = '2024-07-23'") - invalid argument?
Trying to search for files that were created on a given date using the following:
var files = DriveApp.searchFiles("createdDate = '2024-07-23'");
when then doing files.next(), I'm getting ...
0
votes
1
answer
40
views
Sometimes my code runs and sometimes it does not
I work for a big organisation and we have some large Google Sheets that multiple users use (however maybe at one time it would be maximum 7-10). I am working on automating some processes for this ...
-1
votes
0
answers
20
views
Having trouble sending mails from google app script
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 ...
-4
votes
0
answers
20
views
How can I create a alert for everyone [closed]
Please suggest a script where who ever will open my Sheet it will give a welcome msg with his email id or user name
And this welcome msg also include good morning and good afternoon basis on the time ...
0
votes
0
answers
18
views
Using onEdit to trigger different functions on different sheets
I am working on a sheet that is recording inputs (scores) from multiple entry sheets. A data set on any given sheet has multiple entries, so I wanted to create a trigger to log the data when there is ...
0
votes
1
answer
23
views
How to export Checked row(s) only to PDF in Google Apps Script?
I have implemented a function in Apps script, with the following goals:
Identify rows that have a Checkbox value of True (checked) in Column A
Export only the checked rows into One pdf file
Only the ...
-4
votes
0
answers
19
views
auto reply feasable? google scripts [closed]
so i have an appscript set up and working flawlessly. i will paste below; however id like to know if there is a way that if the webhook discord post that just happened gets a reply it will auto reply ...
0
votes
0
answers
24
views
Create a AppScript Email trigger for a Google Sheet that is connected to a Datasource
Can't create an automated email on Appscript each time my Google Sheet connected to a Big Query Table updates, meaning each time a new entry has been detected.
Please find my code below.
// Helper ...
-1
votes
0
answers
21
views
Cannot auto-Update google spreadsheet with data from an uploaded file [closed]
I cannot get IMPORTRANGE to automatically update a new separate google spreadsheet after uploading a "converted" csv file. 1: IMPORTRANGE will automatically update the new spreadsheet ...
0
votes
1
answer
18
views
Get only the unique editors of a file and not the inherited folder owner
I am trying to move files from a current folder that Person A has editor rights to a new folder that Person B has editor rights.
I tried to do a .getEditors() on the files, and then move them to the ...
0
votes
0
answers
14
views
Update current card after composing draft in Apps Script for Gmail
I need a button to create a draft and update the current card, however I can only get 1 of those to work at a time.
// onGmailMessage.gs
CardService.newTextButton()
.setText('Create draft and ...
-1
votes
0
answers
17
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 ...