EP 54: Winning with ChatGPT, Google Sheets and Automation

This is the Everyday AI show, the everyday podcast where we simplify AI and bring its power to your fingertips. Listen daily for practical advice to boost your career, business and everyday life.

Could you run a handful of businesses with just AI and automation? Ah, you probably can. That's one of the things that we're going to be talking about today on Everyday AI. This is for the everyday person. We're helping you learn and leverage AI. There's always so much going on. So this show, this live stream podcast and our free daily newsletter is dedicated to helping everyday people actually use and understand everything that's going on in the AI world. So before we bring on our guest today and we talk about how you can use automation and AI to run so many parts of your businesses and even multiple businesses, let's first take a look at some things that are going on in the, in the news, in the AI news world. So let's dive in. So there's a new Netflix documentary coming out tonight called Killer Robots and it's looking at the, the use of AI and robots on the battlefield worldwide. And you know, there's been a lot of press on this just looking at how world, world powers are just rushing to get this new tech on the battlefield. So that's interesting. If that sounds up your alley, check it out, a new one here. Google is actually testing its medical AI chatbot at the Mayo Clinic. So obviously you know Google and you know ChatGPT and Microsoft, they all have their dedicated general use chatbots that a lot of us use every day. But Google is actually testing its medical only chatbot at the Mayo Clinic, which is one of the best clinics in the world. So I guess is this something that could signal the widespread adoption of ChatGPT and other things in healthcare? That'll be interesting to find out. Last but not least, are we breaking up with Chat GPT? So this has been widely reported, but a new CNET article that we'll link to in our newsletter takes a pretty deep dive into this because for the first time in June, OpenAI ChatGPT saw a decrease in traffic to their website. I actually don't think it's, you know, people breaking up with Chat GPT at all. I'd say it's mainly two things. One is they release their iOS app with new functionality. So I think just more people started using the app versus the website. And second, students, you know, students, they're, they're done with school for the most part in June, July. So I think we're going to see that uptick. You know in August or September come back. So let's, let's get ready now. So if you have questions about how you can use automation and AI, get them ready because Very, very excited to bring on our guest for today. We have Patrick mva who is the owner of Lush Global Solutions. Patrick, so excited to have you on the show.

Glad to be here, Jordan, thank you very much for inviting me.

All right, so you will definitely put, put a link in here to check out Patrick. He's always sharing just great things on LinkedIn, how people can just, just really simplifying AI and automation. So shout out to Patrick for that. But Patrick, just, just tell, give everyone a quick breakdown of what it is that you do at Lush Global Solutions.

Yeah, so under Lush Global Solutions we have several businesses but I mean for this talk I'll just bring out, bring up one of local business. We service Kentucky area. We have a house cleaning business and we are in about different, eight different cities plus some parts of Indiana in two cities in Indiana. So you know, Jupiter AI comes in handy when you're in so many cities.

Yeah, yeah, that's, that's a good point. You know it's, it's something we talk about on the show. You know, a lot of times we talk about how it can help you with, with one business in one city. But Patrick, talk, talk a little bit about, you know, having eight different local service based businesses is a lot. You know, I know you probably have a small team, you know, but how, how have you been using AI or ChatGPT to help you, you know, really grow in eight different locations? Yeah.

So when you're in, you know, local service, you need a lot of service pages. And the good thing with, you know, with service pages you can only do one thing, same way, you know, everywhere you go. So you know, we kind of use, you know, Chat GPT to create service pages. You know, what we do. So we explain what we do and everything. Then we put in some variables so like, you know, we change variable like cities, you know, maybe time and maybe we might put in geolocation so like longitude latitude on that page, those type of things which you can all automate using ChatGPT and some of this mass page programmatic SEO like page factory type of software.

Sure.

So within a few minutes you have pages almost for every location.

Yeah. It's wild how much you can actually do not just inside ChatGPT but specifically when you start bringing in other outside tools. So I know Patrick, you're probably using Google Sheets to put in some automation in there tools. I think we talked pre show like Bardeen, but for the everyday person that's maybe not super familiar with using other tools in addition to the simple ChatGPT interface, what's a good way to get started and maybe even talk a little bit about how you're specifically using GPT with things like Google Sheets.

Yeah. So I think the most important thing is first of all, just simplify everything. Most people are familiar with Google Sheets. Okay? Once you have Google Sheet, you know, you can bring in ChatGPT. So let's say you have H vac business, right? And you're familiar with Google Sheets. What you can do is you can just download a little extension from a company called no data, no Business. This little extension is called import from Web. Okay, what you can do, let's say you want to, you know, to, to get the sentiment, I mean to get the competitive landscape of your bit in your, in your, in your category. So what you can do is you can scrape Google Maps, everybody knows Google Maps, you know, so you can bring that information into, into Google Sheets, okay? And you can, so you can look for things like reviews, what reviews out there, the date of reviews, okay. Phone number of the company, everything. You can do that now from the Google Sheet, what you can do now you can collect those reviews and push them. Let's say to, to, to charge a bit team and ask ChatGPT, hey, based on these reviews, give me a sentiment analysis of this business.

