A blog on learning to code using spreadsheets

Recent posts

Automate reminders for recurring annual events using Google Sheets and Calendar

Learn how to convert your Google Slides presentation into a series of images.

Never lose important emails again! This Apps Script tutorial automates saving Gmail threads as PDFs in your Drive for easy archiving.

Stay on top of important dates with minimal effort! This tutorial shows you how to receive timely event reminders using Google Sheets and Apps Script.

Learn how to automatically send PDFs from your Google Drive to your Kindle device using Apps Script. Streamline your reading and save time with this easy setup.

The concat() method combines two or more strings into a single string.

The charAt() method returns the character at a specific position in a string.

Learn how to embed inline images in emails using MailApp in Apps Script.

Learn how to implement a simple website monitoring solution using Google Sheets and Apps Script.

Learn how to use Apps Script to automatically submit responses to a Google Form.

Learn how to use the UrlFetch API to connect your Google Sheets spreadsheet to the rest of the digital world.

The term API stands for Application Programming Interface. APIs let you build powerful applications without having to write code from scratch.

A comprehensive guide on converting Google Sheets to PDF, Excel, CSV, TSV, ODS or HTML using Apps Script

Learn how to insert an image into a cell in Google Sheets using Apps Script.

The Array methods reduce() and reduceRight() reduce the values in an array to a single value.

The Array method map() creates a new array whose values are obtained by calling a function on each element of the original array.

A cache is a place where you store data that you want to access quickly. The process of storing data in the cache is called caching.

Learn how to use Google Sheets and Apps Script to receive an email every morning with a motivational quote.

Learn how to enable autocomplete for your custom functions when you use them within formulas in Google Sheets.

Learn how to create your own formulas in Google Sheets to get the name of the spreadsheet and the sheets it contains.

Learn how to automate the "find and replace" feature in Google Sheets using Apps Script.

Learn how to make a table in Google Sheets that is less error prone and is more effective at conveying information.

Add comments to your code to help others understand what your code does.

Learn how to use Apps Script to create a slide in a Google Slides presentation for every row in a Google Sheets spreadsheet.

Learn how to convert Excel to Google Sheets using Apps Script and then import data from the converted spreadsheet into a master Google Sheets spreadsheet!

Are you going to win a car or a goat? Learn how to use simulation and Google Sheets to solve a world famous problem!

Learn how to send email notifications whenever a Google Form is submitted and also include the contents of the submission in the notification itself.

Learn how to use the throw statement to inform users that an error has occurred in a custom function.

Learn how to make your custom function know which cell it is being run from.

In Google Sheets, you can use Apps Script to hide rows where a cell has a specific value.

Learn how to build Tic Tac Toe in Google Sheets using Apps Script.

Learn how to use the onSelectionChange() trigger to detect when the user selects a new range in Google Sheets.

In this tutorial, I'll show you how to export a list of your Drive files to a Google Sheets spreadsheet.

Did you know there is an easy way to enter the same value in every cell of a Range in Google Sheets using Apps Script?

Learn how to create personalized student certificates by mail merging data from Google Sheets into a Google Slides template.

Learn how to automate parts of your content creation workflow using Apps Script.

Learn how to use Apps Script to center images in a Google Slides presentation.

With just a few lines of code you can insert images from Google Drive into Google Slides using Apps Script.

Learn how to programmatically insert images into a Google Slides presentation using Apps Script.

Learn two ways to create a copy of a Google Slides presentation using Apps Script.

Automatically generate Google Slides presentations using data from a Google Sheets spreadsheet.

In this tutorial, I'll describe how to return values, errors and arrays from a custom function.

Learn how to clear the contents, formatting, data validations, etc. in a range using Apps Script.

Learn how to hide a sheet, or show a hidden sheet in Google Sheets using Apps Script.

Learn how to rename a sheet in Google Sheets using Apps Script.

Learn how to create a new sheet for each row in a Google Sheets spreadsheet using Apps Script.

Determine which menu item was selected from a custom menu in Google Sheets using a single handler function.

Learn how to build a navigation menu in Google Sheets to make it easy for users to find and open the right sheet.

