GPT for Work (GPT for Sheets, Docs, Excel, Word)
GPT for Work (GPT for Sheets, Docs, Excel, Word)
  • Видео 42
  • Просмотров 1 030 189
GPT for Excel functions speedrun!
Get a quick but comprehensive overview of how you can use GPT for Excel functions to power through your repetitive tasks in feedback analysis, e-commerce, market research, data cleaning.
⌚️ TIMESTAMPS
0:00 Intro
0:11 Analyze Customer Reviews
0:50 Improve Your Product Catalog
2:06 Enrich Your CRM
2:46 Clean, Reformate, Sanitize Your Data
👉 TRY the GPT for Excel Word add-on for free: gptforwork.com/install
------------------------------------------------------------------------------------------
Like ChatGPT? Imagine using it in bulk in Google Sheets or Microsoft Excel and Word! 🤠
Make ChatGPT and other AIs write, rephrase, translate, categorize, extract, reformat, summarize, do research… 1000x faste...
Просмотров: 507

Видео

GPT for Sheets functions speedrun, 2024 edition!
Просмотров 4,9 тыс.Месяц назад
Get a quick but comprehensive overview of how you can use GPT for Sheets functions to power through your repetitive tasks in feedback analysis, e-commerce, market research, data cleaning. ⌚️ TIMESTAMPS 0:00 Intro 0:11 Analyze Customer Reviews 0:50 Improve Your Product Catalog 2:06 Enrich Your CRM 2:46 Clean, Reformate, Sanitize Your Data 👉 TRY the GPT for Sheets and Docs add-on for free: gptfor...
How to use ChatGPT into Microsoft Word: a beginner’s guide (101)
Просмотров 148 тыс.8 месяцев назад
Like ChatGPT? Now, use it in Word too! Discover how to use the GPT for Excel Word add-in and unleash the power of OpenAI's artificial intelligence with its latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo directly into Microsoft Word! 👇 Get the GPT for Excel Word add-in: gptforwork.com/install-msft Chat with your Word documents and edit them by inserting chat responses directly inside...
GPT for Excel: a beginner's guide (101)
Просмотров 108 тыс.9 месяцев назад
Like ChatGPT? Now, use it in Excel too! Discover how to use the GPT for Excel Word add-in and unleash the power of OpenAI's artificial intelligence with its latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo directly into Microsoft Excel! 👇 Get the GPT for Excel Word add-in: gptforwork.com/install-msft This add-in enables simple custom functions to help you achieve all sort of tasks suc...
Insert options in GPT for Docs
Просмотров 2,9 тыс.Год назад
In this video, find out what the different insertion options available in GPT for Docs are. Simply decide where your output should be generated in your Google Docs and easily manage all the insert settings directly from the sidebar. There’s more: GPT for Docs has a highlight feature to make your output stand out from the rest of your text. You can also choose whether to insert your prompt in yo...
Use document context with ChatGPT in Google Docs
Просмотров 4,6 тыс.Год назад
Feeding your prompt with the right context is very important to generate specific and accurate content with ChatGPT. In this video, we explain to you how to use the GPT for Docs sidebar to use your document or portions of your documents as context to generate more writing with ChatGPT in Google Docs. ⌚️TIMESTAMPS 00:00 Use the whole document as context 1:16 Use a selection as context to expand ...
Comparing Google Translate and ChatGPT for Hindi to English
Просмотров 16 тыс.Год назад
In this video, we compare Google Translate and ChatGPT through a compelling example of an English/Hindi translation. Unlike Google Translate, with ChatGPT you can customize your prompts and provide some context to get more accurate results. Make sure your translations are consistently spot-on by using ChatGPT and GPT for Sheets and Docs 😉 ⌚️TIMESTAMPS 00:00 Introduction 00:27 Translate indian n...
Split your text with GPT for Sheets
Просмотров 5 тыс.Год назад
Our new function GPT_SPLIT enables you to semantically split text and get one item per cell. Use GPT_SPLIT to return outputs listed vertically and GPT_HSPLIT if you prefer to get the outputs listed horizontally. You can split your text into: - sections - paragraphs - sentences - punctuations and even letters! ⌚️TIMESTAMPS 00:00 Vertically split your text into paragraphs 01:39 Horizontally split...
Translate text with a custom dictionary and GPT_TRANSLATE
Просмотров 3 тыс.Год назад
Do you need to translate text but want to avoid literal translations for specific terms or words? Introducing the refined GPT_TRANSLATE function, which allows you to effortlessly translate text using your own customized dictionary. This is super useful when translating: - generic words into very specific terms (such as brand names) - common source-language abbreviations or terms that have no st...
How to use ChatGPT into Google Docs: a beginner's guide (101)
Просмотров 19 тыс.Год назад
Like ChatGPT? Use it in Google Docs! The possibilities of ChatGPT are almost endless. Discover how to use the GPT for Docs add-on and unleash the power of OpenAI GPT-3 and GPT-4 artificial intelligence directly into Google Docs - no need to mess with apps script! 👇 Get the GPT for Sheets and Docs add-on: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654 Our custom sideba...
Create an interactive FAQ with GPT for Sheets
Просмотров 3,4 тыс.Год назад
Create your own interactive FAQ in Google Sheets! In this video, we explain step-by-step how to build an interactive FAQ with GPT for Sheets. Now, you can ask your questions directly in your spreadsheet and let ChatGPT answer them! Function in this video Syntax =GPT_MAP(search_keys, range, [confidence], [stats], [top_k]) ⌚️ TIMESTAMPS 00:00 See how it works (example) 01:21 Step 1: Identify rel...
Bulk write and send unique emails with ChatGPT and YAMM
Просмотров 7 тыс.Год назад
Discover how to write and send unique personalized emails in bulk thanks to GPT for Sheets and YAMM. ⌚️TIMESTAMPS 00:00 Draft your first email body 02:28 Get different emails for each recipient 04:50 Write email subject lines 06:14 Create a Gmail email draft 7:46 Run YAMM and send your emails 09:00 Track your emails status ▶️ PLAYLIST: Discover all the functionalities of the GPT for Sheets and ...
Autofill your ranges based on examples with ChatGPT in Sheets!
Просмотров 12 тыс.Год назад
Autofill your ranges based on examples with ChatGPT in Sheets!
How to control the execution of your GPT for Sheets functions
Просмотров 6 тыс.Год назад
How to control the execution of your GPT for Sheets functions
Clean your Google Sheets with ChatGPT
Просмотров 9 тыс.Год назад
Clean your Google Sheets with ChatGPT
Format your data in Sheets automagically with ChatGPT
Просмотров 8 тыс.Год назад
Format your data in Sheets automagically with ChatGPT
Create lists of data in Sheets with ChatGPT
Просмотров 17 тыс.Год назад
Create lists of data in Sheets with ChatGPT
How to map two columns of values in Google Sheets with ChatGPT
Просмотров 32 тыс.Год назад
How to map two columns of values in Google Sheets with ChatGPT
Polish your content with ChatGPT in Google Sheets
Просмотров 8 тыс.Год назад
Polish your content with ChatGPT in Google Sheets
Classify data in Google Sheets with ChatGPT
Просмотров 25 тыс.Год назад
Classify data in Google Sheets with ChatGPT
How to summarize text with ChatGPT in Google Sheets
Просмотров 13 тыс.Год назад
How to summarize text with ChatGPT in Google Sheets
Speedrun of GPT for Sheets 2023
Просмотров 117 тыс.Год назад
Speedrun of GPT for Sheets 2023
Make ChatGPT translate content in Google Sheets GPT_TRANSLATE
Просмотров 22 тыс.Год назад
Make ChatGPT translate content in Google Sheets GPT_TRANSLATE
Make ChatGPT extract entities from Google Sheets data with GPT_EXTRACT
Просмотров 15 тыс.Год назад
Make ChatGPT extract entities from Google Sheets data with GPT_EXTRACT
Make ChatGPT tag your data in Google Sheets with GPT_TAG
Просмотров 12 тыс.Год назад
Make ChatGPT tag your data in Google Sheets with GPT_TAG
How to easily call ChatGPT in Google Sheets
Просмотров 30 тыс.Год назад
How to easily call ChatGPT in Google Sheets
Generate tables of data in Google Sheets with ChatGPT
Просмотров 23 тыс.Год назад
Generate tables of data in Google Sheets with ChatGPT
ChatGPT in Sheets: how to use OpenAI temperature parameter
Просмотров 7 тыс.Год назад
ChatGPT in Sheets: how to use OpenAI temperature parameter
ChatGPT in Sheets: what are OpenAI tokens and how to use the max_tokens parameter
Просмотров 13 тыс.Год назад
ChatGPT in Sheets: what are OpenAI tokens and how to use the max_tokens parameter
Set up your OpenAI API key in GPT for Sheets and Docs
Просмотров 90 тыс.Год назад
Set up your OpenAI API key in GPT for Sheets and Docs

