Solve the Secret Santa Mix-Match with Google Sheets and Apps Script
▻https://hackernoon.com/secret-santa-mix-match-with-google-sheets-and-apps-script-hashnode-6a725
Originally published on Hashnode : ▻https://hashnode.com/post/secret-santa-mix-match-with-google-sheets-and-apps-script-cjptefe1d00rikas Apps Script has always been a tool in the shadow. Many developers don’t know about this tiny #javascript-based powerful scripting language. In this tutorial, I will show you how to build a very simple Secret Santa mix-match using Google Sheets.All reference links, code, random generators are listed at the bottom of the article.The ProblemYou have a huge list with people’s names/emails/whatever, and now you want to shuffle them and then assign their respective partners randomly.This can be a really time-consuming task, but instead of doing this manually, I’ll show you how to automate this process.The SolutionGoogle Apps Script is this less-known (...)
#google-apps-script #productivity #automation #google-sheets