This will save you a lot of hours of work.
Here’s how to set up Claude for Google Sheets: ⤵️ (1/4)
1️⃣ Get your Claude API key:
Without a developer API key, you won’t be able to use Claude for Sheets.
API information: https://docs.anthropic.com/claude/docs/getting-access-to-claude
2️⃣ Install the Claude for Sheets extension:
→ Go to https://workspace.google.com/marketplace/app/claude_for_sheets/909417792257
→ Click “Install”
3️⃣ Enable Claude for Sheets:
→ Open a new workbook
→ Go to Extensions > Add-ons > Manage add-ons
→ Click the three-dot menu in the top right corner of the Claude for Sheets extension and make sure “Use in this document” is checked
4️⃣ Connect your API key:
Enter your API key in the Extension > Claude for Sheets™ > Enter your Anthropic API key.
You may need to wait or refresh “Enter your Anthropic API key” for it to appear as an option.
That’s all, the original author @mushfiq_sajib