Google Sheets Button to Run Script: How to Create

In this video, I show how to call a Google Apps Script Function with a Google Sheets Button.

Video, Code, and Documentation can also be found at:

[Romain_Chafore]

I have watched many tutorial and this one is the only one that helped me do it differently. Thank you very much !

[Lenilezippo]

BEST VIDEO OF THE YEAR You just change my life ! THANK YOU SO MUCH

[elliottmunger]

Thank you! This helped me create a button to simply increment cells.

[ohill]

😂😂. Don’t know why but every time you say “button” I laugh. 😆

[ProfeARios]

Thank you so much for sharing!!!! Best regards from Panama 🇵🇦

[BruceThomson]

How about other controls - e.g. a slider bar? A drop-down box of option? Possible?

[northisdead]

For those who don't have the Script Editor tools. It is now in Extension in the name App Script.

[pnjwck]

Why can I not find the Script Editor option under tools?

[loryders]

ahh no one says how to get "script editor" to appear under the tools menu

[readingeducationjourney]

Hi Curt! Thanks for this! It works for me! However, I just have a concern, why is that when I try it on my other mobile phone or tablet, it's not working anymore?

[vg]

Hi, I was looking for this. Thanks for sharing this. I got an idea of what to do. But I am not a coder. Could you tell how do I do this -> on click button on the spreadsheet - an email comes to me asking for approval for the row number to which the associated button is clicked.

[musk.]

I'm at an impasse here. No matter what I try I get the same error "Script function sortClient could not be found" No matter what I name my function and reassign the button, it doesn't resolve. Refreshing doesn't work. I'm making sure to name it verbatim after the function and not the project (even tried renaming the project after the button). Here's my first line of code (without the quotations) "function sortClient(){"

Any insights you have would be appreciated, thanks for the vid!

[khazivanooravlog]

I'm Just learning how to use script on my google sheet but why my script function could not be found? after I made the script.. thanks in advances for you kind help

[amcpeak]

could you assist with a code that is not reading my getRange?

[dekjhip]

How to make the button fixed it's moving

[Dimarkorito]

Hello, thank you for your tutorial. I have a question: When i share this with others the button ask them for permission to run it. Is there a way to make it so it doesn't ask for permission when shared? Thank you in advance.

[robensoncesar]

Why aren’t buttons clickable on phone.

[monday]

if I share my spreadsheet as a url with other people do they see the button on the web site too? or do they have to be logged into there Google spreadsheet app to see it?

[BlokeBritish]

i need to allow users to write to my sheet through a script but users should not be able to view/open the sheet manually.
the script needs to capture current user email.
is this possible ?

[brendon_a]

in tools why dont i have a script editor option?