Gemini is EVERYWHERE
In this live session, the creator discusses the integration of Gemini with Google Sheets, showcasing the new Happy Sheet tool for automating birthday emails and exploring the challenges and benefits of using Gemini in AppScript.
All right, we're live. I think uh this I'm going to send another link now. Uh here's the real link. Thanks for joining anyone who's here. Um we're going to start fairly soon. I just wanted to share what I've been working on this week.
Yeah, that should be good. Uh, those who came, great. Comment below. Comment below somewhere here that you got here even with with a faulty link in the email.
I'm going to make a copy of it and use some Gemini as well and see if we can add some cool stuff.
there is a chat here. If you're coming watching this live, please use it. Ask questions . This isn't just me showing you stuff.
But you're here. You're watching. We are going through Happy Sheet , a new product that I made that automatically sends birthdays.
if you are trying to automate your sheets and you're just starting out, automate is way better. And I'm going to try to share with you what's going on in uh what's going on in Gemini , why I think automate works better.
and there is Gemini on the right side of AppScript now.
I watched a really nice uh lecture by Jeff Dean, who was until very recently the head of Google research.
I think this is going to be the worst it ever is. It will get better. I think the Gemini model is pretty crazy good.
the main idea is you list your people that you know, the dates of their birthdays and you write birthday here.
what this baker said is, "Hey, can you give me a Google sheet that just says, "Here's everybody's birthday and I let's send them an email.
So, what does the appcript look like? Um, one thing I did differently is I put all of these variables at the top.
So that's just information to you that this sheet sort of tells you sends to you.
So let me go over to happy sheet enable automatically daily emails on that day.
with birthdays, with anniversaries, with work anniversaries, especially when we're selling this to bakeries.
So, I want to add a settings here. Adjust date.
So, I have a function all of this right here.
And honestly, I could just copy paste this, but let's do let's let's lean on Gemini and see what happens.
going to go over to Gemini and say, "Hey, create these enable and disable
The second gotcha that I found is that if I am not specific and I give it basically I've already written some code and I want to add to that code.
Here's another gotcha, a little just wishful wishful wish for this is this takes a while.
Here's the gotcha that I've I've run into before is one big gotcha is like you really need to already know how to write appcript to really give the right context to say write this thing.
is it tries to do one more thing and it'll ask you do you want me to do this if I didn't know clearly what I wanted I might just continue doing whatever it suggested.
Um, is the offset days are adding so it's setting the date plus those days um so should those days be ne negative do I want to be sending and actually this is something I should ask it.
emails. Okay. So this offset emails function here.
and actually I don't know if it's flash. It should be flash but um because it's just cheap, right?
and we think and originally when I was doing this I was thinking this is for me. this is for me to consume and I was like I don't really want to like read all of this stuff.
we could do that, right? It's choosing one of those ways.
I don't know if I explained that. So, the email is really cool because it uses this bracket name notation .
So, that's the cool thing about Happy Sheet .
So, if you're watching this and you are not a member, so lifetime members get Big Year , completely free.
premium now for a little bit of money, you get a ton of templates and I've been adding to these templates.
there's also a tall version where all of the months go vertically up and down.
You might not want to print that big.
I also added a lunar phase uh moon calendar.
I also added this year a um prolific oak tree here.
Um, and what we're doing is we're saying we're trying to get a the lunar phase which is like 27 point you can see here 27.6 um and finding out where does it live in this.
and it turns into this really cool lunar face.
we have Oh, this one is really fun.
Um, and to plan the year out, block it out this way.
So, if you're watching this and you are not a member, so lifetime members get Big Year , completely free.
What it does actually is it'll it'll duplicate .
Hopefully it does it correctly.
So, this is not great for planning ahead, but rather capturing what you've done during the year if it's on your Google Google calendar.
There it is. Okay, so let's keep going through this line by line.
and it writes them to the sheet.
So let's look at writes to sheet.
So, let's keep going through this line by line.
Um, and this is really funky.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.
So, let's look at writes to sheet.