Skip to content

nicucalcea/sheets-llm

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Use GPT models in Google Sheets

A simple script to use OpenAI's GPT models in Google Sheets. This allows you to do things like summarisation, translation, entity extraction, classification, etc.

Installation

  1. Open the Google Sheet where you want to use ChatGPT.
  2. Go to Extensions > Apps Script.
  3. Copy the contents of Code.gs and paste it into the script editor.
  4. Copy the contents of settings.html and paste it into a new HTML file with the same name.
  5. Save both and reload the Google Sheet.
  6. You should now see a new menu item called LLM. Click on it and then Settings.
  7. Enter your OpenAI API key and save.

Usage

You now have access to a new =LLM() function in Google Sheets. You can use it like this:

=LLM(<input_text>, "Summarise the text", "gpt-4o-mini", 0)

By default, the function uses the gpt-4o-mini model with a temperature of 0, but you can change it to gpt-4 for more advanced tasks or increase the temperature for more creative responses.

To-do

  • Add support for non-OpenAI models

About

Use Large Language Models (LLM) in Google Sheets

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published