Category "google-apps-script"

google apps script: get the name of the function that is currently running

I'm trying to get google apps script to log the current function that is running. I have something similar in python like so: code_obj = sys._getframe(1).f_code

Google Chat bot - Send private message WITHOUT event

I have a bot that is working in PM, I can talk with it and make it do my tasks without any problems but I don't find how to make it send a message to a specific

Apps Script google.script.run does not work within a Library-bound html file when triggered by other users

I have an authorization problem, but I can't figure it out. I have 50+ spreadsheets each for a separate user in our company. Each user spreadsheet has a contain

Sync Google Sheet and Google Calendar by ID preventing duplicates

With this code I could put the events from google spreadsheet to google calendar, but now I would to sync these events between the two platforms by a unique ID

Parsing google alerts using gmail and app script

I have google alerts set up and receive alert emails which look like this: I would like to parse the alert and save it in a google sheet with the format: alert

Customized border for google document table with Google Apps Script

I'm very new to Google's app script. I have read the documentation and I can already do some things, but I have encountered some difficulties in resolving an is

How to add authentication to a Google apps script without it expiring?

I have a Google apps script project which I use as a web application to save some data gathered from a web page (JavaScript only) to My Google sheets (think of

Join Date and time for events from sheet to calendar [duplicate]

With this code I can send the events directly to google calendar from google sheets. The start date and end date are on two different columns

How to convert .docx files to Google Docs with Apps Script?

Does anyone has experience in convert a batch of .docx file, stored in Google Drive, to Google Docs format? I read the solution posted 3 years ago by Youssef, b

IMPORTHTML not working for retrieving the table that shows the player rankings [duplicate]

I have used importhtml function for google sheets many times and successfully but sometimes I have had no luck in getting it to work. I am doi

Session.getTemporaryActiveUserKey() keeps changing

My understanding from the docs is that Session.getTemporaryActiveUserKey() changes for a user every 30 days. In my past experience using it, this was true but o

What will be the formula to check which currency a cell contains?

How to check if a cell in google sheet contains $ (USD dollar) currency or Rs. (Pakistani Rupees) currency to calculate two different currencies total?

Trying to see if I can run the same Slack message payload multiple times in Google scripts via data from a spreed sheet

I have a spreadsheet of data where I pull data from an array of data. After I declare the data, I run the code and it sends a message to slack using their block

UrlFetchApp fetch how to retrieve JSESSIONID object for the cookies?

I'm trying to use UrlfetchApp to send a request to a page. Request is good. But returning <p>Your browser is currently set to block cookies. Please enable

Count the maximum number of rows in another google sheets

I am trying to count the maximum number of rows in other google sheets. Actually, Each spreadsheet has a number of tabs and I want the maximum row number of all

Is there a way to create a folder tree of all Shared Drives as an admin?

Google Drive is quite impressive for a web app, but it seems to be optimised for search, not spatial navigation so it's painfully slow for myself and colleagues

How to change the range based on dropdown menu selection

I have a Google Sheet where I am tracking baseball stats for my High School Baseball team. I have the script setup for every time a Hit Error or Run is recorded

Successful Login to API; Unsuccessful at accessing any data due to being unauthorized

I am attempting to come up with a live leaderboard for my local club using the PDGA's (Professional Disc Golf Association) API. I am writing a Google Apps Scrip

Trying to retrieve Google File ID for an image in google sheets

I have an Appsheet app, for which I am trying to get the Google File ID of an image that I have taken through the app. When the image is taken in the app, it is

Google Sheets Dropdown "Input must fall within specified range". How to solve this?

I have a very simple Dropdown on Google Sheets that is working perfectly. Basically when I select an item from the dropdown, it will output that same item on an