ChatGPT in Google Sheetsโ„ข and Docsโ„ข. Get the full power of AI for inspiration data cleaning, classification, extraction, translation, edition, summarization, writing directly in your Sheetsโ„ข and Docsโ„ข
๊ฐœ๋ฐœ์ž:
์ •๋ณด ์—…๋ฐ์ดํŠธ:2024๋…„ 6์›” 27์ผ
๋…๋ฆฝ์ ์ธ ๋ณด์•ˆ ์ธ์ฆ
ํ˜ธํ™˜ ๊ธฐ๊ธฐ:
647๋งŒ+
๊ฐœ์š”
GPT for Sheetsโ„ข and Docsโ„ข enables you to use ChatGPT and other generative AI models directly directly in Google Sheetsโ„ข and Docsโ„ข. 
The Sheets add-on is particularly well suited for using ChatGPT at scale, for bulk use-cases such as rewriting, categorizing, clustering.

Available models include OpenAI GPT-3.5, GPT-4 Turbo, GPT-4, GPT-4o and GPT-4 Vision, Anthropic Claude 3, Mistral Large, Perplexity llama3-sonar-online
You can use it for all sorts of tasks on text: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining, etc 
If ChatGPT was GPT for Chat, you can think of GPT for Sheetsโ„ข as SheetGPT.

In Sheets, the default model for all functions is OpenAI gpt-4o.
In Docs, the default model for all functions is OpenAI gpt-4o.
You can select the model you want depending on cost, latency and capability in the sidebars

Website: https://gptforwork.com (learn how to use GPT for work)
Get started: https://gptforwork.com/help/gpt-for-sheets/get-started
Video tutorials: https://www.youtube.com/@gptforwork/playlists

Mentioned by Marc Andreessen as a "killer app": https://twitter.com/pmarca/status/1632855301648183296?s=20

This add-on brings ChatGPT and Claude AI power to Google Sheetsโ„ข by exposing many simple custom functions: 
GPT to get the result of ChatGPT in a single cell
GPT_TRANSLATE to translate your spreadsheet content
GPT_CLASSIFY to classify spreadsheet content into a single category
GPT_EXTRACT to extract entities from your Sheetsโ„ข data
GPT_SUMMARIZE to summarize your spreadsheet content
GPT_FORMAT to sanitize your spreadsheet data into the same format
GPT_EDIT to edit your spreadsheet content
GPT_TAG to apply tags to your spreadsheet content
GPT_MATCH to match values from two columns
GPT_SPLIT to split text semantically, such as by section, paragraph, sentence, customerโ€ฆ
GPT_LIST to get multiple result in a column (one item per cell)
GPT_TABLE to get a table of items from a prompt
GPT_FILL to fill a range from examples
GPT_WEB to fetch data from the web / search the web
GPT_VISION to analyse images

This add-on will help you achieve some tasks such as:
- generating blogposts ideas
- writing whole paragraphs or procedures
- cleaning up lists of names, adresses, emails or companies, dates, currency amounts, phone numbers
- classifying lists of reviews with sentiment analysis or feature categorization
- summarizing reviews
- writing responses to online comments
- trying different versions of a prompt quickly
- working on ad copy (PPC, Google ads, Facebook ads)
- working on SEO metadata (titles, descriptions)
- working on landing page copy
- managing and cleaning product catalogs for e-commerce stores (Shopify and Amazon)
- translations

Docs:
- outlining a piece of content
- expanding a piece of content
- writing emails or blogs
- summarizing notes
- translating content
- changing the style of content

This product is brought to you by talarian.io, maker of YAMM, Form Publisher and Awesome Table, which are some of the most popular add-ons of the Google Workspace Marketplace.

