Claude for Sheets™ brings the helpful, honest, and harmless AI assistant Claude from Anthropic right to your Google Sheets™.
To set up, Click the "Claude for Sheets™" menu under "Extensions" at the top of your spreadsheet, and "Enter your Anthropic API key". Then you'll get access to two formula functions:
★ =CLAUDE() - Comparable 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.
★ =CLAUDEFREE() - send a free-form prompt to Claude’s API and return the response. This is identical to making a direct API call, 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.
For example, if you put in a cell,
=CLAUDE("When was the US Constitution written?")
The add-on will make an API call to Anthropic and 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
★ ...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 ===


The =CLAUDE... functions take the following optional parameters:  
★ model - default "claude-2". See available models at https://docs.anthropic.com/claude/reference/selecting-a-model  
★ argument - value pairs. For example, to set the "temperature" to 1, call the function as follows:  
  =CLAUDE("Write a poetic tweet about water", "claude-2", "temperature", 1)  


The available argument-value parameters are the following:  
★ "temperature", with values from -1 or 0 to 1  
★ "max_tokens_to_sample", e.g. 20  
★ "stop_sequences", specified as a JSON array of string. Due to escaping rules in Google Sheets™, double quotes inside the string must be escaped by doubling them. See the example below.  
★ "api_key", used to specify a particular API key to call Claude with.  


A complete example using all =CLAUDE... function parameters would look like this:


=CLAUDE(
  "What's the lowest prime number, wrapped in a <number></number> tag?",
  "claude-2",
  "temperature", 0.2,
  "max_tokens_to_sample", 20,
  "stop_sequences", "[""</number>"", ""Human:""]",
  "api_key", "sk-ant-api03-j1W..."
)


=== 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. If you have questions about this, please contact your sales lead.