Wow.

Now ChatGPT will give you the sentiment either, you know, you give you both actually positive and negative. Now from that you can drill down and say, hey, based on this, this analysis, what are the keywords most appearing in both negative and positive? All right, then from that you're gonna, you're gonna get first you're gonna know how people feel about that business. Then you can come up with strategy.

Yeah, that's great. That's great, Patrick. And I think it's, it's a way that so many, not just business owners, but if, if you're in marketing, administration, advertising, anything like if your company gets reviews, I think that's such a great use case of using, you know, a simple way to combine simple automation, you know, bringing in Google Sheets with ChatGPT, because you can start to find things out about your business. You know, you talked about the sentiment analysis. You can start to find things out that would used to take many hours or sometimes days. How have you been able to, to leverage getting that information, you know, so quickly? And what have you been able to do with it.

So I mean, once we get that, you know, sentiment analysis, first thing, we know exactly what we need to do. So if we are doing that against the, the competitor, we know, okay, this is, this is what we need to compete on. We need to be better now on our case, when we do it for our company, we know where we need to raise our game. You know, also that kind of like informs what type of content we are putting out to the public, you know. Yeah. In our newsletter, in our socials, in our, you know, Google my business, all that stuff, you know, but you can also go, you know, you don't have to do this just for Google Maps. So if, let's say you're an author, you know, you can pull reviews from Amazon, see what people feel about other authors, right. What you can put in your, you know, in your new book. You know, if you have a new project coming up, you can do this against, you know, competitors that have physical products. So you can do this like on different, different products, different services. And as you say, I mean, sentiment analysis tools used to be expensive. If you look online, they do not even show you a price. You have to book a demo. So you know you're gonna, you're about to pay out.

Yeah, yeah. You know, Patrick, Patrick mentioned, you know, this, this tool, I threw it up on the screen. But if you're listening on the podcast called no Data, no Business, haven't used that one personally, but I've used plenty of tools in my time. So you know something, it sounds kind of technical and dorky, but I'm going to try to break it down here. But you know, kind of what Patrick is saying, and I think what's really relevant to a lot of people is there's so much open information out there on the web that with some basic scraping tools, you know, Patrick's example is perfect. You know, if you're an author, you can find someone that wrote a book similar to you. You can scrape every single review that they have on any platform and use sentiment analysis to see what did people actually about the book and what did they not. I think that's a great use case. You know, Patrick, maybe what are some other ways that you're using, you know, simple, you know, simple automation and AI to run and grow your business.

So another thing is our socials, you know, we have a list of key, so we look at what our competitors are posting, how many times they are posting, and we just automate that process. You know, so if they're posting five times, we try to post eight, 10 times. Yeah. Because Google loves recents, you know. And also, you know, we look how many times they get reviews. Let's and we get an average per week, how many reviews and how often. So if they get let's say five reviews in a week, we try to get 10 reviews in a week. Yeah. So that's how we get to compete with them. Yeah. Other simple thing that you can do is social listening. I mean for people here on, on LinkedIn. Most people, they want, you know, to grow their, their brand, you know, they want to, you know, to get engagement. You can just find your favorite creator who generates a lot of engagement on their post and use a tool like button, you know, to scrape, you know, the list of people who are commenting, you know, and you can put that in Google sheet and you can start engaging with them, you know.

Yeah, so it's great. Yeah. Like you know, I throw Bardeen up on the screen here. Another simple, you know, tool that you know, works well with, with you know, Chat GPT as, as well. So have have a question here that I want to toss up to you Patrick. A great question from Rastafa saying can you estimate how much time you save in operational duties versus automating products and services? So all these things that you're talking about, how much time is it taking you to, you know, do these things consistently in Chat GPT or Bardeen or whatever versus how much time would it take you without it?

Oh man. So just think, let's say, you know, if I need to scrape 500 reviews of, you know, by hand on Google Maps, that is, yeah, that will take days, you know, but with you know, import from web literally takes me minutes, you know, then I just copy paste, put a prompt on chat GPT and I have the sentiment analysis, you know. Yeah. So it's massive time saver. It is massive. Yeah.

Patrick, what has been the thing that you've been using with Google Sheets or simple automations, combining it with ChatGPT, what do you think has the broadest use case for our listeners out there who maybe don't own multiple businesses? But what would you say is playing off of Rastafa's question? What is one of those things that you can get the most time gained for, you know, day to day tasks that most people are probably doing?

Okay, so you know, most people listen, they post on social, right. You can literally just go to ChatGPT and ask it for a simple content calendar, you know, and it will give you a content calendar and from there you can create, you Know, you can get your, your, you can get your, your content. You. All you need is to edit, you know, so you sound, you know, put your voice on it and use one of these, you know, you can use native scheduling tools like on Facebook, on LinkedIn and upload that content schedule and forget about it, you know.

