Claude for Google Sheets
Now you can name Claude in Google Sheets with the Claude for Sheets extension. Claude for Sheets permits seamless integration between Claude and Google Sheets, permitting you to execute interactions with Claude immediately in cells.
Simply allow Claude for Sheets utilizing the next steps:
-
Get your Claude API key – You will be unable to make use of Claude for Sheets with no developer API key. For extra data on the best way to purchase an API key, see Getting access to Claude.
-
Set up the Claude for Sheets extension
- Click here to entry the Claude for Sheets extension
- Click on “Set up”
-
Allow Claude for Sheets
- Open a recent workbook
- Go to Extensions > Add-ons > Handle add-ons
- Click on on the triple dot menu on the prime proper nook of the Claude for Sheets extension and ensure “Use on this doc” is checked
You’ll have to allow Claude for Sheets each time you make a brand new workbook
-
Join your API key Enter your API key at Extensions > Claude for Sheets™ > Enter your Anthropic API Key. You might want to attend or refresh for “Enter your Anthropic API key” to look as an possibility.
After you see the inexperienced ‘verified’ checkmark ✅ seem, Claude shall be activated and prepared inside your Google Sheet.
Throughout set up, the Claude for Sheets extension will ask for quite a lot of permissions wanted to operate correctly. Though the permissions requested to run Claude in Sheets are broad, please be assured that we solely course of the particular items of knowledge that customers ask Claude to run on. This information isn’t used to coach our generative fashions.
Extension permissions embody:
- Connect with an exterior service – wanted so as to make calls to the Anthropic API
- Permit this utility to run when you’re not current – wanted to run cell recalculations with out consumer intervention
- See, edit, create, and delete all of your Google Sheets spreadsheets – wanted to carry out batch cell updates when recalculating
#ERROR!cells which have timed out or have been deferred as a consequence of API concurrency limits; this service can not work with permissions given just for the present sheet
Cell Recalculation
Notice that you should nonetheless manually recalculate cells by choosing from the recalculate choices throughout the Claude for Sheets extension menu.
There are two foremost capabilities you should use to name Claude utilizing Claude for Sheets:
-
=CLAUDE(immediate)– this operate will routinely wrap your immediate within the correct formatting ofnnHuman: ${your_prompt}nnAssistant:for you. To make use of this operate, all you want is a plaintext immediate with no extra formatting. That is the operate you will most likely need to use more often than not. That is equivalent to the Slackbot Claude interface and “Chat” mode on the console.In a single sentence, what is nice concerning the coloration blue? -
=CLAUDEFREE(immediate, mannequin, params...)– to make use of this operate, you’ll have to manually sandwich your immediate betweennnHuman:andnnAssistant:. Changennwith two precise new traces when writing your immediate in a cell.That is equivalent to the uncooked API Claude interface and “Edit Chat” mode on the console. For extra data on the particular “Human:”/”Assistant:” formatting in CLAUDEFREE, see Introduction to Prompt Design.
- To make new traces in a cell, do the next:
Mac: Cmd + Enter
Home windows: Alt + Enter
Human: In a single sentence, what is nice concerning the coloration blue? Assistant: - To make new traces in a cell, do the next:
If you wish to specify API parameters, you are able to do so by itemizing “parameter identify” (in citation marks), “parameter worth” on the finish of the decision. For instance, if you wish to set the max_tokens to three, you are able to do it as follows: =CLAUDE("[your prompt]", "claude-instant-1.2", "max_tokens_to_sample", 3).
You’ll be able to set a number of parameters. Merely listing them one after one other, every with a reputation and worth pair separated by commas.
For instance, that is legitimate CLAUDE operate: =CLAUDE("[your prompt]", "claude-instant-1.2", "max_tokens_to_sample", 3, "temperature", 0.5)
The parameters you would possibly care about most are:
max_tokens_to_sample– the whole variety of tokens the mannequin outputs earlier than it’s pressured to cease. For sure/no or a number of alternative solutions, you most likely need 1-2. In any other case you will need as many as 200 if you need a protracted reply.temperature– the quantity of randomness injected into outcomes. For multiple-choice or analytical duties, you will need it near 0. For thought era, you will need it set to 1.
Immediate Engineering Tutorial
Go to our in-depth interactive prompt engineering tutorial using the Claude for Sheets add-on to be taught or brush up on newbie to superior immediate engineering methods.
Tutorial Entry Notice
Notice that simply as with the remainder of Claude for Sheets, you will have an API key to work together with the tutorial.
If you do not have an API key, see our static prompt engineering tutorial answer key as a substitute.
For additional data, instance prompts, and instance Claude-powered workbooks, go to our Claude for Sheets prompting examples workbench, the place you’ll find examples for duties similar to the next:
- Longform doc Q&A
- Info extraction
- Eradicating PII
- Buyer help chatbot utilizing FAQ
- Educational tutor
- Immediate chaining
- Operate calling
- And rather more!
Make a duplicate of our Claude for Sheets workbook template to get began with your personal Claude for Sheets work!