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
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:
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 InlineImage in app script? The reference pages only show how to change the border width for a cell in table,
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
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
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
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
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
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 = {
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
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
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
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
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
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
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
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
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
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