Talarian is not affiliated with OpenAI, Anthropic or Mistral
์ถ”๊ฐ€์ •๋ณด
๊ฐ€๊ฒฉ์œ ๋ฃŒ ๊ธฐ๋Šฅ์„ ํฌํ•จํ•œ ๋ฌด๋ฃŒ
๊ฐœ๋ฐœ์ž
๊ฐœ์ธ์ •๋ณด์ฒ˜๋ฆฌ๋ฐฉ์นจ
GPT for Sheetsโ„ข and Docsโ„ข์—์„œ ์•„๋ž˜์— ํ‘œ์‹œ๋œ ๊ถŒํ•œ์„ ์š”์ฒญํ•ฉ๋‹ˆ๋‹ค. ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
GPT for Sheetsโ„ข and Docsโ„ข์—์„œ Google ๊ณ„์ •์— ์•ก์„ธ์Šคํ•ด์•ผ ํ•จ
์ด๋ ‡๊ฒŒ ํ•˜๋ฉด GPT for Sheetsโ„ข and Docsโ„ข์—์„œ ๋‹ค์Œ ์ž‘์—…์„ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ์„ค์น˜ ์‹œ ์‚ฌ์šฉํ•œ ๋ฌธ์„œ ์กฐํšŒ ๋ฐ ๊ด€๋ฆฌ
์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ์„ค์น˜ ์‹œ ์‚ฌ์šฉํ•œ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ์กฐํšŒ ๋ฐ ๊ด€๋ฆฌ
Google ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๋‚ด ๋ฉ”์‹œ์ง€ ๋ฐ ์‚ฌ์ด๋“œ๋ฐ”์— ์™ธ๋ถ€ ์›น ์ฝ˜ํ…์ธ ๋ฅผ ํ‘œ์‹œํ•˜๊ณ  ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.
์™ธ๋ถ€ ์„œ๋น„์Šค์— ์—ฐ๊ฒฐ
๊ธฐ๋ณธ Google ๊ณ„์ •์˜ ์ด๋ฉ”์ผ ์ฃผ์†Œ ํ™•์ธ
๊ฐœ์ธ์ •๋ณด(๊ณต๊ฐœ๋กœ ์„ค์ •ํ•œ ๊ฐœ์ธ์ •๋ณด ํฌํ•จ) ๋ณด๊ธฐ
๋ฆฌ๋ทฐ
์–ธ์–ด:
์ •๋ ฌ ๊ธฐ์ค€:
Google์—์„œ๋Š” ๋ฆฌ๋ทฐ๋‚˜ ํ‰์ ์„ ํ™•์ธํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๋ฆฌ๋ทฐ์— ๋Œ€ํ•ด ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
Profile Picture
Lee๊ฒฝ์šฐ
2024๋…„ 5์›” 17์ผ
ํŠนํ—ˆ์ž‘์„ฑ์— ๋„์›€์„ ๋ฐ›๊ณ ์ž ์‚ฌ์šฉ์‹œ๋„๋ฅผ ํ•˜์˜€์Šต๋‹ˆ๋‹ค ์Šคํฌ๋ฆฝํŠธ๊ฐ€ ๋งŽ์ด ์–ด๋ ค์›Œ์ ธ ๊ณ„์‚ฐ์ด ๋ณต์žกํ•ด์ง€๊ณ  ์‚ฌ์šฉ๋น„์šฉ์ด ์—„์ฒญ๋‚˜ ํฌ๊ธฐํ•˜๊ณ  ํ™˜๋ถˆ์„ ์š”์ฒญํ–‡๋Š”๋ฐ CS ๊ฐ€ ๊ต‰์žฅํžˆ ๋น ๋ฅด๊ณ  ์นœ์ ˆํ•˜๋ฉฐ ํ™˜๋ถˆ๊นŒ์ง€ ์ •๋ง ์ž˜ํ•ด์ค˜์„œ ๊ฐ๋™์ž…๋‹ˆ๋‹ค.. ํ•œ๋ฒˆ์ฏค ์‚ฌ์šฉํ•ด๋ณด์‹œ๊ธธ I tried using it to get help writing a patent. The script became very difficult, the calculations became complicated, and the cost of use was enormous, so I gave up and asked for a refund. I am impressed that CS is very fast and friendly and even refunds money. Please try using it at least once.
์ด ๋ฆฌ๋ทฐ๊ฐ€ ๋„์›€์ด ๋˜์—ˆ๋‚˜์š”?
์˜ˆ
์•„๋‹ˆ์š”
Profile Picture
zerohouse
2024๋…„ 3์›” 9์ผ
The most attractive and only policy was that it could be used for free using the user's API key. But this policy was blocked, and paid usage is now the default. I am very disappointed and even feel betrayed by the policy of enforcing this inconvenience. There must have been other better business models :(
์ด ๋ฆฌ๋ทฐ๊ฐ€ ๋„์›€์ด ๋˜์—ˆ๋‚˜์š”?
์˜ˆ
์•„๋‹ˆ์š”
Profile Picture
jason lim
2024๋…„ 2์›” 22์ผ
No!!!! Is this not free?
์ด ๋ฆฌ๋ทฐ๊ฐ€ ๋„์›€์ด ๋˜์—ˆ๋‚˜์š”?
์˜ˆ
์•„๋‹ˆ์š”
Profile Picture
Minsun Song
2023๋…„ 3์›” 1์ผ
I'm using it very well. I have a favor to ask. Now that the chatGPT API is public, please integrate it.
์ด ๋ฆฌ๋ทฐ๊ฐ€ ๋„์›€์ด ๋˜์—ˆ๋‚˜์š”?
์˜ˆ
์•„๋‹ˆ์š”
Profile Picture
๊น€์ •ํ™˜
2023๋…„ 5์›” 24์ผ
Good enough!
์ด ๋ฆฌ๋ทฐ๊ฐ€ ๋„์›€์ด ๋˜์—ˆ๋‚˜์š”?
์˜ˆ
์•„๋‹ˆ์š”
Profile Picture
kihoon shin (์‹œ๋‹‰ํ›ˆ)
2023๋…„ 2์›” 9์ผ
Good
์ด ๋ฆฌ๋ทฐ๊ฐ€ ๋„์›€์ด ๋˜์—ˆ๋‚˜์š”?
์˜ˆ
์•„๋‹ˆ์š”
Profile Picture
JB K
2023๋…„ 2์›” 26์ผ
really goooooood :)
์ด ๋ฆฌ๋ทฐ๊ฐ€ ๋„์›€์ด ๋˜์—ˆ๋‚˜์š”?
์˜ˆ
์•„๋‹ˆ์š”
1-7 / 7
๊ฒ€์ƒ‰
๊ฒ€์ƒ‰์–ด ์ง€์šฐ๊ธฐ
๊ฒ€์ƒ‰ ๋‹ซ๊ธฐ
Google ์•ฑ
๊ธฐ๋ณธ ๋ฉ”๋‰ด