- Видео 42
- Просмотров 1 030 189
GPT for Work (GPT for Sheets, Docs, Excel, Word)
США
Добавлен 21 май 2021
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 faster than you could.
Popular use-cases for Excel and Sheets:
🌍 Translate in bulk
✍️ Create SEO content or ads copy at scale
🗂️ Clean and categorize your PIM or CRM
📊 Analyze survey results or customer feedback
📋 Review / Score a list of leads or candidates
🔍 Automate market research
Why use GPT for Work?
🚫 Stop copy/pasting to and from ChatGPT
⚡ Run up to 1000 prompts per minute
🎛️ Large model choice: GPT-4o, Claude 3.5 Sonnet, Gemini...
🔑 No API key required
Privacy and security:
🔒 Talarian is ISO 27001 certified and GDPR compliant
🛡️ We do not use your content to train models
🔐 Bring your own API key for enhanced privacy
Learn more:
🌐 Website: gptforwork.com
🚀 Get started: gptforwork.com/help/quickstart-for-spreadsheets
🛟 Help: gptforwork.com/help
Make ChatGPT and other AIs write, rephrase, translate, categorize, extract, reformat, summarize, do research… 1000x faster than you could.
Popular use-cases for Excel and Sheets:
🌍 Translate in bulk
✍️ Create SEO content or ads copy at scale
🗂️ Clean and categorize your PIM or CRM
📊 Analyze survey results or customer feedback
📋 Review / Score a list of leads or candidates
🔍 Automate market research
Why use GPT for Work?
🚫 Stop copy/pasting to and from ChatGPT
⚡ Run up to 1000 prompts per minute
🎛️ Large model choice: GPT-4o, Claude 3.5 Sonnet, Gemini...
🔑 No API key required
Privacy and security:
🔒 Talarian is ISO 27001 certified and GDPR compliant
🛡️ We do not use your content to train models
🔐 Bring your own API key for enhanced privacy
Learn more:
🌐 Website: gptforwork.com
🚀 Get started: gptforwork.com/help/quickstart-for-spreadsheets
🛟 Help: gptforwork.com/help
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...
⌚️ 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
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
thank you sir
Thank for sharing👍
Hey, whether GPT_FILL is not working these days? As I tried, it is showing unknown function.
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
did you try adding specific instructions for that?
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.
can you detail why? I'll then improve the example.
@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.
No need to write long formulas anymore hah?))
I want to be that cool
Excellent!
teto remuneratório inaplicável aos aposentados em junho de 1997
not sure what you're asking :)
It is useless and it does nothing 😢
huh? please contact support, we'll be happy to help you!
Moslim
sure
If I use this to polish my essay, will I be confirmed as plagiarism or use AI to cheat?
it depends how you use it
I get a message saying All free trial requests have been used up. To access the Premium features ...
yes, once the free trial is over, you need to buy a pack to continue using it
Loving this! I feel like I am a bit late to the game but I am definitely learning, TY!
Will using openAI api keys save me from having to buy other premiums with using GPT for Sheets?
Hello, the product is paid even with your own keys, but consumption is less expensive with.
It's very clear.,In addition,What is this screen recording made of?,It's very clear.
Bonjour , est-ce que cette app peut également améliorer un texte dans la langue française. Merci pour votre aide
bonjour, oui.
How can I use it to translate numbers to words?
hello, yes
epic
hello
hello about RAG?
hello, you can use openai assistants for RAG
@@gptforwork It's a kind of database To make it more relevant in its answers
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?
hello, could you please write with details to support? support.gptforwork.com/hc/en-us/requests/new
How much cost?
please check our pricing here: gptforwork.com/help/billing/pricing-options
cool
ohh yyyess
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 >?
sorry about this, please reach out to support
thank you very much
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.
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.
@@gptforwork thanks for letting me know
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?
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
I purchased beginner subscription because of this video. :)
Hope you enjoy it!
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?
not at the moment no. it is made for bulk processing of text
I wish the GPT_FILL function allowed adding a prompt for context
you actually can via custom instructions, and it's indeed recommended
@@gptforwork thanks! didn't know that
its very usefull easy way to undestand it
This tool is definitely AMAZING!
hi, if i generate chatgot output with like 6 columns data, is it possible to match it with individual cell?
yes, it should be.
@@gptforwork it just genereated into one cell
What is a token equal to so I may better understand the unit and ultimate cost.
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
very helpful tool
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
hello, please contact support, we will help you
wow...this is amazing.
Wow
so you need a pay openai account for using this?
not any more. it was needed at the launch of the product and through 2023
@@gptforwork Thanks a Lot!!!
🎉🎉🎉🎉🎉❤❤❤❤😂
How can you personalize the email with the name of the person?
you can include the name in the prompt with a reference to the cell or column
@@gptforwork Thank you Stan, very useful. One last question, can GPT for Work can browse the internet?
Yes, in Sheets / Excel, via GPT_WEB or the "Search the web" Bulk tool, which use the perplexity.ai API under the hood
is there a limit to the amount of times i can use this with ms word
you're only limited by what you pay for.
非常感谢您的分享,您把您的智慧充分发挥出来,充分帮助到了那些需要的人,我作为一个英文不好的中国人,无法顺畅的使用这个工具,感觉错过了一个宝藏。还是感谢您的分享。
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)
ok
nice
And height
okay