Want to automate your Google Sheet? You’ll need to learn Apps Script.
There’s a lot to learn, below are all the articles, and tutorials we’ve written that cover how to do common things in sheets using Apps Script.
Happy coding!
You can’t deliberately delay the execution of an entire Google Sheet using a cell function. Most of the in-built formula functions on you can use in a cell execute very quickly. Some of them, such as IMPORT functions, can take a little time to return data. But these, like any Apps Script function you can … Read more
There are 3 types of loops you can use when writing JavaScript inside the Apps Script editor in Google Sheets. Those are do,for and while loops. They each work slightly differently. For loops are our favorite construct when updating all the cells in a range. They offer outstanding performance and make for easily readable code. … Read more
Google Sheets makes sharing your spreadsheets with other users easy. It only takes two or three clicks to give one of your contacts editor, commenter or view-only access to your sheet. But what if you want to go a little further? What if you want to protect parts of a sheet from being edited, but … Read more
If you want to keep track of the exact date and time when cells change in your spreadsheet, you have several options. You can write Apps Script that will automatically record timestamps (and usernames) for you whenever certain cells change. If you want control over when the timestamp gets recorded, you could add a tick-box … Read more
It’s quick and easy to get the ID of a Google Spreadsheet or Sheet Tab from its URL. If you have the sheet open in your browser, you should be able to see the URL within the address bar. The Spreadsheet ID comprises letters, numbers, hyphens and underscores and is the part of the URL … Read more
The 2 simplest ways to make a button in Google Sheets are by adding a clickable drawing that looks like a button and runs some Apps Script, or adding a custom item to the menu. This article will take you through how to do both and how to write some simple apps script that clears … Read more
If you need to assign a script to a button in Google Sheets, you’ve probably created a drawing and need to know how to Assign a script to it that does something. You need to right click on the drawing and open the three dot menu, then select Assign a script from the drawing menu. … Read more
Google Sheets does not allow you to add buttons to the toolbar. In fact, there are no toolbar customization options available at all. But you can add buttons and sub-menus to the menu. You can easily link these with Apps Scripts and make them perform whatever actions you want. If you need more flexibility, or … Read more
There are 3 ways to make a button that performs an action in Google Sheets. You can create a drawing that looks like a button, and runs Apps Script when clicked, or you can use a tick-box that will run a script whenever it gets ticked, and then un-tick itself to appear to act like … Read more
This article will focus on examples of how to write Apps Script to clear different ranges of your sheet contents. In order to run this script you’ll need to pick from the one of 3 ways to make a button on Google Sheets. You can create a clickable drawing that runs script, you can add … Read more