0:00 Merry Christmas, everyone. Happy holidays. It's the end of 2024, and here is Sheets Wrapped. Sheets Wrapped is like Spotify Wrapped, but for Google Sheets.
0:10 It's going to tell you what you did this year, how many sheets you created, how many you edited, how many you collaborated with, how many people you collaborated with, sorry.
0:19 And it's going to give you some interesting other information, so get it at bettersheets.co slash sheetswrapped. Uh, you can get it absolutely free.
0:27 This is absolutely free from Better Sheets. Go get it. Get it today. Go get it now. It's for members and non-members alike.
0:34 You do not have to be a member of Better Sheets, but if you want to be, uh, in Better Sheets, I go over in over 500 tutorials, a dozen courses, and I have a bunch of tools that help make Google Sheets better for you and make your life in Google Sheets better, so consider becoming a member if you're not
0:52 a member yet, but Sheets Wrapped. This is what you get. I'll show you my copy of it here, and what you're going to get once you run the functions, Bye.
1:00 By the way, these functions run completely on your own sheet. You copy the sheet, you make a copy of it in your Google Drive, and it runs completely in your own, does not send any information to AI, does not send any data to me externally, doesn't send it externally anywhere, it's just going to analyze
1:14 your drive, and also it doesn't edit or delete any of your files, but this is what I got. I got my biggest sheet, which was create a freebie lead magnet with free data.
1:22 It's 2.95 megabytes. I've created 427 sheets this year. I've edited 576. I have 125 viewers and editors of sheets that I've created.
1:35 So, this is actually a little weird because I share sheets, or I sell sheets, and I share sheets a lot, but those sheets that I sell the most of, I created last year.
1:46 So, if I ran this last year, I have like over a thousand, or maybe actually more than 2,000. The first sheet I created of 2024 was a faceless YouTube channel study.
1:55 I've been trying to work on YouTube a lot in 2024. And it also gives me 39 untitled sheets. So, yeah, I have untitled sheets.
2:05 I keep using sheet.new, the URL to create a new sheet, all the time. So, that's all my untitled sheets. And it gives me the days until next Christmas.
2:15 This will actually update, by the way, after Christmas. So, actually after the New Year. This is a really cool thing.
2:22 It's using date diff, saying today, and then choosing the date, which is the 12th month, the 25th day of the twelfth month of whatever year it is.
2:31 So, on the New Year, it will turn into how many days until next Christmas. I think that's a really cool function, if you're interested in learning something here.
2:40 And this really quick video about this freebie here. Um, I think that's a really cool function. And also, if you're actually interested in automations and Apps Script, you get this sheet and you can actually find out how it runs.
2:54 You go up to extensions Apps Script, once it's in your, uh, Google Drive. Five. And you're more than welcome to read the automations.
3:04 Read the script. I've added some comments here and I've tried to walk you through a little bit and I'm gonna be adding to this as people ask me questions.
3:13 So, by the way, members have the ability to ask me anything. If you're getting, uh, like, if you get an email from me and you're like, what is this?
3:20 You can always email me back and be like, hey, I have this question about this. Uh, so reading through this, if you're a member and you're like, hey, what does this do or how does this really work?
3:31 . Like, it gets a little confusing around this part. Let me know and I'll go in and add more comments and I'll answer your questions about it.
3:37 And if you're really wondering how to automate your Google Sheets, I have both in my membership. I have courses called spreadsheet automation 101 and integrate AI into your Sheets.
3:49 Uh, but also I sell these courses, uh, on Udemy. So you can go and get them standalone on Udemy. Uh, actually, if you scroll down to the bottom, there's a link to the Udemy courses or the courses that you want better Sheets.
4:02 Feel free to go and get them and use them and really learn how to automate your Sheets and make really cool Apps Scripts like this very quickly.
4:09 I hope you enjoy Sheets Wrap. Uh, this is 4 2024. Enjoy it. Love it. If you hate it, let me know.
4:18 If you love it, let me know. Take a screenshot. Tweet it. I'm happy to retweet. If you tag me on Twitter at Campfi, K-A-M-P-H-E-Y.
4:26 And I hope your 2025 is way, way, way, way better. Uh, and your Sheets are better. Uh, in 2025. Bye.
4:33 Happy Holidays. Take a look your face.