Category "google-apps-script"

How to run google app script at exact time?

Currently, I want to run my google app script at exact time. I have already do some reading about this problem and I decide to follow the solution in this post

Newbie - need script to remove duplicates based on multiple criteria

So I'm super new to Google Sheets - as I mostly use Excel and Smartsheet. I was trying to accomplish this by just recording a macro, so this is VERY messy. I ha

Get the email address of a "people chip"?

Does anyone know if there is a way to use the Google Sheets API to get the email address of a people chip? It seems like the only values it will give me are the

There is a way to set the pdf size in the following script?

How do I set the pdf size as A4 in the following script? Also, is it possible to fit the sheet into a single pdf page? function sendSheet() { var message = {

Google Sheets keeps sending emails

Been building a landing page to start an email list. Decided to use Google Sheets as the backend to store emails & Google Scripts to send the first welcome

Mail merge with different attachments

Please guide me. For how to fix the script to different attachments. In other parts of script is perfected. I want to solution for attachments. See code here

Stop script from creating PDF duplicates

I'm new to the coding thing but I've been able to write a script that will take info from a spreadsheet and turn it into a PDF. The trouble I'm having now is tr

Using both AdminDirectory API and AdminReports API in the same project/script?

So when you add either service, you exclude the other one (see picture). Once you have added either the reports_v1 or directory_v1 you can no longer select the

How can I use Google Apps Script's UrlFetchApp to scrape a New Google Sites page?

My group recently migrated from classic to New Google Sites. There were many things I was doing with classic sites and/or apps script's Sites Service I can't do

How to save PDF from HTML with the same rendering in app script

I need to save an HTML webpage as a pdf in my google Drive. I am using app script. However, the PDF is rendered differently from the HTLM page. I need the PDF t

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