79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

This tutorial is not available for free users. Please purchase a subscription to view this tutorial.

Hey there stranger!

Please sign-up or sign-in to watch this tutorial.

Hold a Giveaway Raffle in a Google Sheet

About this Tutorial

Get a random winner from a list of names. Also great to randomize tasks to do.

Video Transcript

0:00 Hello, when I'm recording this. It's December 5th, so it's just coming up on the holiday Christmas season. And I just thought it would be really cool to create a giveaway in a Google sheet.
0:14 Now, however you determine to get names or user names, maybe Twitter handles into a Google sheet. That's up to you.
0:23 You can use a Google form. You can copy and paste if it's something like people who are commenting or retweeting.
0:29 But yeah, any way you get 'em in here, we have a list. We want to get a random person from this list.
0:34 We want to get a winner. Okay? So one way you could do this is by doing a formula with the Rand function.
0:41 And I have a couple of videos already on that, on how to do random numbers. We just sort of multiply I'm not gonna go into it in this one because I found a really cool piece of code app script on online called that can shuffle an array.
0:59 And so I wanted to show you how to do that in Google script or App Script. And here we have the whole code.
1:06 And so wanna walk through this and, and, and share with you how you can use this yourself. You can literally get this code in this sheet joing two below.
1:17 And what's cool is it's pretty simple until we get to the shuffle array. We just grab the active sheet, we make sure we get the sheet name, this sheet one.
1:28 If you have sort of a entrance or something, if you change the name here, go into this code and change it in sheet one.
1:36 So entrance where you see that online three just have to change that. So we're gonna change it back to sheet one, just so that it's the same.
1:46 Okay, we're getting the last row of that sheet. So whatever sheet this is, it's getting the last row and it doesn't get the last row of like 1000.
1:57 It actually gets the last row that there is data. So in this case it'll be row 10. Okay? Now what it does is it then gets all the values and it creates what, what we call a shuffle array.
2:12 How it does this is this code that I found online, which is really cool. It, it's pretty simple little for loop that uses that math dot random, which is a very sim it's exactly the same as that ran formula.
2:24 But here we're doing it in Google App script, this math random, it's creating a random array here. Then it's getting a temporary moving that, that nu that person outta there.
2:37 Then we're putting, we're replacing someone else and then we put temp and we return the entire array and it's shuffled.
2:43 Basically each person's name here that we're gonna get one through 10 here is put into an array and then shuffled.
2:51 And then we get back the array here, we get back the array. Then from that array, the only thing we need to do is get the first name, which is this bracket notation, which is we use zero because in an array, zero is the first item in the array and that's it.
3:08 We return back just the first item in the shuffled array. So that could be the first person, right? The first person here absolutely could be, could be the second person or the third person.
3:18 It is literally random as to the placement of who is the first person on the shuffle array. And what we need to do is just call this get winner function.
3:29 So if you grab this script from the sheet or you copy the sheet and then you enter all of the names here, the only thing you need to do is due equals get winner.
3:41 You will get this this red line that says unknown function, get winner, but just hit enter. Make sure you have a capital W here, get winner.
3:51 And here we go. We got Camden Hall. If you want to pick more than one, what I would recommend is grabbing that person, moving them out, and then writing get winner again.
4:08 And now it actually got that same place. So we can do is we can do this again equals get winner.
4:17 Let's see, gonna get this Oakley Parker. So we just move them out, move Lily up and do get one again.
4:29 Maybe one three. Lily Cooper. Ah, this is interesting. So I was looking at this, I was like, oh, this range, if that's the random one.
4:39 So I looked at this range and actually we need to have a header here. We wanna have usually have like names or entrance, right?
4:49 There we go. So what we're looking at is the, is a range or a list of names starting on the second row in the first column.
5:03 That's as large as there are rows minus one and then one column. So that's good that we double check, we go get winner Genesis King, the last one.
5:21 Then we do get winner again. We can do this maybe very many times. We can even sort this way, right?
5:32 If you take out, it's gonna be a random one every time. So it's not gonna Mike Dogen. Okay? Again, maybe you have some kind of entry or giveaway or a raffle that you can give away multiple prices so you don't take anyone out, that's fine.
5:48 <inaudible>. And so we have four winners here, right in that order. And so this raffle code, this get winner, allows you to shuffle those names and get a winner.
5:57 And I think that's a pretty cool thing. We can use this in giveaways. We can do this in even task management.
6:03 Sometimes we want do a task or we have a, a large array of tasks or to-do list that's quite long and we're like, oh, where do we start?
6:10 We can use this to get a random task out of it. I think that would be a fun implementation. Also, you can put a list of names of people who need to do tasks or a priority queue.
6:21 If you have sort of things coming in and you don't want to do them in the order that they're coming in, you can sort of pick a random person to take each one.
6:30 So that might randomize things a little bit more instead of giving them tasks to the first person, the second task to the second person, third task and third person, get a random one.
6:39 And, you know, some people might get doubled up, but over time, you know, customer service account or customer service representatives, it, it's random.
6:46 We're always, everybody's gonna get equal over a great deal of time. So I think this is pretty cool. Go grab the the link below to get a copy of this, but.


Sheet Stories / Video Notes + ADDED: Email Notifications



Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet



Getting Started Coding in Apps Script

Seek Errors When Coding Apps Script

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

ChatGPT Clone in Google Sheets Part 2

ChatGPT Clone in Google Sheets Part 1

Quickstart Tutorial OpenAI API in Google Sheets

Embed a Number in a Website from a Google Sheet

Create Navigation Like A Book or Presentation

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?


Embed a Headline in a Website from Google Sheets

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Hold a Giveaway Raffle in a Google Sheet

Create a new Spreadsheet from just a Name in a Sheet.



Email Yourself a Cell from a Google Sheet, Every Day

OpenSea Data Inside Sheets


Shwitter | Twitter in a Google Sheet

Create an Email Campaign Stats Calculator


Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Highlight Row as You Move Your Cell Selection

Create a Timer with Apps Script

LinkTree in a Google Sheet


Password Protecting Data In a Google Sheet

Automatic Weekly Backup of Google Sheets

Create a CPM Custom Function (Create Better Calculators!)

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script


What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users


Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.


Sync Two Tabs Without ImportRange()

Password Protecting Data In a Google Sheet Part 2 The Basics

Benoit Asks: How to Convert Case



Learn to Code in Google Sheets, For Programmers

Add a Checkbox to Turn on Dark Mode


Write Your First Script


Find Keywords in Any Column, And create a quick search dropdown to find them.


Basic CRM - Add a Powerful Script To Move Row Based on Status

How To Improve: 1,000 Business ideas: Business Idea Generator


Let's Make a Bookmarklet!


Troubleshooting Bitly in a Google Sheet Script


Unique Features - Design a Better Dashboard Part 2



How To Set Up Stripe Webhook to Google Sheets with Google Script


How to Edit a Macro


Sheet Stories / Video Notes + Clear 24 Hour Old Videos


Add A Timestamp to Task Lists (without Now Formula)


Make your Custom Functions Like Native Functions | Custom Function Autocomplete



Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop



New Syntax for WhatChanged Formula in Google Script


How to Record Macros


2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)


Deep Inside Dark Habits Google Script


How to Trigger Macros Daily


5 Ways to Create Coupon Codes | Create UUIDs

Create a Radio Button From Checkboxes Using Google Script