AI in Google Sheets: GPT-4 In Your Spreadsheet
Entry Point AI Entry Point AI
3.93K subscribers
443 views
0

 Published On May 2, 2024

🎁 Join our Skool community: https://www.skool.com/entry-point-ai

Learn an amazing trick to use OpenAI models directly inside Google Sheets. Watch as I transform whole columns of data using an AI prompt in seconds! After this video, you'll be able to do awesome things like write creative copy, standardize your data, or extract specific details from unstructured text.

Topics covered:
0:27 Demo of LLM calls directly in Google Sheets
5:33 The custom function in Google Sheets and how it works
9:39 Where to add your API key
10:53 How to create your OpenAI API key
12:57 Wrapping it up

The code shown in the video can be found in this Github repository:
https://github.com/markhennings/googl...

Just copy, paste, and add your API key. If you like it, give the repository a star. If I see enough people using it, I'll add code samples for other LLM providers.

Tip: There are two versions of the code on Github—one that I walked through in the video and another that includes a caching feature to minimize usage costs.

To support your new spreadsheet AI superpowers, you may quickly need a place to iterate on your prompts, evaluate their performance, and even fine-tune models. We're here to help. Learn about Entry Point AI solutions on our website at https://www.entrypointai.com

If you enjoyed the video, press subscribe for more upcoming AI tutorials, tips & tricks, and deep dives!

Follow me on LinkedIn:
  / markhennings  

show more

Share/Embed