A Google Gemini AI / LLM Prompt function script for use in Google Sheets
=spits(_apikey_, _prompt_)
Example:
| Column A | Column B | |
|---|---|---|
| Row 1 | JPMorgan Chase | =spits("fake-api-key-123-insert-yours-here","Get the website for "&A1) |
| Row 2 | The company that makes World of Warcraft | =spits("fake-api-key-123-insert-yours-here","Get the website for "&A2) |
| Row 3 | The Flight Academy in Renton, WA | =spits("fake-api-key-123-insert-yours-here","Get the website for "&A3) |
-
A Google Gemini API Key from https://aistudio.google.com/app/apikey
-
A Google Sheet with App Script enabled