How to Use a Google Form to Collect YouTube Giveaway Contest Entries and Randomly Select a Winner
Find Formulas, Functions, and Demo Pages Here: https://wp.me/p2znfB-BI
Click here to subscribe http://bit.ly/ngdysub1
This video tutorial walks through the process of setting up a Google form to collect contest entries. The video also demonstrates how a Google spreadsheet can be used to select a random winner. I've utilized a similar Google form to collect entries for a YouTube giveaway and I'll be randomly selecting a winner using the Google spreadsheet formula that I demonstrated in this video. This instructional video demonstrates several techniques that can be used with most spreadsheets, including Excel. I demonstrate how to create a drop-down in a spreadsheet cell using the data validation options. I demonstrate how to select a random record in a spreadsheet. I demonstrate how to add a unique number identifier when a Google form is submitted. I also demonstrate how to use that unique identifier with vlookup to pull information that was submitted with a Google form into the contest winner selection spreadsheet.
A Google form like this can be used to set up a giveaway on YouTube. You could also use a Google form and spreadsheet to set up a giveaway on FaceBook and Instagram.
#googlesheets #spreadsheet #basics