Use Google Sheets to store your Recipes to automatically change Batch Sizes and Recipe Amount by Weight

Your very own Google Sheets Recipe Template

For my culture, the Christmas season has come. With it comes all the delightful homemade goodies and snacks you get for over the Christmas season.

I do like to cook and over the years I have either inherited or discovered some great recipes. However, one of the problems I often face is that I need to be able to change the batch size or total ingredient weight of my recipe for when it is just me and Mrs Yagi or when I am hosting a bunch of people for a Christmas party.

So rather than try and calculate the changes each time, I put our recipes into a Google Sheet and set it up so that I could plug in a number of batches or a total ingredient weight and then head out and do my shopping accordingly.

Ugh…but recipes in Google Sheets is ugly, Yagi!!!

I am no design genius, but you might be surprised. Take a look at my example Christmas Recipe Google Sheet below:

Google Sheets Recipe Template Batch and Weight View
Click to Expand!

Or this print view:

Continue reading “Use Google Sheets to store your Recipes to automatically change Batch Sizes and Recipe Amount by Weight”

Google Sheets Beginners: Getting Email notifications on changes and form submits (24)

Google Sheets

Google Sheets provides an email notification tool that allows you to get email notifications for changes to a Google Sheet or when a Google Form that is connected to your Google Sheet receives a submission. You can set your email notifications to be received when each change occurs or as a daily summary.

There are some really good use-cases where you might need to receive notifications of changes to a Google Sheet. Here are two common examples that I have used notifications for in the past:

  1. Tech Support: I have had a form connected to a sheet and then had my team use notifications to get an email when a user submits a tech support issue. We set it up so that the first responder adds their initial to a column related to the lastest form submission so that everyone knows that it is being addressed.
  2. Project Management: I’ve run a Gantt chart for project management and when someone from a project I have assigned has completed a portion of a task and is ready for review, they check a box. At the end of each day, I get an email notification summarising the changes in the chart.

Check out the details below on how to get notifications on a Google Sheet and how to read the email notification summary.

In this tutorial, I’ll cover,

  1. What are Notifications in Google Sheets. 00:27
  2. Adding in a Notification Rule. 00:42
  3. Notification from a Google Form. 01:00
  4. How Forms link to get Notifications. 01:25
  5. How Notifications are received in email. 02:10
  6. Creating a daily digest as a Notification Rule. 02:53
  7. What a daily digest looks like in email form. 03:20
  8. Other Notification Rules you can add. 03:55
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Protecting cells, ranges and sheet tabs (23)

Google Sheets

Have you ever had your editors edit something on your Google Sheet that they weren’t meant to? Find out how to protect cells, ranges and sheet tabs in Google Sheets.

In this tutorial, I’ll cover,

  1. Why you may need to protect certain parts of your Google Sheet 00:02
  2. Protecting a range of cells. 00:50
  3. Selecting editors to your protected range. 01:22
  4. How protected ranges look for the user. 01:46
  5. Protecting entire columns. 02:35
  6. Editor hierarchy. 03:18
  7. What to protect? 04:13
  8. The ‘protect’ sidebar. 05:17
  9. Protecting an entire sheet tab. 05:57
  10. Viewing a list of what has been protected in your Google Sheet. 07:17
  11. Hot tip for hiding sheet tabs from other users. 07:42
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Apps Script: Store a Unique User Key from a User Accessing your WebApp

Google Apps Script: WebApp

In this tutorial, we will cover how you can get a unique temporary access key from a user accessing your WebApp that lasts for 30 days.

Temporary access keys allow you to track users as they use your WebApp over time while still providing anonymity to the user by providing only an access key to that user. Rather than, say, use their name or email address.

Why is this important? Well, you might want to limit the number of times a user submits a form on your WebApp. If you can get a user’s access key unique to them then you can store the number of attempts by the user and check it before the data is submitted.

For example, in a previous post, we created a chain story that we might want to limit the number of times our users contribute to our story to once a day.

NOTE! This tutorial is pretty much standalone. However, it will require some basic knowledge of Google Apps Script WebApp and HTML. Don’t worry if some basic setup parts are not covered in this tutorial, I’ll link to how to do these bits if you need some more instruction.

Let’s take a look at what we are going to make:

Continue reading “Google Apps Script: Store a Unique User Key from a User Accessing your WebApp”

Google Sheets Beginners: Remove Duplicates from a Range (22)

Google Sheets

If you are anything like me, you may find yourself regularly tidying up imported datasets or data from users that contain duplicates that could potentially corrupt your data analysis.

Fortunately, Google Sheets has a quick tool to help you to remove duplicates with a simple click of the button.

In this tutorial, I’ll cover,

  1. Why you might need to remove duplicates. 00:10
  2. How to remove duplicates for a single row 00:30
  3. How to remove duplicates that contain a header row. 01:20
  4. Removing duplicates from multiple selected rows 02:02
  5. What data ‘Remove Duplicates’ will and won’t match. 04:48
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.