This project integrates AI models (Anthropic's Claude or OpenAI's GPT) with Google Sheets, allowing users to dynamically generate AI responses based on input from two columns.
- A Google account with access to Google Sheets
- An Anthropic API key for Claude AI or an OpenAI API key for GPT
- Open your Google Sheet.
- Go to
Extensions
>Apps Script
. - Replace existing code with the provided script (choose Claude or GPT version).
- Replace
"YOUR_API_KEY_HERE"
with your actual API key (Check Advanced Guide for Help). - Save the project and Run (Give required permissions).
- Use column A for the Prompt and column B for any additional value.
- In column C, enter the formula
=Claude(A2,B2)
for Claude AI or=GPT(A2,B2)
for GPT. - Enter content in columns A and B. The AI response will generate in column C.
For more detailed information, customization options, and advanced features, please refer to the Advanced Guide.