Claude for Sheets™ brings the helpful, honest, and harmless AI assistant Claude from Anthropic right there in your Google Sheets™.
===SETUP===
After installing the extension, make sure its "Use in this document" setting is checked by going to Extensions -> Add-ons -> Manage add-ons -> and clicking the ⋮ icon of the add-on. Then, reload the sheet tab and wait 5-10 seconds for the Claude for Sheets™ pop-up in the bottom right corner. Here’s a quick video of this process - https://youtu.be/d8HiCnCnz6U
Follow its instructions to "Enter your Anthropic API key". You can get your API key here: https://console.anthropic.com/

Once you've entered your API key, you'll have access to the following new formula functions:


★ =CLAUDE() - This is identical to talking to Claude on claude.ai. Unless you are using Claude for Sheets™ for prompt engineering, this is the function you'll probably want to use most of the time.

★ =CLAUDEMESSAGES() - Send a series of User: and Assistant: messages to the model, one per line:

=CLAUDEMESSAGES("User: Hello!
Assistant: Hi.
User: Bye!
Assistant:")

Useful for multiturn conversations and to "put words in Claude's mouth", for instance to skip preambles. Each new role must be preceded by a newline (Ctrl/Cmd+Enter). To use a “System Prompt” in =CLAUDEMESSAGES, set it as a parameter after specifying the model. (The model is a required arg, so you must set the model to use any other required args.)
Example call with system prompt:
=CLAUDEMESSAGES("
User: Got anything to say to me?
Assistant:", "claude-2.0", "system", "You are a cow who loves to moo in response to any and all user queries.")


★ =CLAUDEFREE() (legacy) - send a free-form prompt to Claude’s API and return the response. This is identical to calling the Text Completions API, which means you will need to wrap the prompt in “\n\nHuman: ${prompt}\n\nAssistant:”. See https://docs.anthropic.com/claude/docs/introduction-to-prompt-design for more information.

Each function has parameters that will be explained in a tooltip as you start typing it in a cell. Full documentation is available at https://docs.anthropic.com/claude/docs/using-claude-for-sheets


For example, if you put in a cell,
=CLAUDE("When was the US Constitution written?")
The add-on will make a Messages API call to Anthropic. Claude may respond with:
"The United States Constitution was written in 1787. It was ratified in 1788 and went into effect in 1789."

=== WHAT THE ADD-ON CAN DO ===
★ rewrite text in a particular style
★ translate text
★ classification (e.g. customer inquiries into categories)
★ extract information (emails, phone numbers, addresses etc.)
★ help remove personally-identifiable information

★ summarize content
★ role play (e.g. career coach)
★ advanced document Q&A with citations

★ chain prompts
★ ...and many more - you can ask Claude anything!

=== FEATURES ===
★ Automatic in-sheet caching to reduce API call costs
★ Throttling capability to further control API calls in sheets with many =CLAUDE... cells
★ on-demand and background recalculation for cells that need to be deferred due to API key concurrency limits


=== SHARING ===
Data passed to =CLAUDE... functions will only be shared externally with Anthropic, as described in our Privacy Policy at https://console.anthropic.com/legal/privacy.
Note that if you share a Claude for Sheets™ spreadsheet with other users in your Google Workspace organization, they will be able to use the custom functions without having to install the add-on. The API key will be available as well to the add-on (so that the custom functions can make the Anthropic API calls), but the users won't be able to see it. The “Claude for Sheets™” menu will be visible, but trying to use its functions will prompt the user to install the add-on first.
If the Claude for Sheets™ spreadsheet is shared with users outside the organization, they will be able to use the custom functions (with the API key that was entered before sharing the document) as well, but won't see the “Claude for Sheets™” menu until they install the add-on.


=== PRICING ===
The Claude for Sheets™ add-on is free. However, the add-on relies on your Anthropic API key, and any API calls made from the add-on will be billed at your normal pricing schedule with Anthropic via your account associated with the API key. Please be careful with sharing this add-on, your Anthropic API key, or any associated Google Sheets™ with the Claude for Sheets™ add-on. Please confirm that any recipient of your Google Sheets™ with the Claude for Sheets™ add-on understands the billing will occur on your Anthropic API account (see SHARING section above). 


=== HOW IT WORKS ===
The =CLAUDE... custom functions make API calls to Anthropic and cache the responses for 1 week in a hidden sheet called "Claude Cache" that will be added to your spreadsheet. Don't edit or delete this sheet unless you want to empty the cache! Also be aware that there's a secondary (faster) cache that can't be emptied, but expires after only 6 hours. Both caches are stored within the Google Cloud. Anthropic does not cache or store prompts or responses.
Your Anthropic API key may have a limit on the number of concurrent requests. If the add-on runs into this limit, you will see `⚠ DEFERRED︎ ⚠` cells. To recalculate these cells within the concurrent requests limit, choose one of the "Recalculate..." functions in the "Claude for Sheets™" menu. 


=== ADDITIONAL TIPS ===
Google Sheets™ may periodically recalculate cells (e.g. when inserting a row or column before =CLAUDE... cells). Thanks to the caching feature, no API calls will need to be made, unless the cache entries have expired (1 week by default). 
If API calls do need to be made, and you want to control API call costs further, you can use the Throttling feature. Go to Settings, and set a value for the "Throttling" option, e.g. 3 seconds. This means that at least 3 seconds must pass between API calls (i.e. =CLAUDE functions not finding a result in the cache) for the add-on to send the API calls to Anthropic. When Google Sheets™ decides to recalculate cells en masse, the interval between API calls will be shorter (typically 1-2 seconds), so most API calls will be gated until you disable this feature by setting the Throttling to 0 and choosing "Recalculate..." from the Claude menu. When you enter formulas manually, typically more than 3 seconds will pass since you've entered the last formula, so results will be returned without throttling.


=== FUNCTION PARAMETERS ===
See the documentation for the complete list of function parameters, as well as examples:
https://docs.anthropic.com/claude/docs/using-claude-for-sheets


=== OTHER CONSIDERATIONS ===
⚠ Please exercise caution as you interact with Claude and double-check the output. 
⚠ Claude may occasionally generate incorrect or misleading information, or produce offensive or biased content.
⚠ Claude is not intended to give professional advice, including legal, financial, and medical advice. Do not rely on Claude without doing your own independent research. 
⚠ Please don’t share sensitive or personal information in your conversations with Claude.
Your use of the Claude for Sheets™ add-on is governed by your existing agreement with Anthropic and it should be considered a preliminary build. If you have questions about this, please contact your sales lead.