Why This Matters 🤔
Ever wished decisions could be made for you? This simple Make.com setup acts like a digital lottery, randomly selecting an item from a list. Think giveaways, choosing a snack, or even deciding who does the dishes (no more arguing!).
1. 📝 Setting Up Your Contestants
- Use a Google Sheet to list your potential “winners.” Each row is a separate entry.
- Add a “Won” column and leave it blank for now. This helps prevent someone from winning twice.
2. 🔍 Finding Eligible Participants
- Use the Google Sheets “Search Rows” module.
- Point it to your sheet and specify the sheet name (e.g., “Names”).
- Crucially, filter your search: In the “Won” column, set the condition to “does not exist.” This ensures only those who haven’t won before are considered.
3. 🎲 The Randomization Magic
- Combine entries into a single bundle: Use the “Array Aggregator” module. This takes the output from your Google Sheet search and puts it into a format Make.com can easily work with.
- Shuffle the deck: The “Set Variable” module is the key. Use the “Shuffle” array function within this module. It takes your bundle of entries and randomly re-orders them.
- Pick a winner: Since the list is now randomized, simply use the “First” array function to grab the top entry. You now have your randomly selected winner!
4. 🏆 Declaring and Updating
- Update the “Won” column: Use the “Update a Row” module.
- Connect it to your Google Sheet and map the “Row Number” from your winner selection.
- In the “Won” column, set the value to “Yes” (or a timestamp, prize details, etc.).
5. 🚀 Beyond the Basics
- Rename your modules! This makes your setup much easier to understand later on.
- This technique works with any module that outputs multiple bundles. Get creative!
🧰 Resource Toolbox
- Make Functions Cheat Sheet: Demystify those powerful functions!
- Scenario Blueprint: Get a head start with a pre-built template.
- [Download from Video Description]( [Link to Video Description – Replace with actual link] )
- Make.com Pro (Free Trial): Unlock more power for your automations.
🎉 You Did It!
You’ve just built a no-code lottery system! This is a fantastic example of how Make.com can automate decisions, making your life easier and more fun.
