Are you ready to take your Google Sheets game to the next level? Look no further than SheetMagic, a powerful script that allows you to integrate the OpenAI GPT-3.5+ language models directly into your spreadsheets. With SheetMagic, you can generate human-like text and automate complex tasks with ease. Here’s how to get started:
Step 1: Install SheetMagic
Login to your SheetMagic account.
- Click on the big green button that says “Access SheetMagic”
- This will open up the most recent version of SheetMagic in a Google Sheet
Step 2: Create a copy of your Google Sheet
Once you have opened SheetMagic, you’ll need to create a copy of your Google Sheet to use it within your own team. Follow these steps:
- Open the Sheet you want to use with SheetMagic.
- Go to File -> Make a copy to create a copy of your Sheet.
- This copy is where you will use SheetMagic.
Step 3: Create an OpenAI account and API key
In order to use SheetMagic, you’ll need to have an OpenAI account and create a new secret key for SheetMagic. Here’s how to do it:
- Go to OpenAI’s website and create an account (if you don’t have one already).
- Once you’re logged in, go to the API Keys page.
- Click on “New Secret Key” and give it a name like “SheetMagic”.
- Copy the API key that is generated.
IMPORTANT NOTE: You may need to add a card on file to the account first before creating an API key is an option!
Step 4: Set your API key in SheetMagic
Now that you have an OpenAI API key, you’ll need to set it in SheetMagic. Here’s how:
- In your Google Sheet, click on the dropdown next to “Help” and select “SheetMagic -> Set API Key”.
- NOTE: You may need to go through some authorization steps in order to be able to use the process. There is sometimes a warning that you need to bypass in order to get to the product!
- Paste your API key in the dialog box and click “Save”.
Step 5: Use SheetMagic in your Google Sheet
Congratulations! You’re now ready to start using SheetMagic. Here’s how to use it:
- In any cell in your Sheet, type
=ai("your prompt here")to call ChatGPT.
- To use multiple cells in your prompt, separate them with commas. For example,
=ai("the beginning of your prompt,", A3, A5).
- Press Enter and watch SheetMagic generate text based on your prompt!
With SheetMagic, you can take your Google Sheets to the next level by generating human-like text and automating complex tasks. Follow these simple steps to get started and unlock the full potential of your spreadsheets. Happy scripting!