Category "google-apps-script"

How can I receive the current displayed week of google calendar with app-script?

I cannot find any property receiving the currently for the user displayed calendar week with google apps-script here What I want to do is: Extract the start and

Google Script: Sort Array of Email Addresses to Remove Duplicates

I pull data from a Google Event Calendar. The events include multiple point of contact e-mails (Primary, Secondary, etc.) I am currently able to collect ALL of

Need to make simple read and update webapp using appscript

I have a google sheet like this I Need to make a google appscript webapp like below with the above sheet. only the price field need to be editable. When it is

Develop automation in Google Sheets to schedule updates in third party database

We have scales for which we upload data based on a Google sheet that we maintain. The Google Sheet translates the data into the correct configuration and we exp

How to get information about all videos of a channel to Google Sheets with Google Apps Script

I want to list all videos of a YouTube channel in Google Sheets and see statistics if possible. How to achieve this with Google Apps Script?

Sum only numbers given a string

How can one create an Apps Script function to sum only numbers given a string. I've been able to do this using this regular formula within Google Sheets: =SUM(S

comma error while importing csv using appscript to google sheets

I am trying to import a csv file to google sheets via google appscript. everything works well except in the last few rows the data is being copied after skippin

comma error while importing csv using appscript to google sheets

I am trying to import a csv file to google sheets via google appscript. everything works well except in the last few rows the data is being copied after skippin

Image path URL not Rending right in google apps script

I am trying to build an web app using apps script it was working well till yesterday but I don't know why my password recovery pages not rendering right. the im

Google Apps Script search function needs to compare strings containing numbers and letters

So I'm building an incredibly simple database (really just a minor in-sheet MVC) to standardize data storage practices in order to automate some things. I'm try

How to get the current price of a cryptocurrency on google sheets from coinmarketcap?

On a google sheets cell I want to get only the current cryptocurrency price with this formula: =ValueCrypto(A1) I tried this function for coinmarketcap: functi

Automatically protect / un-protect sheets or ranges when value is change from another source (google sheets)

There is a case where test is given to a certain student. The student can only work with the answer for the test before a given period. Here is the sample case:

Working with large folders in Apps script

I have a folder with over 50,000 files in it and it's so big that even getting all the file id's causes a 6 minute timeout. In fact it's so large I cannot even

How do I set the border-weight of an Inline Image in app script?

How do I set the border-weight of an InlineImage in app script? The reference pages only show how to change the border width for a cell in table,

Google Sheets: Copy and Paste from one sheet to another based on checkbox

I posted a question a few weeks ago stating I'm a sort of a newbie at all of this and I am trying to learn. I am trying to write some script for a spreadsheet I

Google Sheets: Copy and Paste from one sheet to another based on checkbox

I posted a question a few weeks ago stating I'm a sort of a newbie at all of this and I am trying to learn. I am trying to write some script for a spreadsheet I

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 = {