Learn Google Apps Script, learn how to use it to automate your tasks, and build simple user interfaces and applications in Google Sheets.

The Array method some() is used to check if at least one element in the array meets a set of conditions.

The Array method filter() is used to filter an array based on a set of conditions.

Learn how to programmatically activate a sheet using Apps Script.

Learn how to iterate through every cell in a range in Google Sheets using Apps Script

The Array method every() is used to check if every value in an array meets a set of conditions.

The Array method indexOf() is used to find if a value is present in an array. It returns the index where the element is found or -1 if it is not found in the array.

The Array method forEach() is used to execute a function for every element in an array. It is also referred to as the forEach loop.

Learn how to build a simple expense report approval workflow using Google Forms, Google Sheets and Google Apps Script.

Instead of inserting charts manually, you can use Macros to automate this process.

Tired of manually resizing rows and columns in Google Sheets? Learn how to automate this using Apps Script!

Creating triggers using the Apps Script editor UI can be inefficient if you're creating many triggers. Learn how to use Apps Script to programmatically create triggers!

Learn how to add links to a cell in Google Sheets using Apps Script.

Learn how to iterate through rows in a Google Sheets spreadsheet using Google Apps Script and take some action on each row.

Learn how to build custom user interfaces like alerts, prompts, sidebars, etc. in Google Sheets using Google Apps Script.

A custom dialog can be used to build custom prompts, alerts or other dialogs in Google Sheets.

Learn how to freeze rows and columns in Google Sheets using Apps Script.

Learn how to efficiently write multiple rows of data to a Google Sheets spreadsheet using Apps Script.

The Array method concat() merges two or more arrays into a single array

Learn how to view all of the formulas in your Google Sheets spreadsheet at once.

A custom sidebar can be used to build your own user interfaces (such as data entry forms) within Google Sheets.

A macro is a simple way to automate repetitive tasks in Google Sheets. Using a macro, you can record a set of actions and then reuse them in the future with just a single click.

Streamline data entry and minimize data entry errors by embedding a Google Form in a Google Sheets spreadsheet using Google Apps Script.

Learn how to build radio-button-like functionality in Google Sheets using Google Apps Script.

Learn about several ways to run Google Apps Scripts in Google Sheets and when to use each method.

In this tutorial, you'll learn how to write a custom function to convert a string to Proper case in Google Apps Script.

Learn how to insert, remove and work with checkboxes in Google Sheets using Google Apps Script.

The Array method splice() is used to change an array by removing elements from it and/or adding elements to it.

Strings are text values and you'll use them a lot while programming. This tutorial covers the basics of working with strings in Google Apps Script.

Learn how to make your Google Sheets spreadsheet interactive using checkboxes.

This tutorial provides a comprehensive overview of named ranges in Google Sheets and how to use them with Google Apps Script.

This tutorial will walk you through several ways to read data from and write data to your Google Sheets spreadsheet using Google Apps Script.

A range represents a single cell or a group of adjacent cells in your spreadsheet. In this tutorial, you'll learn about what ranges are and how to use them.

A comprehensive list of keyboard shortcuts for the Google Apps Script editor to help you become more productive while using it.

This page has answers to questions submitted by readers of this blog.

Learn how to fix 404 errors in Web Apps built using Apps Script.

Learn how to create clickable buttons in Google Sheets using Google Apps Script.

Custom menus in Google Sheets make it easy for end users to access the functionality that you've developed using Google Apps Script. Learn how to create custom menus in Google Sheets.

A pop up alert message is used to display important information that the user must pay attention to. Learn how to display pop up alert messages in Google Sheets using Google Apps Script.

The Array method unshift() adds elements to the beginning of an array.

A toast is a notification that provides some contextual information to the user in an unobtrusive manner. Learn how to display toast notifications in Google Sheets using Google Apps Script.

The Array method shift() removes an element from the beginning of an array.

Learn how to build a 5-star rating system in Google Sheets using a custom function written with Google Apps Script.

The Array method pop() removes an element from the end of an array.

