Questions tagged [google-sheets-addons]

The tag has no usage guidance.

0
votes
1answer
53 views

Running script to replace “null” with nothing in Google Sheets

I tried to do this through a macro but I'm unable to have it actually record. I'm not a coder so I've been recording macros and using the code from there to create an add on. I need a script that can ...
-1
votes
1answer
33 views

How do I install Spreadsheet Freezer?

I have hear that Spreadsheet Freezer could help me to control when a formula is recalculated. I read on the it's site that I could find the install link here, but I only found questions that point ...
3
votes
1answer
61 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 ...
1
vote
0answers
13 views

How can I receive a notification for new reviews for an add-on in the Google Sheets add-on store?

I would like to receive a notification (preferably email) for every new review left on the add-on store page for a specific add-on. Example for such a page: Sheetgo Review section:
1
vote
1answer
701 views

Add my scripts or add-ons to new Google doc

I've created a script or add on for my Google Document. The script exports the content to basic HTML. When I create a new doc I can't find a way to import the scripts from the existing document. From ...
0
votes
1answer
6k views

Creating Google Forms from Google Spreadsheet

It is possible to use the FormCreator app to create Google Forms using Google Spreadsheet. My question: how did app manage to achieve that?
2
votes
1answer
88 views

How to automatically create a templated Google sheet?

I'm trying to figure out how to automatically create a templated Google sheets worksheet when a new entry is made in a different sheet. So the flow would be: Person's name is added into Google sheet ...
2
votes
1answer
23 views

Where can I find the number of add-ons for each category in the Google Sheets Add-ons store?

I would like to know the number of add-ons for each category (Business Tools, Productivity, ...) in the add-on store of Google Sheets. What I tried: I opened a new spreadsheet. I opened the add-on ...
-5
votes
1answer
453 views

Inventory Using Google Sheets [closed]

I'm running Google sheets on a Windows laptop and using Google Chrome as my browser. I work in a clothing store and would like to make an inventory list that my coworkers can access and update (maybe ...
1
vote
1answer
103 views

Copy data to a new spreadsheet with specific name

I was hoping to find a script that does the following: Takes data from a particular spreadsheet, Duplicates that data to a new sheet as values only in the second spreadsheet it creates a new sheet ...
0
votes
2answers
5k views

How do I modify this Google formula to filter out blank responses from Google Sheets?

I have Google Sheets running the add-on formmule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the ...
2
votes
2answers
5k views

How to select multiple, non-consecutive cells in Google Sheets using a list of the cell addresses

I have a very long, comma-separated list of cell address coordinates, shortened here for the sake of brevity: C3,C7,C17,C56. I would like to select these cells. Is this possible to do by pasting the ...