Introducing the GPT for Sheets sidebar!
HTML-код
- Опубликовано: 6 июн 2024
- We just released the GPT for Sheets sidebar! A brand-new interface that will help you be even more efficient when using ChatGPT in Google Sheets. In this video, we show you the latest features we developed including:
a list of all our functions to easily spot which GPT function best suits your needs
a Google Sheets assistant for you to quickly understand and generate Google Sheets formulas
a centralized interface to adjust OpenAI hyperparameters in a simpler way
And much more!
⌚️ TIMESTAMPS
00:00 Introduction
00:24 OpenAI servers status
2:28 Configure model, temperature and max_tokens from the sidebar
4:29 List of all GPT functions
7:00 Replace formulas and save your results
10:37 Manage cache
14:14 Create Google Sheets formulas
15:48 Explain a Google Sheets formula
▶️ PLAYLIST:
Discover all the functionalities of the GPT for Sheets and Docs add-on: • All about GPT for Sheets
📥 List of all available functions: gptforwork.com/help/gpt-for-s...
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback , we'll be happy to answer: support.gptforwork.com/hc/en-...
------------------------------------------------------------------------------------------
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!
GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!
👉 Install for Microsoft: gptforwork.com/install-msft
👉 Install for Google: gptforwork.com/install-google
Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.
💡 More resources and examples on our website: gptforwork.com/
🔔 Don't miss any new feature by subscribing to our channel: / @gpt4work
------------------------------------------------------------------------------------------
This channel is brought to you by TALARIAN: talarian.io/
Check out our other productivity tools for Google Workspace:
🚀 YAMM : yamm.com/
🔥 AWESOME TABLE : awesome-table.com/
🤖 FORM PUBLISHER : form-publisher.com/ - Наука
I haven’t even finished watching the video yet but I’m already blown away!! Nice work Stan!! 👏👏👏
Wow, thanks!
Thank you! You are a lifesaver for me and my work!
You're welcome 😊
Amazing work. Keeps getting better. 👏👏👏
Thank you 🙌
Your tool is incredible useful. Please keep developing.
That's the plan!
This is a great addition, well done.
thank you!
Great work. Thanks!
Glad you liked it!
This is awesome! Thanks!
Glad you like it!
Hi, I’ve been loving your app, if I can add a suggestion it would be great to have a chat box in the side bar. I have found that when doing complicated formulas or need to add functions I am still going back and forth btwn sheets and gpt. Sometimes I need to iterate the formula given to me and can’t quite get it right just through the formula goal box. Thank you for this amazing tool!
yes, we have that in mind, it will be a great addition. stay tuned!
This is a great tool! Hope this continues. Will this be monetised at any point of time?
Thank you. Yes it will be monetized soon so that we can continue to invest in making it better.
Great improvement, well done!
Any chance you can put the syntax for each formula in with the examples? Saves a click to documentation :)
the problem is there is not much space in the sidebar. but you can get the syntax in the inline doc of the spreadsheet itself, which is even better.
@@gptforwork That inline doc never shows for me now that I think about it.
@@AlexSMontgomery really? can you send a screenshot? do you see the little blue "?"
I had an idea to reduce or eliminate the need for the user to manage the cache: what if you just cached invocations where the temperature is 0? At least doing that by default should be a free savings. Then in more rare cases, the user could choose to go one step further and enable the cache for all temperatures, if that’s even a use case you’d still want to support.
yeah we had this idea too, but thought it would be really complicated to explain.
@@gptforwork Yeah, so then just removing the setting would remove the need to explain anything, except to those curious about this optimization.
I'd be interested to know the stats on how much usage occurs with the cache enabled vs. with 0 temperature. If the latter is greater, it'd be a net benefit.
Of course, those paying attention to caching would also likely change to 0 temperature calls if you implemented this change.
In any case, I suspect most users do not even look at the caching setting, which is part of the reason I believe in this idea of the tool being smart enough to just cache the 0-temp calls that the user already expects to be constant.
Hey there! This is great 👍 I built a tool using your app for my audience but didn't see that docs is now a part of the app. Do you have videos on how that works? I'd love for my audience to be able to copy the contents to a doc easily but if I can build the same thing within a doc, even better.
Hello, the first video about the Google Docs integration gets published today!
I'd love to see your tool, can you send it to me?
Absolutely! If you send me your email, I'll give you access
@@BloggingwithSashaLassey stan@talarian.io
@@gptforwork Sent it your way! :)
hey guys don't blame the AI for hiccup at the end. The human included cell H15 which is empty.
Hey, can your sheets plugin access browser data, to generate also up to date stuff? Thanks
not yet
7:19 I wouldn't remove everything from the menu that's in the sidebar, ‘cause it can be a useful shortcut when working without the sidebar.
what would you like to keep?
@@gptforwork well, TBH, I'd keep everything but Setup guide and Manage cache
Hi Stan I run into little issue with the new update. It keeps saying that my API key is expired but I tried using my account on playground and it does work. I have generated several keys but it still runs the same issue. Please help, I never had these issues before the new update.
Ps. My other sheet is working fine while using the same API key. Why is that?
Hello, this sounds strange indeed. We have reached out over email.
Hi - can we get access to the ChatGPT4 browsing model ? Or is that not available yet?
hi, it's not available yet.
Is there Any token limits for inputs or outputs
yes, all models have their own limits. See more details here: gptforwork.com/tools/model-comparator
Give Stan a cookie
Will this extension always be free or only while in beta??
the free plan will stay free if and only if OpenAI makes it possible and it doesn't cause too much trouble. We have lots of people creating new accounts and new keys that are not working.
@@gptforwork Thank you so much Stan
How do I enable GPT with this new update? I always get ?NAME
Hello, just launch the sidebar.
Just FYI, it's not working right now.
Hello! We're sorry to hear that and hope your problem has been fixed. If not, please contact us: support.gptforwork.com/hc/en-us/requests/new