Ep 54: Winning with ChatGPT, Google Sheets and Automation

Introduction:


In today's rapidly evolving digital landscape, businesses are constantly seeking innovative ways to leverage automation and artificial intelligence (AI) to propel their growth and gain a competitive edge. A recent episode of the "Everyday AI" podcast shed light on the immense potential of using tools like ChatGPT, Google Sheets, and automation for various business functions. In this article, we explore the key insights shared in the podcast to help business owners and decision-makers harness the power of AI and automation effectively.

Streamlining Data Acquisition:


One of the key takeaways from the podcast was the ability of Hexomatic, a powerful automation tool, to integrate web data seamlessly into ChatGPT. This offers businesses the advantage of generating highly accurate responses based on real-time information. For instance, marketers and advertisers can quickly retrieve sentiment analysis on customer reviews, an activity that previously took hours or even days. By understanding customer sentiments swiftly, businesses can tailor their strategies accordingly and ensure customer satisfaction.

Increasing Online Visibility:


Through automation tools like chat deputies and page factory software, businesses can create an extensive network of service pages effortlessly. These pages can be customized effortlessly to include variables such as cities, time, and geolocation, hence significantly improving search engine visibility. This enables businesses, particularly local service providers, to target specific markets more effectively and attract potential customers in their vicinity. Generating service pages in minutes allows businesses to scale their online presence rapidly.

Monitoring Competitor Strategies:


Automation and AI can provide valuable insights into your competitors' activities. By tracking competitors' social media posting frequency and customer reviews, businesses can outline actionable strategies. For example, if competitors post five times, aiming for eight to ten posts can help your brand gain more visibility. Similarly, analyzing competitors' customer reviews and aiming for higher review volumes per week can enhance customer trust and engagement. Moreover, adopting a social listening approach to identify popular influencers and engage their followers nurtures brand growth organically.

Utilizing Sentiment Analysis:


Access to customer sentiment analysis tools has become increasingly accessible. Businesses can now leverage affordable automation tools like Charge JPT to analyze customers' opinions and feedback effectively. For instance, by employing sentiment analysis on online book reviews, publishers can obtain insights into readers' preferences, enabling them to optimize book marketing strategies and improve customer engagement. Sentiment analysis tools empower businesses to understand their target audience better and make data-driven decisions.

Competing in the Digital Age:


Staying ahead of the competition requires continuously raising the bar. Understanding competitors' strategies, learning from their strengths, and identifying their weaknesses are fundamental steps towards elevating your business's performance. By leveraging automation and AI tools, business owners and decision-makers gain a comprehensive view of the competitive landscape. Armed with this knowledge, they can craft personalized content, harness sentiment analysis, and optimize marketing efforts to resonate with their target audience effectively.

Conclusion:


The "Everyday AI" podcast highlighted the immense potential of automation and AI in driving business growth. From streamlining data acquisition to monitoring competitor strategies and utilizing sentiment analysis, these tools empower businesses to make informed decisions, enhance customer engagement, and outperform their competitors. By embracing automation and AI, business owners and decision-makers can unlock new possibilities and thrive in an increasingly digital world. As the AI landscape continues to evolve, staying well-informed and leveraging these advancements will be vital for sustainable business success.


Transcript: 

Speaker A [00:00:01]:

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.

Jordan [00:00:17]:

Could you run a handful of businesses with just AI and automation? You probably can. That's one of the things that we're gonna 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 livestream 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 guests 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 if that sounds up your alley, check it out. new one here, Google is actually testing its medical AI chatbot at the Mayo Clinic. So, obviously, you know, Google and, you you know, chatGBT 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 I guess is this something that could signal the widespread adoption of chat GPT and other things in health care that'll be interested 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 Chat GPT 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 2 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 gonna 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 guests for today. We have Patrick Mova, who is the owner of Lush Global Solutions. Patrick, so excited to have you on the show.

Patrick Mvaa [00:03:08]:

I'm glad to be here, Jordan. Thank you very much for inviting me. Alright. So

Jordan [00:03:12]:

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

Patrick Mvaa [00:03:34]:

Yeah. So under a large 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 8 Different Cities plus some parts of India. in 2 cities in Indiana. So, you know, JUPIT

Jordan [00:04:03]:

AI comes in handy, and 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 we can help you with with one business in in one city. But, Patrick, talk talk a little bit about, you know, having 8 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?

Patrick Mvaa [00:04:35]:

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 kinda use, you know, Charge JPT 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 we maybe we might put in geolocation. So, like, you know, longitude, latitude on that page, those type of things which you can all automate using, you know, chat deputy and some of this, you know, mass page, like, programmatic SEO, like, page factories type of software. So, you know, within few minutes, you have pages almost for every location.

Jordan [00:05:39]:

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

Patrick Mvaa [00:06:22]:

Yeah. So I think the most important thing first of all, just simplify everything. Mhmm. You know, most people are familiar with Google Sheets. Okay? Once you have Google Sheets, you know, you can bring in Charge JPT. So let's say you have HVAC business. Right? and you are 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 input 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 bill in your in your in your category. So what you can do is you can scrape Google Maps. Everybody knows Google Maps. Mhmm. You know? So you can bring that information into into Google Sheet. 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 t and ask charge a bit t. Hey. Based on these reviews, Give me a sentiment analysis of this business. Wow. You know? Now -- Yeah. tragic will give you the sentiment even 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. Alright? 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.

Jordan [00:08:31]:

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 if you're in marketing, admin, advertising, anything. Like, if your company gets reviews, I think that's such a great use case of using, you you know, a simple way to combine simple automation, you know, bringing in Google Sheets with chatty PT 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 leverage getting that information, you know, so quickly and and what have you been able to do with it? So, I mean, once we get that, you know, sentiment analysis,