Yeah, yeah, that's a great, a great simple example because almost any business department whatever is probably responsible for posting something, creating some type of content that they put out there. So that's a great example, Patrick, that you shared. And I think a thing you can do to take it a step further is make sure you're using as an example chatgpt+ with plugins and then give chatgpt your website or your competitor's website as well. It'll save you a bunch of time. So a couple yaddy said. Sounds like something fluid memory could do. Yeah, talk, talk to Peter about that. We'll be featuring that tool at some, at some point just to scrape. Consolidate. Yes, exactly. VAL asking. So here's, here's a good question. Val's asking any other tool that you can recommend to scrape the, to scrape the web. So I'll let you take that one, Patrick. I have a couple. But what's, what's your take on that one?

Yeah, so so far I, you know, Badin is pretty good. It's a, it's a solid tool. Of course, Import from Web is another tool. Also you can go with Hexify, you know, so there are several tools out there. But you know, so far I think Budding will do a lot of work and also Import from Web will do a lot of work for you.

Yeah, yeah, absolutely. Patrick, took the answer out of my mouth. I'm a big fan of Hexamatic that we have on the screen here. Great tool because you can literally anything that you can think of, any data that exists in the web, you can easily bring all of that data into ChatGPT and respond like Patrick has already given some great examples. Yes, May Brit with the comment here. It seems like a great tool. This episode is exactly why what she needed for one of her clients. Great. I'm glad this has been insightful. You know, Patrick, what's, what's maybe one thing that you're working on now, you know, at least in the realm of, of AI and automation, you know, chatgpt something that you're excited about, you know, because obviously this space is, is always growing. It's, it's moving so fastly what's caught your attention and that other people might be interested in as well.

So building a revenue model. So, you know, you can use a tool called Coefficient IO and you can connect Google Sheet to your stripe, you know, and you can bring all your stripe data and from there you can build a solid dashboard. You can do your forecast, your revenue models. You can do everything. So that's what I'm, you know, I'm putting together this week. That's what I'm working on this week.

That's, that'll be an interesting one. And I think, you know, something that we haven't talked a lot about on the show yet is the new feature. And, well, not new, but a lot of people are just getting access to Code interpreter, the new kind of feature in ChatGPT plus that can kind of do the same thing. I don't know if you've gotten a chance to play around with that yet, Patrick.

Not yet, not yet. I just got it Saturday.

Yeah, yeah, yeah. Most people are just getting it over the last couple of days, so I'm sure we'll be sharing about it more on the show here soon. But Patrick, just, just as we kind of wrap up the show, what would your kind of, you know, one piece of advice be? Because I think that people, you know, when they first heard about AI, they're a little hesitant and it sounds like a lot, right? And then now we're saying, hey, use, use even more. You know, bring in automation, bring in Google Sheets. And it sounds like, you know, even, even more complex, even though it's not. But maybe what's a simple, kind of a simple takeaway message that you think you can give to people that can really help them use the power of automation and AI?

Just get started. Early adopters always get rewarded. Get started, be familiar with the tools. Of course, right now you cannot just unleash them. You still have to put your voice. But it will be a significant optimization in your organization.

Yeah, yeah, absolutely. All right, I lied. We're going to take one more. One more from Arturo here asking how long did it take? This is a great question. How long did it take for you to master Chat GPT for your business? It's not always as easy as it seems, right?

Yeah, and it is easy, but every day it's like I'm learning new things. So have I mastered it? To an extent, because, you know, I embraced it very early, you know, when it came out. But I'm still learning every day. Every day I go in there, I'm like, oh, man, I can actually do this, you know, so it's A continuous, you know, learning thing.

Yeah, absolutely. And I think, you know, Patrick's advice, you know, right there just every day, you know, that's it's something we try to encourage people is like try to start phasing out traditional search, right? Not saying stop using Google, but you know, the more that you can use chat, GPT and some of these things that Patrick talked about as well, the better and better you're going to get and the more efficient you'll be as well. So, Patrick, we talked about so much in this episode. So many different tools and techniques that people can use to grow their business and just understand what's out there. Thank you so much for sharing all of these insights with our audience.

Thank you for having me on your show today. I always listen to your show, so it's awesome, man. Thank you very much.

Fantastic. Thank you. Thank you. So as a reminder.

Thank you.

Patrick just dumped a whole bunch of knowledge. So if, if you weren't able to keep up and catch every single thing that he talked about, don't worry. Head over to your everydayai dot com. That's your everydayai dot com. Make sure to sign up for the newsletter. We're going to be sharing more about all of the things that Patrick talked about in our newsletter that goes out every day at 11:30am Central Standard Time, so or 11:00am Central Standard Time. So also make sure to check out the podcast as well if you can't join the live stream. So with that, thank you for joining us and we hope to see you back tomorrow and every day with Everyday AI. Thanks.

Thank you.

And that's a wrap for today's edition of Everyday AI. Thanks for joining us. If you enjoyed this episode, please subscribe and leave us a rating. It helps keep us going for a little more AI magic. Visit youreverydayai.com and sign up to our daily newsletter so you don't get left behind. Go break some barriers and we'll see you next time.