Комментарии

  • @jetakota
    @jetakota 10 часов назад

    thank you sir

  • @mohamedkarim-p7j
    @mohamedkarim-p7j День назад

    Thank for sharing👍

  • @RaghavMittal-v4m
    @RaghavMittal-v4m 2 дня назад

    Hey, whether GPT_FILL is not working these days? As I tried, it is showing unknown function.

  • @squbes
    @squbes 4 дня назад

    For languages which can be rendered in more than one script is there a way to change the script? For example Oromo can be rendered with latin or ethiopic characters. I tried using "Oromo Ethiopic" but it mostly renders in latin. One result came back in Ethiopic script but google translate thinks this is Amharic

    • @gptforwork
      @gptforwork 3 дня назад

      did you try adding specific instructions for that?

  • @frenchtranslator
    @frenchtranslator 5 дней назад

    ChatGPT is useful for summarizing texts, but when it comes to translations, the results are incredibly poor. The translation attempt in the video is a prime example of how bad it gets.

    • @gptforwork
      @gptforwork 5 дней назад

      can you detail why? I'll then improve the example.

    • @frenchtranslator
      @frenchtranslator 5 дней назад

      @gptforwork Well, it's a literal translation that makes no sense really in French. It should be rephrased to be comprehensible. (But it would be too long to explain why here). I therefore recommend using another example. Maybe that would work better.

  • @ra4872
    @ra4872 5 дней назад

    No need to write long formulas anymore hah?))

  • @elliotmedia
    @elliotmedia 8 дней назад

    I want to be that cool

  • @JimWellsIsGreat
    @JimWellsIsGreat 8 дней назад

    Excellent!

  • @lucianooliveira-lf5rt
    @lucianooliveira-lf5rt 8 дней назад

    teto remuneratório inaplicável aos aposentados em junho de 1997

    • @gptforwork
      @gptforwork 8 дней назад

      not sure what you're asking :)

  • @АлександрТырышкин-з6е

    It is useless and it does nothing 😢

    • @gptforwork
      @gptforwork 10 дней назад

      huh? please contact support, we'll be happy to help you!

  • @TanbirKhan-l1e
    @TanbirKhan-l1e 15 дней назад

    Moslim

  • @Femilorales
    @Femilorales 16 дней назад

    If I use this to polish my essay, will I be confirmed as plagiarism or use AI to cheat?

    • @gptforwork
      @gptforwork 14 дней назад

      it depends how you use it

  • @ryandahltv
    @ryandahltv 17 дней назад

    I get a message saying All free trial requests have been used up. To access the Premium features ...

    • @gptforwork
      @gptforwork 14 дней назад

      yes, once the free trial is over, you need to buy a pack to continue using it

  • @UnapologeticallyAFChristinaRae
    @UnapologeticallyAFChristinaRae 19 дней назад

    Loving this! I feel like I am a bit late to the game but I am definitely learning, TY!

  • @minprivataseriosakanal
    @minprivataseriosakanal 25 дней назад

    Will using openAI api keys save me from having to buy other premiums with using GPT for Sheets?

    • @gptforwork
      @gptforwork 18 дней назад

      Hello, the product is paid even with your own keys, but consumption is less expensive with.

  • @sukit6282
    @sukit6282 28 дней назад

    It's very clear.,In addition,What is this screen recording made of?,It's very clear.

  • @sylvievanasse301
    @sylvievanasse301 Месяц назад

    Bonjour , est-ce que cette app peut également améliorer un texte dans la langue française. Merci pour votre aide

  • @MathiasSimon-x4f
    @MathiasSimon-x4f Месяц назад

    How can I use it to translate numbers to words?

  • @Fiend404
    @Fiend404 Месяц назад

    epic

  • @chrisder1814
    @chrisder1814 Месяц назад

    hello

  • @chrisder1814
    @chrisder1814 Месяц назад

    hello about RAG?

    • @gptforwork
      @gptforwork Месяц назад

      hello, you can use openai assistants for RAG

    • @chrisder1814
      @chrisder1814 Месяц назад

      @@gptforwork It's a kind of database To make it more relevant in its answers

  • @jonathan-6948
    @jonathan-6948 Месяц назад

    From what I have seem about copilot GPT WORD EXCEL is much better (at least for now, surely they will one day implement all these features). But can you also rewrite a specific provcedure? I have template procedures and need to adapt them to the customer. Can I just give in the customer case and the AI rewrites the whole document and does not change the formatting?

    • @gptforwork
      @gptforwork Месяц назад

      hello, could you please write with details to support? support.gptforwork.com/hc/en-us/requests/new

  • @Roman-ux2ry
    @Roman-ux2ry Месяц назад

    How much cost?

    • @gptforwork
      @gptforwork Месяц назад

      please check our pricing here: gptforwork.com/help/billing/pricing-options

  • @GregSchaf
    @GregSchaf Месяц назад

    cool

  • @sarahmansur8184
    @sarahmansur8184 Месяц назад

    ohh yyyess

  • @duncanlawrence5493
    @duncanlawrence5493 Месяц назад

    I am getting wierd behaviour with Word Now not responding when I try to copy the content from the GPT For Word Window into a Note. Going to Reboot Machine now as Can't work out whats happening apart from the new Add-in here ? Any advice >?

    • @gptforwork
      @gptforwork Месяц назад

      sorry about this, please reach out to support

  • @Tomaselgamad
    @Tomaselgamad 2 месяца назад

    thank you very much

  • @BarisKiratOG369
    @BarisKiratOG369 2 месяца назад

    Hey, I've been trying to isntall the extension. Installed it and all, but can't see it in my extensions in sheets. What to do? I'm the owner of the sheets too.

    • @gptforwork
      @gptforwork 2 месяца назад

      Google Sheets has been having issues with all add-ons in the past few days (we've seen this issue pop up on various add-ons. Unfortunately there is nothing else to do but wait until they fix it / the issue disappears for you.

    • @BarisKiratOG369
      @BarisKiratOG369 2 месяца назад

      @@gptforwork thanks for letting me know

  • @joezink881
    @joezink881 2 месяца назад

    I'm still confused about the payment models. it seems like a vary convoluted approach. If I have spreadsheet with 30 cells preforming AI enhanced formulas Do they drain the tokens over time when they are used? or for example if you have an integrated web query that retrieves live data does it consume tokens?

    • @gptforwork
      @gptforwork 2 месяца назад

      hello, apologies for the complexity, it is indeed convoluted, and will be simplified soon. In the mean time, everything is explained here: gptforwork.com/help/billing/pricing-per-model

  • @lukethomas5796
    @lukethomas5796 2 месяца назад

    I purchased beginner subscription because of this video. :)

    • @gptforwork
      @gptforwork 2 месяца назад

      Hope you enjoy it!

  • @aviuttam9121
    @aviuttam9121 2 месяца назад

    Does it have a function to analyze a bunch of data and then return from it what we ask from it.. things such as the lowest, the highest, the average? Or can it compare 2 sets of data to identify the differences?

    • @gptforwork
      @gptforwork 2 месяца назад

      not at the moment no. it is made for bulk processing of text

  • @Fiend404
    @Fiend404 2 месяца назад

    I wish the GPT_FILL function allowed adding a prompt for context

    • @gptforwork
      @gptforwork 2 месяца назад

      you actually can via custom instructions, and it's indeed recommended

    • @Fiend404
      @Fiend404 2 месяца назад

      @@gptforwork thanks! didn't know that

  • @saisai-jv4oe
    @saisai-jv4oe 2 месяца назад

    its very usefull easy way to undestand it

  • @LeoDiBlack
    @LeoDiBlack 3 месяца назад

    This tool is definitely AMAZING!

  • @johnwellington269
    @johnwellington269 3 месяца назад

    hi, if i generate chatgot output with like 6 columns data, is it possible to match it with individual cell?

    • @gptforwork
      @gptforwork 2 месяца назад

      yes, it should be.

    • @johnwellington269
      @johnwellington269 2 месяца назад

      @@gptforwork it just genereated into one cell

  • @bobbisimpsons8779
    @bobbisimpsons8779 3 месяца назад

    What is a token equal to so I may better understand the unit and ultimate cost.

    • @gptforwork
      @gptforwork 2 месяца назад

      see the following resources: - my guide on tokens: gptforwork.com/guides/openai-gpt3-tokens - our free tokenizer: gptforwork.com/tools/tokenizer - our cost estimator: gptforwork.com/help/billing/cost-estimator

  • @FarhanAtif-jd1pz
    @FarhanAtif-jd1pz 3 месяца назад

    very helpful tool

  • @fahadhussain9824
    @fahadhussain9824 3 месяца назад

    hey stan i have an issue i used gpt fill but the function didnot fill the other remaining rows it only fills one row i tried several ways use dragging the way down but it gives error whats the problem plz guide me thankyu

    • @gptforwork
      @gptforwork 2 месяца назад

      hello, please contact support, we will help you

  • @ninastales
    @ninastales 3 месяца назад

    wow...this is amazing.

  • @oscarguinane2184
    @oscarguinane2184 3 месяца назад

    Wow

  • @retrorecordings
    @retrorecordings 3 месяца назад

    so you need a pay openai account for using this?

    • @gptforwork
      @gptforwork 3 месяца назад

      not any more. it was needed at the launch of the product and through 2023

    • @retrorecordings
      @retrorecordings 3 месяца назад

      @@gptforwork Thanks a Lot!!!

  • @AshokKumar-dk2xp
    @AshokKumar-dk2xp 3 месяца назад

    🎉🎉🎉🎉🎉❤❤❤❤😂

  • @RodrigoCamarena-p7o
    @RodrigoCamarena-p7o 3 месяца назад

    How can you personalize the email with the name of the person?

    • @gptforwork
      @gptforwork 3 месяца назад

      you can include the name in the prompt with a reference to the cell or column

    • @RodrigoCamarena-p7o
      @RodrigoCamarena-p7o 3 месяца назад

      @@gptforwork Thank you Stan, very useful. One last question, can GPT for Work can browse the internet?

    • @gptforwork
      @gptforwork 3 месяца назад

      Yes, in Sheets / Excel, via GPT_WEB or the "Search the web" Bulk tool, which use the perplexity.ai API under the hood

  • @prashantrajaji9550
    @prashantrajaji9550 3 месяца назад

    is there a limit to the amount of times i can use this with ms word

    • @gptforwork
      @gptforwork 3 месяца назад

      you're only limited by what you pay for.

  • @小漠-i4r
    @小漠-i4r 3 месяца назад

    非常感谢您的分享,您把您的智慧充分发挥出来,充分帮助到了那些需要的人,我作为一个英文不好的中国人,无法顺畅的使用这个工具,感觉错过了一个宝藏。还是感谢您的分享。

    • @gptforwork
      @gptforwork 3 месяца назад

      thank you for your feedback! we will try to make it easier for Chinese speakers to use our product in 2025 (translating the UI and our video tutorials)

  • @LuizPedrodaSilva-f4h
    @LuizPedrodaSilva-f4h 4 месяца назад

    ok

  • @AnielJaquez-g6f
    @AnielJaquez-g6f 4 месяца назад

    And height