Patrick Mvaa [00:09:19]:

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 -- Mhmm. -- we know where we need to raise our game. You know? also, that kinda, like, informs what type of content we are putting out to the public. You know? Yeah. You know, a newsletter, in our socials, in our, you know, Google My Business, all that stuff. You know? But you can also go, you know, you 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? Mhmm. What you can put in your, you know, in your new book you know, if you have a new project coming out, you can do this against, you know, competitors that have physical products. So you can do this, like, on 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. you know, you're gonna you're about to pay up. Yeah. Yeah. You know,

Jordan [00:10:42]:

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 it sounds kind of technical and dorky, but I'm gonna 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 like 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 that you're using you know, simple, you know, simple automation and AI to to run and grow your business.

Patrick Mvaa [00:11:38]:

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 are posting 5 times, we try to post 8, 10 times. Yeah. Because Google has reasons. 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, 5 reviews in a week, we try to get 10 reviews in a week. Mhmm. 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 you a favorite creator who generates a lot of engagement on their post and use the tool like button, you know, to scrap 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

Jordan [00:13:02]:

it's it's great. Yeah. Like, you you know, I throw Bardeen up on the screen here. Another simple you know, tool that, you know, works well with with, you know, chatgpt as as as well. So have have a comment or a question here -- Mhmm. -- that I wanna toss-up to you, Patrick. A great question for, 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 you know, do these things consistently in chat GPT or barge or whatever versus how much time would it take you without it. Oh,

Patrick Mvaa [00:13:41]:

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 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, and I have the sentiment analysis. Mhmm. You know? And the yeah. So it's massive time time, sir. It it is massive. Yeah. What's what's been

Jordan [00:14:18]:

Patrick, what has been the thing that you've been using with, you know, Google Sheets or or simple automations combining it with chatgpt. What do you think has the broadest use case, you know, for for our listeners out there who maybe don't own, you know, multiple businesses, but What would you say is, you know, kind of playing off of Rastafonte'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.

Patrick Mvaa [00:14:46]:

Okay. So, you know, most people is that they post on social. Right? You can literally just go to chat JPT 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 to a be your you can get to 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 it, and forget about it. You know? Yeah. Yeah. That's That's a great a great simple example because almost any business department, whatever, is is, you know,

Jordan [00:15:39]:

probably responsible for posting something, you know, creating some type of content that they put out there. So that's a great example. Yeah. You know, Patrick, that you shared. And I think an a a a thing you can do to take it a step further is make sure you're using, as an example, chatgpt plus with plugins, and then, you know, give give chatgpt your website or your competitor's website as well. it'll save you a bunch of time. So a couple Yaddie 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 I'll I'll let you take that 1, Patrick. I have a couple, but what's what's your take on that one? Yeah. So so far, I mean, bad thing is pretty good. It's a it's a it's a solid tool.

Patrick Mvaa [00:16:36]:

Of course, import from web is another tool. Also, you can go with tech so far. You know? So there's several tools out there, but, you know, so far, I think, but in will do a lot of work and also

Jordan [00:16:54]:

input from web will do a lot of work for you. Yeah. Yeah. Absolutely. I was Patrick took the answer out of my mouth. I'm a big fan of of hexa Hexomatic that we have on the screen here. Great tool. Yeah. Because you can you know, literally anything that you can think of, any data that exists in the web, you can easily bring all of that data into chat GPT and, you know, respond like, you know, Patrick has already given some great examples. You you know, yes. May break with the 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, chattyBT, something that you're excited about. You 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?

Patrick Mvaa [00:17:53]:

So building a revenue model. So, you know, you can use a tool called co efficient.i0, 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.

Jordan [00:18:19]:

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 in well, not new, but a lot of people are just getting access to code interpreter the new kind of feature in, you know, chatgpt plus that can kinda do the same thing. I don't know if you've gotten a chance to play around with that yet, Patrick. No. Yeah. No. Yeah. I just got it Saturday. So -- 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. Yeah. You know, 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 when they first heard about AI, they're a little hesitant, and it sounds like a lot. Right? And then how 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 that you think you can give to people that can really help them use the power of automation and AI.

Patrick Mvaa [00:19:29]:

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

Jordan [00:19:50]:

Yeah. Yeah. Absolutely. Alright. I lied. We're gonna take one more. One more for Marturo here asking how long did it take? It's 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

Patrick Mvaa [00:20:04]:

It is easy, but every day, it's like I'm learning new things. So have I mastered it? to to an extent because, you know, I embraced it very early, you know, when it came out. But I'm still running a 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,

Jordan [00:20:26]:

Yeah. Lending 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 the better and better you're gonna 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 to grow their business and just understand what's out there. Thank you so much for sharing all of these insights with our audience. Man, thank you for having me

Patrick Mvaa [00:21:06]:

on your show today. I'm you know, I always listen to your show, so it's awesome, man. Thank you very much. Fantastic. Thank you. Thank you. So as a reminder,

Jordan [00:21:15]:

Patrick just dumped all whole bunch of knowledge. So if 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.com. That's your everydayai.com. Make sure to sign up for the newsletter. We're gonna be sharing more about all of the things that Patrick talked about in our newsletter that goes out every day at 11:30 AM Central Standard Time. So or 11 AM Central Standard Time. So, also, make sure to out the podcast as well if you can't join livestream. So with that, thank you for joining us, and we hope to see you back tomorrow and every day with everyday AI. Thanks.

Patrick Mvaa [00:21:51]:

Thank you.

Speaker A [00:21:54]:

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 your everydayai.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.



Gain Extra Insights With Our Newsletter

Sign up for our newsletter to get more in-depth content on AI