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년 4월 25일
독립적인 보안 인증
호환 기기:
627만+
개요
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 and GPT-4 Vision, Anthropic Claude 3, Perplexity sonar-small-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 gpt-3.5-turbo.
In Docs, the default model for all functions is gpt-4-turbo.
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 or Anthropic
추가정보
가격유료 기능을 포함한 무료
개발자
개인정보처리방침
GPT for Sheets™ and Docs™에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
GPT for Sheets™ and Docs™에서 Google 계정에 액세스해야 함
이렇게 하면 GPT for Sheets™ and Docs™에서 다음 작업을 할 수 있습니다.
애플리케이션 설치 시 사용한 문서 조회 및 관리
애플리케이션 설치 시 사용한 스프레드시트 조회 및 관리
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
외부 서비스에 연결
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
Loading
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