Learn how to build a simple app to email notes to yourself from your phone using Google Sheets, Google Forms and Google Apps Script.

Learn how to automatically import CSV files from a URL or from Google Drive into Google Sheets using Apps Script.

The Array method push() adds elements to the end of an array.

The Array method sort() sorts the elements in an array.

The Array method reverse() reverses the order of elements in an array.

The Array method join() concatenates the values in an array into a single string.

Learn how to automatically sort your Google Form's responses so you'll always see the most recent ones at the top.

Learn how to write a custom function to get the HTML color code (also known as a Hex code) of a cell's background color.

Learn how to automatically send email notifications whenever your Google Sheets spreadsheet is edited.

Triggers enable you to automate your tasks and workflows in Google Sheets. In this article, you'll learn more about triggers, how they work and how to create them.

This tutorial will show you how to run JavaScript code in Google Sheets.

Learn how to send HTML email from Google Sheets using Apps Script. I'll also show you how to create the HTML email template using Gmail and Google Docs.

Learn how to send personalized emails from Google Sheets using Mail Merge.

This tutorial will teach you how to send an email for every row in a Google Sheet.

If you've worked in any organization of any size, you've probably had to put together and send reports on a regular basis to your team. In this post, I'll show you how to automate sending emails from Google Sheets based on a schedule.

In this post, I'll teach you how to automatically email a Google Sheet as as a PDF attachment from within Google sheets itself.

A comprehensive guide on sending emails from Google Sheets.

I'm writing a series of posts to explain basic coding concepts using Google Sheets. In this post, I will explain what a value is and I will also introduce the concept of a data type.

Learn how to build a guessing game in Google Sheets using Apps Script.

Learn how to use prompts to get user input in Google Sheets.

Learn how to authorize an Apps Script and the security and privacy considerations to keep in mind while doing so.

Learn how to build a simple mood tracking app using Google Sheets.

Apps Script is my superpower and it can become yours too! I am going to teach you to code using Google Sheets and Apps Script. Iā€™m not going to teach you every single coding concept but I'll teach you enough to build simple applications.

Apps Script is a coding platform in G Suite that can be used to build simple applications on top of existing apps such as Sheets, Docs, Forms, etc.

A loop is a piece of code that runs a set of statements multiple times. Each run is called an iteration. There are two common types of loops in Apps Script: For and While.

An array is a special type of object that is used to store a list of values. You will use arrays extensively while working with Google Sheets using Apps Script.

Objects are used to organize the values in your Apps Script program that are related to one another.

Variables are used to store values. Constants are just like variables except you cannot change their value after assignment.

Learn how to use IF-ELSE statements in your Apps Script code to implement conditional logic.

Values are the data used by your program. There are six types of values in Apps Script. Operators are used to perform operations on values.

Learn how to write a custom function for Google Sheets using Apps Script.

Learn how to create an Apps Script.

Learn how to use Google Sheets and email reminders to remember birthdays.

Why I started a blog to teach spreadsheet users to code.

Stay up to date

Follow me via email to receive actionable tips and other exclusive content. I'll also send you notifications when I publish new content.
By signing up you agree to the Privacy Policy & Terms.

Tutorials

Learn coding using Google Sheets and Apps Script

Do you use spreadsheets a lot? Did you know that you can build simple applications using spreadsheets or even automate your work? If this sounds exciting, this tutorial is for you šŸš€šŸ‘‰.

Google Apps Script Tutorial

Learn Google Apps Script, learn how to use it to automate your tasks, and build simple user interfaces and applications in Google Sheets.

Sending email from Google Sheets

Learn how to send emails right from Google Sheets so you can create birthday reminders or automate sending those boring "Daily report" emails at work.

Build custom user interfaces in Google Sheets

Learn how to build custom user interfaces like alerts, prompts, sidebars, etc. in Google Sheets using Google Apps Script.

Coding Concepts using Sheets

In todays world, it can be useful to understand coding concepts even if you aren't a programmer. I'm writing a series of posts to try and teach some of these concepts using spreadsheets.
 
© 2024 Spreadsheet Dev Privacy policy Terms of Service