Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

0
votes
1answer
22 views

Run a Script When Tab Programmatically added to a Google Spreadsheet

I'm trying to pull data from an Adwords report to a Google Sheet through an Adwords script. This will be done on a daily basis. Every time the Adwords script runs, a new tab is created (and an old one ...
0
votes
0answers
8 views

Auto date insert when opposite cell is populated in different columns - only if in a particular sheet in a document

I found this solution to autoinclude the date in a column when another one is modified and it works great. Auto date insert when opposite cell is populated What Im looking to do is: To modify this ...
0
votes
1answer
14 views

Google Sheets automatically converts a string to a number

I am using Sheets as a front end to view tons of different IDs and credentials associated with my authenticated access to a 3rd party API. When calling this function, I get this result: ...
0
votes
2answers
17 views

How to export CSV without commas in unpopulated cells?

I have a form converter which simply rearranges columns. I use a script to paste Values only into another sheet for export and uploading onto another website. However, when I go to export, it seems ...
1
vote
2answers
75 views

Move cursor to cell in all sheets

I have the following script: function setActiveCells() { var wb = SpreadsheetApp.getActiveSpreadsheet(); var ws_names = wb.getRangeByName('an_sheets').getValues(); var ws_cells = wb....
7
votes
1answer
7k views

Export all sheets in a spreadsheet to csv in Google Apps

Is there a way to export all sheets in a google spreadsheet to csv as individual files ?
0
votes
1answer
16 views

Using Google Script to place Duplicated Google Form Responses in one Column?

I have a Google Form, with multiple sections, and duplicated questions. Google Forms Automatically creates separate columns in the resulting Spreadsheet for each question, even if it is the exact same ...
1
vote
2answers
1k views

Automate range name creation in Google Sheets

I am tired of meaningless spreadsheets. I want to use range names more often. It's a pain to make them by hand. My thought if each column on each sheet is given a range, then most of the pain of ...
0
votes
1answer
23 views

Add row to Google Sheets and keep formulas from previous row

I want to add a row to my spreadsheet but keep the formulas – and only the formulas – of the previous row. The #1 solution provided here doesn't help me because it also copies non-formula information, ...
0
votes
1answer
44 views

Spell check with formula or apps script

I have text in the table. I want to check the text whether there is a typo or not. Usually to check my typo using the default Spelling Tool from Google Sheet. The question is: Can the spelling check ...
0
votes
1answer
13 views

How to re-calculate a Google Sheet every time a Google Forms questionnaire is submitted?

I used Google Forms to create a questionnaire, and I created a formula for Google Forms answers using Google Scripts. After that, I want to re-record the calculated result on the Google Sheet every ...
0
votes
1answer
660 views

Exporting Google SpreadSheet to PDF (filename referring to a cell D7)

I have developed a script which allows me to export a spreadsheet to a pdf file with a click of a button. I have assigned the script to a macro so that it is triggered by clicking on an image. Script ...
1
vote
1answer
34 views

How can I set a background color for an entire paragraph?

I want to programmatically style a paragraph with a background color to make a "code area", just like when using a triple backquote around a paragraph in Stackoverflow, or like in this question. I ...
1
vote
0answers
17 views

How do I lock a sheet in Google Sheets at a specific time every day?

I would like the sheet protected from 6pm - 10pm every day. I have the following script but it doesn't seem to protect the sheet at the designated time. I have this script with the Time-based trigger, ...
0
votes
0answers
10 views

How does one import an RSS url as a RSS formated URL?

Currenty I am currently trying to aggregate a few of these urls in order to pull html which I want to display in my Sheet. Problem But currently I am just importing RSS from a news aggregator using ...
2
votes
2answers
80 views

How can I automate Find & Replace (to change the colours of certain symbols) in Google Docs?

How can I automate find & replace, specifically to colour all suit symbols document wide? I write bridge articles (card game), and I need to automate this formatting all the time: Find all "♣" ...
0
votes
1answer
38 views

Creating a script for Google Sheets to send an email if cells in a row contain a certain value

I have a Google spreadsheet that I created to track daily equipment inspections. The data in the sheet comes from a form that is filled out by whoever inspects the equipment for that day. Here's a ...
0
votes
1answer
30 views

Is google app script able to move a specific folder to the other one on google drive on time or condition triggering?

I refer a article to do what I want to move a specific folder to the other one. (The reference article is on the bottom.) Is it possible to move just the content only? I made it. But, it also moves ...
0
votes
0answers
13 views

Auto timestamp based on specific value

Currently, I am using below code to update timestamp in the next column. But I want to modify the code to update timestamp only when the cell value is True not on a change of cell value. function ...
0
votes
1answer
132 views

Inverse of Google Sheets GetSpreadsheetNameById

This post Display sheet name in Google Spreadsheets shows how to get the name of a Google sheet, given its URL. I have the opposite problem. I know the Spreadsheet name, but I want the URL to use in ...
1
vote
2answers
25 views

What function can I use to conditionally format text depending on cursor position or active cell?

In Google Sheets, I have a 'Freeze' on Column A. I want the text in Column A, Row X to Conditionally Format as BOLD RED, while my cursor is on any cell for Row X. Is there a way to manage that?
6
votes
1answer
3k views

Google Apps Script: copy document comments?

I'm working on the following script, which is supposed to look at the current document, grab its comments, make a copy, and copy the comments to the new document. However, I seem stuck. I'm not ...
3
votes
1answer
49 views

My Add-On was approved by Google, but it is available only to members of my employer's domain

I developed an add-on for Google spreadsheets, have sent it over to Google for a review, and after much blood, toil, tears and sweat, had it successfully approved. Yet, the add-on is only available ...
0
votes
0answers
19 views

Google Sheets: auto-format an entire column to be hyperlinks upon import

Here's my process: export CSV from CRM > import to Google Sheets > do work. In ColA are unique IDs (all integers e.g. 808938269) of accounts in my CRM. I would like to appended a generic [URL] string ...
0
votes
0answers
19 views

Google Script to Show Rows if cell value

I am working on putting together an Expense Report that allows a person the option to add another expense (up to 23 expenses allowed). I want the rows that need data entry to be hidden unless the ...
0
votes
1answer
19 views

How to use .setBorder based on cell content?

I'm completely new to programming and I'm trying to write this ridiculous easy script but it just won't work.. Anyone who can help me out? I think the script makes clear what I want to do but let ...
0
votes
0answers
16 views

Master Checkbox that turns off other checkboxes based on keyword in a different cell

I'm trying to create a master checkbox (actually a few) that toggle on/off various other columns of checkboxes on the same sheet. I have researched this issue and found only solutions either A) ...
0
votes
0answers
11 views

Help with a script for google sheets so that both ends of a link can be edited

so I found a great answer to a question that I had about connecting two different spreadsheets with a link that would allow you to edit either one and the other would update, I found a great page on ...
0
votes
2answers
19 views

Restrict or prevent drawing functionality?

I've created a Google Sheets spreadsheet that is shared with anonymous users. All users have Edit permission because I want them to contribute data to the spreadsheet. The problem is that some users ...
4
votes
1answer
2k views

Copying data to *and from* another sheet based on the month of a date

This is a follow-up to Copying data to another sheet based on the month of a date, with a different requirement: instead of one-way data transfer (from Master sheet to others), two-directional ...
0
votes
0answers
16 views

Help with a two way link script for google sheets

so I found a great answer to a question that I had about connecting two different spreadsheets with a link that would allow you to edit either one and the other would update, and I found this great ...
0
votes
0answers
25 views

Auto update date in google sheets based on edit in range of cells [duplicate]

I want to update a timestamp based on the last time any cell in a range is updated. I added this script: function getDate() { return new Date(); } In a cell I use the formula: =getDate(D5:AF5) ...
0
votes
1answer
28 views

Upload Limit of Drive.File.Insert

While I use the following app script code to upload file from URL to GDrive it is executed flawless but when I change the source URL with a large file's URL (more than 1GB) it uploads only 50MB for ...
2
votes
1answer
2k views

Mail Google sheet as excel attachment by Google Apps Script

I have a Google Spreadsheet with some different sheets. I want to send my Google Spreadsheet as excel attachment to some specific addresses in everyday morning. How can I do this easily? I have heard ...
0
votes
1answer
24 views

How can I compute the permutations multiplication “like” table to a linear list?

I have a table that is structured like this. I would like to transform the table into the permutations of the table if we treated like a multiplication table. Into a list that looks like this. ...
0
votes
1answer
14 views

How to move a row into another sheet?

In Google Sheets, I need to hide rows if column H says, "Completed" My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult. If you ...
0
votes
0answers
16 views

Google Drive - How can I unzip multiple zip files? (using Wikunia's Google colab/python method)

I actually would've just posted this as a comment under @Wikunia's brilliant colab answer, here, but I'm new (sorry!!): Basically, that works, and it works perfectly, but I'd like to genericise it to ...
0
votes
0answers
16 views

Google script full up the database

I have make more questions for this topic, the scrips are working, but i will add more cells to the script. The script what i have. function myFunction() { var spreadsheet = SpreadsheetApp....
2
votes
1answer
3k views

Show a time-stamp in one cell when another cell is updated in Google Sheets

I want to time stamp when a cell was filled out in the column to the right of only certain columns. We use a simple spread sheet to keep inventory and I'd like to know when someone takes something or ...
3
votes
1answer
2k views

How to remove protection on a range using scripts in Google spreadsheets?

I would like to write scripts that can protect and unprotect a range in a Google spreadsheet. The first function works: function AddProtectionToColumn() { var ss = SpreadsheetApp....
0
votes
0answers
16 views

macro for google sheets that can transferm data

I have make a macro in google sheets for transfer data from a cel to an other cel function myscript(){ var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); spreadsheet.setActiveSheet(...
0
votes
0answers
27 views

Google Drive - Get Image sizes

Is there a script that I can use to get the images sizes within a folder on google drive?
0
votes
0answers
17 views

unique numbers based on respondent's answers

I am managing a group of participants (example: doctors, nurses,etc) in filling the form, each participant chooses an option according to his goup (doctor, nurse, etc) i want different sets of unique ...
0
votes
0answers
19 views

Sending array in payload with UrlFetchApp.fetch

I'm trying to figure how to use the UrlFetchApp.fetch method and have this test for see what works. It's supposed to check with a events site to see if some guys have indicated that they're attending ...
0
votes
0answers
11 views

setValues not working how I want to

My script pulls data via a JSON request on a time trigger. Another function makes a summary of that data based on the filter in place. Both parts work, however whenever it pulls new data and the ...
0
votes
2answers
14 views
1
vote
1answer
14 views

How to date/timestamp for modifications in Google Sheets?

I have a sheet that has information in 8 columns starting in row 14. I would like I14:I310 to date stamp anytime there is an update in the corresponding row. I have tried a couple of different ways ...
0
votes
0answers
14 views

Is it possible for a Google App Script to convert a file in the cloud?

Is it possible for a Google App Script to take a file from Google Drive, such as a PDF, video, image or .rar file, perform a conversion to it, to convert it to another format, then upload the ...
0
votes
1answer
376 views

Google sheets script copying formatting *but not* merged cell status

I would like to write a script that copies the formatting, and the conditional formatting, that is applied to cell A1, and applies it to all of the other cells in the sheet. However, I do not want ...
2
votes
1answer
7k views

Auto-Find and Replace in Google Sheets with Scripts

I am having trouble creating a script that will find the value 'MKE' when entered into column C, and replace it with 'Milwaukee, WI'. Basically, I have addresses being placed into column C and would ...