A blog on learning to code using spreadsheets

Recent posts

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.

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 šŸš€šŸ‘‰.

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.

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.