ChatGPT integration with Google Sheets

are not like me need to watch to the end of this video I'm about to tell you tell you how you can enter into gbt so artificial intelligence with your Google sheet now this can make a world of difference to provide to your clients to just for yourself it is incredible now if you are an entrepreneur if you're a female coach or consultant I have low to the new client generator which is a free template that gives you email scripts and social media Scripts you don't have to do any of the hard work and you have contouring through click that link below and please guys watch all the way through this video if you like it please remember to check it a like And subscribe oh right I am not laughing about in this one um what I want you guys to do is open up a Google sheet because that's what we're into creating chart Champions chat GPT with now the first few things I would love to make this Google sheet routine for now but it's not the point of this video I don't need to show you how to make something pretty um we're just going to do the basics so that you guys can understand and start implementing it into your own Google Sheets yourself so if you open a Google sheet all good just making sure that you've got this little tab here for extensions now the next thing I want you to open is your open AI account then I want you to open open AI now you probably have to log in not probably you would definitely have to log in to use this feature so once we're in we just want to click personal and we want to go view API key now you can see I've already created two here what you're going to do is you're going to create new secret key and we'll come back to that because we need to get a little bit of code first to actually put it into our Google sheet to ensure this is working now don't stress the code is going to be below this video and I'll show you exactly where to put you on APR key it is so so simple so just don't stress okay I don't actually know who to thank for this code um but I would love to keep credit so Abby I'm going to assume Abby Raja credit to that person now what we want to do is we just want to grab this code so we're going to copy it all the way up here and then we're going back over into our Google Sheets now remember how I said we needed to have that extension tool so we go into extensions we're going to go into apps script now from here we are going to get rid of that and then paste what we just found in now right at the top it even says thank you Abby to enter your secret um key here now your secret key is back here in your API Keys we come back here we're going to create new key and then we're going to copy that we're going to bring that over here perfect there we go now you can see that's the code I actually don't understand code but I know that this works because I've done it a few times so I'm just going to name the project and I'm going to say now what you're going to see over here is when I do equals AI it comes up and it completes your profitable chat GPT or GPT through images of awesome right you can see here that I have just jumped back in because I didn't like how it looked so accurately touched a few things up and I just made sure that chart GPT was working um now what you can see here is we've just got it to name a business so I'll call um I had to generate that in a minute and then what services would the business provide here they are so I'm going to go down right and all right um actually yeah we want to go sorry so in this box here what we want to do is we want we won't chat gpts right out for us we're going to go equals a r or Open Bracket quotation um copied are you looking for Reliable Partners helping with business needs I don't know about the Luminous Solutions we provide a wide range of services to help you take your business to the next level our experienced team of professionals can help you with website design and development software development mobile app development data analytics and business intelligence Cloud Solutions and infrastructure digital marketing and SEO I Ai and machine learning Solutions I.T consultant and support cyber security such as the whole list here now this is really cool if you want to give it to a client or if you want to use it yourself although you can also just plug it into chat gbt as well so just a reminder here again I don't think I went over very much so it's equals whenever it equals AI because that's what actually prompts chat DBT then we want to open up brackets make sure we've got that quotation there we're going to write in response so this is like what we would give chat GPT so it's a prompt and then here when you're operating yourself and you want to do quotations and and then we want to do the same numbers we're going to go B2 and then we're going to go and and outside there and then we're going to close brightness like that um so that's just a reminder about how you guys do it and you can go through and do it right back to you occasionally you'll get a little error message so just make sure you're actually about clearing that up make sure that the error message sometimes it's because charge EBT I think is full um so you're going to get error codes even if you went straight into charge EBT but also sometimes your equation just might be wrong you might have to play around with a few little things to help Excel understand what you are doing or sorry my Excel Google Sheets I understand so anyway guys I know the quality of this footage is fantastic this week I'm actually over in Bali but I really wanted to share um how to integrate chat GPT with Google Sheets because I think it's extraordinary and I know my content has been a lot around artificial intelligence recently but that's because I think it's the way the future and I think that we should all be using it I think we should all be using it just to move forward a little bit quicker like this is nothing wrong with having someone holding a hand and help us through and this is the best personal system I think that you will ever get in your life sorry anyway remember guys if you did like this video please remember to like And subscribe to my channel and if you are a coach or consultant I do have that link below this video to the new client generator which literally gives you the description to follow in your emails on your social media to get new clients following in through your doors uh also below this video had the link to that code so that you can copy and paste it over into your own Google Sheets I think I made it as simple as possible hopefully you guys understand um because that's how I got towards you anyway I will see you next week

Channel: Peach Consulting

Views: 5,108

Keywords: small business, fempreneur, online business, business coaching, business advice, smallbiz, biz, entrepreneur, peachconsulting

Id: IkV9ElKFrcM

Length: 7min 43sec (463 seconds)

Published: Tue Feb 07 2023