Claude for Sheets™ brings your friendly AI assistant Claude from Anthropic right there in your spreadsheets.
Listing updated:September 6, 2024
Works with:
120K+
Overview
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.
Additional information
PricingFree of charge
Developer
Non-trader
Privacy policy
Terms of service
Claude for Sheets™ will ask for the permissions shown below. Learn more
Claude for Sheets™ will need access to your Google account
This will allow Claude for Sheets™ to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
James Sharp
July 23, 2024
For technology so mind-bendingly genius, it's a glacially unthrilling minefield of frustrations. My (amateurish) steps to avoid insanity and financial ruin if you have to run a prompt over lots of cells using this extension (and also don't need the content to update dynamically after being generated): 1) copy and paste into a few cells at a time (about 20) and wait for half of them to finish before pasting more. If you don't mind using different models on different cells, I found using two different models in alternate rows will help to avoid API limit errors. (If there's a way to automate the pasting-and-waiting process, I'd love to know.) 2) after every 300 - 500 cells, do 'copy' and 'paste-values' on the content you've generated so far to preserve it. (This was trial and error based on a prompt token size of about 500 -- if yours is bigger, maybe do it more often.) 3) every time you do (2), also clear out the cache (Extensions -> Claude for Sheets -> Advanced) and also the execution queue for good measure. This prevents the 'you have exceeded the property storage limit' error. If you don't do (2) and (3) you will eventually find errors start wiping your earlier content. The cells also wipe and refresh if the sheet is opened a few days of inactivity (I'm still in therapy), so you really do need to 'preserve' the output by pasting values if it's a large amount of data. (I'm sure there's a clever way to stop this happening, but I couldn't find it.) I managed to get through 25,000 cells with the above method but I slightly wish I'd never been born.
Is this review helpful?
Yes
No
Profile Picture
Corey Benoit
April 12, 2024
It's good, simple, and easy to use and set up. However I wish it had better monitoring of the defferred or ERROR maximum execution times for my prompts. Draging multiple prompts to execute in their own individual cell gets quite buggy when recalculating the DEFERRED, THROTTLE OR ERROR cells with the recalculate feature. It's not even at V1 yet though, so for being at a BETA 0.7 version it's expected. Hopefully it has better que management in the future!
Is this review helpful?
Yes
No
Profile Picture
John Whilleton
July 12, 2024
I never leave reviews so take this with a grain of salt. It is slow beyond belief , you can't work with big projects & its really glitchy! But when it works it's really darn cool.
Is this review helpful?
Yes
No
Profile Picture
Ninja Kevin
April 18, 2024
Cannot test this extension because Anthropic require phone verification. Once verified the website will not allow you to click the "Claim credits" button. Without credits the API key is rejected by Anthropic while inside Sheets. The fact that there are 35K downloads and only 17 reviews currently there is obviously a problem. It would have been better for Anthropic to limit queries to say 100 per day in free mode than this broken credit system.
Is this review helpful?
Yes
No
Profile Picture
George Chrysochou
April 26, 2024
This extension is fine but still lacking compared to GPTforSheets that uses GPT4. Here you can't select the model, you can't set temperature, you can't fix the execution timeout issues with caching, you can't run multiple concurrent connections, the max token limit and context limit is severely reduced etc Anthropic need to pay more attention to this extension. GPT for Sheets has 6 Million downloads, and this one has only 40,000 rightfully. Anthropic, you can do better. Your LLM is better, please do what you have to increase adoption.
Is this review helpful?
Yes
No
Profile Picture
Taj Brar
April 19, 2024
It only allows you to run 3 cells at a time. What a shame. What am i gonna do with that. It will take me half day to fill the sheet. Where as Open ai lets you run 20+ API calls at same time.
Is this review helpful?
Yes
No
Profile Picture
Jalanda M
July 17, 2024
I wanted to try this, but can't get past pressing enter API without errors popping up so can't even try it. Tried ignoring that and using anyway, but gives error saying API needs to be entered. @Anthropic should email Claude accountholders once this extension, or a sheets, docs / office platform exists that negates the need for this extension.
Is this review helpful?
Yes
No
Profile Picture
Eric
January 16, 2024
Claude for Sheets is a godsend. It allows us to work quickly and seamlessly with non-developers and has drastically reduced the time it takes to optimize and tweak prompts.
Is this review helpful?
Yes
No
Profile Picture
Joe Zott
December 15, 2023
Can't configure access. I can get access to Claude for sheets using gmail account and it shows me the dialog for an API key, but my Anthropic access is with a different email account and when i provide an Anthropic API key doesn't seem to give access. It is a good API key as i can use it for application access. The account that has Anthropic access is a Google Workspace account so it has Sheets etc. and while it does seem to provide me a Claude for Sheets it doesn't provide the ability to set the Anthropic API key.
Is this review helpful?
Yes
No
Profile Picture
Martin M
January 3, 2024
Great extension, very useful. Works great as expected of Anthropic. Enter your API_KEY and you're good to go.
Is this review helpful?
Yes
No
1-10 of 15
Search
Clear search
Close search
Google apps
Main menu