GPT_TABLE and setup

0:00 Google Sheets and Chad GPT are the world's most popular productivity tools so we just have to make them work together in today's video I'm going to show you how to use Chad GPT inside Google Sheets and I have some incredible use cases to show you the most common one for example is managing contacts inside sheets but we're on YouTube and I obviously do not want to show you actual data so let's use chat GPT to generate a list of contacts in the first cell let's type equals GPT table now I need to enter the prompt in parentheses make a fake list of leads include their first last names emails LinkedIn profiles Etc they're drinking GPT table function generates tables from scratch so you can create a financial report or even a grocery list here's a templated income statement and a healthy grocery shopping list for the entire week on a budget of seventy dollars here I even have calories and macros isn't this amazing hold your horses very important dysfunctions are not available in Google Sheets by default we'll need to enable them by using a Google Sheets

1:09 add-on it's called GPT in sheets let me show you how to install it click on extensions add-ons get add-ons and the app is called GPT for Sheets you can just type it in search GPT more sheets that's the one click on install continue next up we'll need to connect this plugin to our openai account this is done through an API key it's like a password that allows the add-on to make a quest to open AI let's do exactly this let's click on set your API key and then here we need to paste the API key from openai to do that you need to go to platform.openai click on create new secret key give it name Google Sheets demo create the key and copy it to your clipboard