ChatGPT in Google Sheets: a beginner's guide (101)
Vložit
- čas přidán 16. 07. 2024
- Like ChatGPT? Use it in Google Sheets! The possibilities of ChatGPT are almost endless. Discover how to use the GPT for Sheets add-on and unleash the power of OpenAI GPT-3 artificial intelligence directly into Google Sheets. - no need to mess with apps script! 👇
Get the GPT for Sheets and Docs add-on: workspace.google.com/marketpl...
This add-on enables a simple custom function =GPT() to help you achieve some tasks such as:
- generating blog posts or subject lines ideas
- writing whole emails or documents
- cleaning up lists of names, addresses, emails or companies
- classifying lists of reviews with sentiment analysis or feature categorization
- summarizing
- writing responses to online comments
- trying different versions of a prompt quickly
and many more !
In addition, this add-on will let you experiment easily with hyperparameters: temperature, model and maxTokens.
⌚️ TIMESTAMPS
00:00 Intro
00:28 The GPT function
04:45 Temperature parameter
07:50 Value parameter
10:15 One item per cell with GPT_LIST
12:34 Clean data with GPT_FILL
16:30 Conclusion
▶️ PLAYLIST:
Discover all the functionalities of the GPT for Sheets and Docs add-on: • All about GPT for Sheets
📥 List of all available functions: support.gptforwork.com/hc/en-...
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback, we'll be happy to answer: forms.gle/QLtQMdhoResxQ2bDA
------------------------------------------------------------------------------------------
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: / @gptforwork
------------------------------------------------------------------------------------------
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/ - Věda a technologie
1. **Prompt**: This is the initial input text you provide to the model. It's essentially a question or a statement that guides the model on what you want it to generate. The model uses this prompt as a starting point and continues the text in a way that's consistent with the prompt's context and style.
2. **Value**: This term is not commonly used as a standalone parameter in the context of GPT settings. It might refer to the specific value of another parameter, or possibly it's being used in a specific application's context. If you meant "values" in the sense of data provided to the model, it would still typically be part of the "prompt".
3. **Temperature**: This controls the randomness of the output generated by the model. A higher temperature results in more random outputs, which can be useful for generating creative or varied text. A lower temperature makes the model's outputs more deterministic and repetitive. A temperature close to 0 makes the model almost always choose the most likely next word, while a higher temperature (closer to 1) encourages diversity in the generated text.
4. **Model**: This refers to the specific version or configuration of the GPT model you are using. Different versions of the model (like GPT-3, GPT-4, etc.) have been trained on different datasets or for different lengths of time, which affects their performance and capabilities. Within a particular version, there might also be different sizes of the model (measured in the number of parameters) that offer a trade-off between computational cost and the ability to generate high-quality text.
5. **Max Tokens**: This parameter specifies the maximum length of the generated text measured in tokens. A token can be a word or part of a word, so the actual length in words can vary. Setting a higher max tokens limit allows the model to generate longer responses, while a lower limit restricts it to shorter texts.
This blew my mind and I think I've spent 3 hours on a Friday night playong around with this! Thanks so much!
Love to hear this, thank you!
Just can't stop learning this. Thank you for your time to teach for people like myself. Now weekend is for study instead hang in the bar..🥰
Hi Stan, thank you for making this powerful tool and providing it free - for now ;) I appreciate the flexibility of the tool. Really nice work!
Thank you Dexter!
Many thanks Bro.
Your instructions are very specific and detailed.
Waiting for your next useful videos. Hope your channel grows more and more !
Thanks a lot, that’s very nice! Some new videos coming this week
I just got the GPT for Sheets and Docs. Amazing!! Can't wait to learn more. Thanks for the videos!
Enjoy!
This looks very interesting, Also I really appreciate your videos explaining everything.
Thanks for watching and for your feedback!
The part about angry flowers was hilarious 😆... awesome video! I'm sold.
I wish I knew about this plugin yesterday! I was using a Shopify plugin to embed our product collections into listicles/blog post, using the HTML div tags it generated. I had to select options and get each html tag per collection 1 by one, to use in a GPT prompt (if that makes sense!) I was using Excel and pasting the raw HTML into it. But I wanted to extract just the collection IDs for reference and alter the formats to experiment with the layours, and to edit and test different embed options etc.
*Sighs* long story long (sorry), your plugin would have saved me hours of time! Wow it really achieves everything I wished was possible.
This is such a useful plugin it's gonna be a game changer, so thank you for the future countless hours that it is going to save.
Hello! We're are glad to read our product help you be more productive! Do no hesitate to leave us a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
I have followed the revolution of this new technology with great enthusiasm. Long live CHATGPT!
Tenho acompanhado a revolução dessa nova tecnologia com muito entusiasmo. Vida longa ao CHATGPT!
👏👏👏
thank you for your feedback!
Great! Your instructions are very useful and clarify. Thank you so much. I come from Vietnam.
You are welcome! Does it work well in Vietnamese?
This is super awesome. Great video!
Thank you Stephanie!
Hi Stan, thanks a lot! I'd appreciate a video on how this could be used as a matchmaker. I want to sort attendees into compatible tables for a networking event based on their submitted data. Thanks!
the part which suprised me most was the data cleaning ability......that was powerful!!!
Thanks! A new video on cleaning spreadsheets is coming very soon, keep an eye out :)
@@gptforwork wow...can't wait to see that!!!
very good explanation, it is incredible what can be done in google sheets.
Glad you liked it
❤ Thanks so much for sharing. This is amazing!
Glad you enjoyed it!
Thank you very much! It's absolutely amazing! I do have one question will it work with GPT 4.0? Thank you again I greatly appreciate all your time and effort! Jason.
Yes, if you have access to GPT-4 with your API key you can :)
just specify "gpt-4" as the last parameter. Careful though as it is slower and more expensive
You are an absolute legend brother!
thank you! If you like our product don't hesitate to leave a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
Thank you so much for this! Genius! 🙏🏼🙏🏼
You're so welcome!
Great tool! Love it!
thank you!
awesome video, awesome extension. Thank you
Thank you! About to get even more awesome soon.
Good job, excellent video. Thanks
Glad you liked it!
Very Useful!!!!
Glad you think so!
Many thanks very useful!
You're welcome!
Thank you - this is cool!
Glad you liked it!
Hi, this is amazing, can you help me figure out how to integrate it better in things like cost sheets and revenue streams to analyze data based on the provided information ??
Hi there, this year this should become possible.
So grateful for this thank you’s. PS just curious, how do you change the model and check which model you are using ?
the default model is gpt-3.5-turbo. you can change the model by specifying the model you want in the last parameter of any function.
See our reference here: gptforwork.com/gpt-for-sheets/reference#6fc7eba8f45d4e87bb68d676e6893ea4
Hi Stan, thank you so much for sharing this ,
you're welcome! please share a nice review here if you can: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
This is really effing cool... Thanks so much for this incredible tool! You've certainly got my Sub and like!
Awesome, thank you!
Awesome, thanks for this. Would it be able to perform thematic analysis on qualitative data for me?
Yes absolutely, you can ask GPT to categorize or tag your data.
thaks, it's GREAT!
you're welcome!
Hi Stan, loving all the videos and functions. Can I check with you if it's possible to use GPT for sheets to pull in crypto price data from coinmarketcap that is live?
Hello! It is not possible with GPT for Sheets, but you can use Awesome Table Connectors with many API connector. Find out more here: awesome-table.com/connectors/help/export-to-google-sheets
Hey Stan, thank you this looks really good. I just wanted to ask how I can copy the content from the cell when I just shows a formula.
Hello! You can directly replace formulas from the sidebar, either in a selected number of cells or in the entire spreadsheet if you're satisfied with all the results. You can find more information here: gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/replace-formulas-with-results
Great tool, is there a fix on your side for the "too many exceed maximum errors" on longer content? Not sure if it is coming from OpenAI or your extension, but I do not get that many errors using python doing the same task.
The easiest way is to avoid that problem is to upgrade to a paid openai account. They are throttling free trial accounts pretty hard as can be seen here: gptforwork.com/tools/openai-api-response-time-tracker
We will roll out an update soon that fixes it on our side.
thanks for this awesome tools
You're welcome!
Hey Stan, thank you this. I just wanted to ask how I can copy the content from the cell when it just shows the formula. Is there a way to copy the response it gives?
Hello! You can simply copy/paste values or directly replace formulas from the sidebar, either in a selected number of cells or in the entire spreadsheet if you're satisfied with all the results. You can find more information here: gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/replace-formulas-with-results
Thanks for the video! Is there a way to use two lists of data rather than just one? For example to calculate the distance between two places where I have a list of origins and a separate list of destinations for each origin?
Hi Matthew,
I'll give you two answers:
- it is possible to use two lists of data (or more).
- however, you shouldn't use GPT to any maths, it's really not made for that at all
@@gptforwork Thanks very much for the quick response - much appreciated! I thought of trying to use it to retrieve distances between two places from google or apple maps. Results seem to be inconsistent. sometime correct, but quite a few mistakes as well. =GPT("What is the distance in kilometres by car between New York and Boston using Google Maps")
Thank you so much!!! :) would it be able to organise a large data set?
Hi Archie, that question is a little too broad for me to answer ;)
excellent !
Thank you! Cheers!
thanks a bunch
you're welcome
Great stuff, especially that piece. My question is focused on whether machine learning (-> AI should learn the style of my texts and generate a new text from it) is also possible with ChatGPT/Google Sheets.
After learning the basics, I want to go to the next level. The artificial intelligence should learn from existing texts with the help of machine learning and generate texts in a similar way.
That this works has been proven by the "normal" ChatGPT (she answers: "If you provide me with one or more speeches, I can try to generate a similarly worded speech").
That means in the chat corresponding texts can be fed iteratively (Ex: "I provide you with several speeches, so that you can generate a formulated speech in a similar way. Here is text 1! [Content] (...) Here is text 2 [Content] (...)! Here is text 3! [Content] (...)").
It is theoretically only a technical question to implement this in Google Sheets as well (Task: "Write a speech". Tone: "In terms of style, it should be as similar as possible to [line speech 1] and [line speech 2] in comprehensibility, precision, and eloquence.")
Is this the right approach or do I have a thinking error? Can Google Sheets do this (synchronicity of this command in Sheets vs. the step-by-step approach in ChatGPT.
Thanks a million for your assessment!
David
Hi David,
You can already "prompt from examples" with GPT_FILL and GPT_TABLE. Then there are two questions:
- how lengthy are your examples. If you're talking about speeches, it might be too big for those functions for now. If you're talking line by line, then they should definitely work.
- how many examples you have and how precise you want your output format to be. If you want to train on many (hundreds) of examples to get a very precise output, then a fine-tuned model will work best. It is not yet possible to fine-tune from GPT for Sheets, but will be in the near future. But you can already use an existing fine-tuned model from GPT for Sheets by specifying its name in the model argument.
Hope that helps
@@gptforwork Yes, that is a helpful classification, thank you!
As for now feeding larger texts (token limit) I came up with a heuristic solution.
In Google Sheets, I divide the text to be analyzed (e.g. a long court decision) into separate parts and copy them into adjacent cells [e.g. a court decision of 20 pages I split into 5 parts: [C20, D20, (...) G20].
At the prompt I do not refer to a line, but an addition ["(...);20:20)"].
Admittedly quite primitive and the disadvantage is the manual chunking, but well it works :)
@@papp_erla_papp sounds like an interesting use-case and smart solution! would you be willing to share your spreadsheet with me privately? if yes please fill this form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
maybe I can help you with your layout too.
Hi, this is fantastic. I'm curious if there is a way to have gpt clean up open hours for restaurants from a cell that might have something like this: "closed Mon; 11:30a-3:00p & 5:00p-9:30p Tu-Th; 11:30a-3:00p & 5:00p-10:30p Fri; 12:30-10:30p Sat; 12:00p-9:30p Sun". I've done 14 examples so far and gpt does not seem to be able to figure it out. I'm not a coder, so I'm not sure if there are any other tricks to incorporate.
Hello! We would be happy to help you with your use case but could you please explain a bit more what you mean by "cleaning up" open hours for restaurants? You can also detail your use case and share your spreadsheet by contacting our team here: support.gptforwork.com/hc/en-us/requests/new
Hello, this tool is fantastic, thanks a lot. Can I ask you one question? For each URL I have in my sheet I would like chatGPT to get a summary of the content (so it should check online) and a categorisation. Any easy way I could do this?
hi, yes you can do this with the GPT_WEB function (pricing is $0.05 / request)
This is incredible thanks, How might we able to use this to fill in LinkedIn links to contacts and add description to contacts?
Hi Steve, could you please clarify your question in this form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
please note that GPT for Sheets currently does not have access to the web.
Hi Stan, thats an amazing tool. thanks a lot. one question: I´d like to basically achieve the following: I want to use the sheet to create Content for product descriptions and we have different kind of content pieces listed in the google sheets per row (e.g. Bullet Point 1 / Bullet Point 2 / Care Instructions etc.). per column we then have the respective product we´d like to write content for in each cell of the row. We´d like to prompt GPT to fill in the content for each respective content piece in each row using a general product briefing for the product we want to create content for (this could also be placed in another cell). is it possible to work with the intregation in a way that we could prompt "=GPT("create output based on the content piece described in Column B1 for a product that i´m briefing you in column A1)?
Hello! yes it is totally possible. Find out here how to use the get started with GPT for Work: gptforwork.com/help/gpt-for-sheets/get-started
and how to use the GPT function: gptforwork.com/help/gpt-for-sheets/gpt-functions/how-to-use-gpt-function
Hi Stan,
Great tool. I have a spreadsheet with data from a Google Form survey. Can I uses this tool to analyse and evaluate the data from that Google Sheet?
Hello! Yes of course, you can use it for all sorts of tasks including analysis! Just make sure to install the addon and enable GPT functions within the spreadsheet you're working on. Find more information on how to get started here: gptforwork.com/help/gpt-for-sheets/get-started
Hello, lets say that i have in cell A list of different product titles and on cell b I have my total website catoegories which are available to use. which is the formula to use to generate to Cell C the right category according to the product title ? The products are branded and they can be searched by chat gpt to web before guess the cateogry ?
hello, please write to our support for help on your use-case. it's very likely doable.
Hey Stan, I just wanted to take a moment to say thank you for all of the helpful tutorial videos you've been putting out! Your expertise and attention to detail have been invaluable in helping me improve my own skills. Keep up the awesome work! #grateful #tutorialvideos #creativityboost #lifelonglearning @Stan #JuanUsingGPT
You probably spent 10x more time posting on each video than writing it haha! Thanks a lot
@@gptforwork 😉
Thanks you
you're welcome! If you like our product don't hesitate to leave a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
I have specifications of multiple products in a table and the header row explaining what the specification is is at the top of the sheet (weight / height / power output) in the rows below that the actial specification is listed (22cm / 40cm / 700w) now i want to make a prompt that will write an ecommerce description for each row that i can drag down. how can i do this in a way where the column headers in the top row will be referenced so that gpt knows what each specification is for?
Hello! Your use case sounds interesting, could you please contact our support team: support.gptforwork.com/hc/en-us/requests/new
Can’t wait till the next time I angrily receive flowers.
Hi Stan thanks for video-My question is can you use GTP for Website Scrapping? or apply it for frontend-backend App?
Hello, GPT cannot scrape the web for now. I'm not sure I understand your second question, but you can certainly generate code with it, although Sheets is probably not the best place to create a full stack webapp.
This is excellent! Thank you very much. Will this extension remain free?
Hi Jim, thank you! The main functionality in its current form will remain free, but we will very likely introduce some paid features on top of it.
thanks for a good laugh out loud 3:40, so funny.
Hi Stan, are you able to use mailchimp for this instead of mail merge? My business google accounts keeps getting disabled from spam even though I’m sending hyper personalized emails per prospect. Would mailchimp work or would you recommend outlook?
Hello! You can definitely use Mailchimp or any emailing tool you want if you prefer with GPT for Sheets.
This might relate to the previous comment by Dennis about large prompt, but can you please specify for this situation?
I have this in column A: Task: Write an email message to appeal to a passive job candidate who's experienced in hardware engineering
And this in column B: Specialty: design verification
and when I populate the formula =GPT_FILL(A2:B3) in A4, it's replaced by Greeting: in A4 and the following text in cell B4
Greeting: Dear [Name], I hope this message finds you well.
How do I get the full email message body message to appear after "well." ? Format > Alignment > Top and Format > Wrapping doesn't appear to display any of the subsequent text.
Hi Glenn, it's difficult for me to fully understand your layout and what you want to achieve with this comment only. Could you please fill this form and include a screenshot or video? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
I'll try to help you.
@@gptforwork thanks for your prompt response. I've submitted the google sheet in question and an annotated screeenshot.
I fixed it for you, see my email :)
Thanks for the tool! Is davinci-003 the default model of =GPT()?
you're welcome! yes text-davinci-003 is the default model
Amazing STAN Absolutely Great JOB and thanks for the FREE Plugin 🙏🏼, Will definitely Try it out and let you know. Could you create a more beginers video as to how to use it for day to day tasks in work and home, THANK Once Again 🙏🏼
let me know which tasks you would like me to cover!
@@gptforwork HI STAN, I am want to create a Google Sheet to research Google Keywords, but want to share with others, and have a settings sheet where user puts his own Chat Gpt API Key, then in other sheet they enter a keyword and then with Chat GPT we create related keywords, THANKs
Thank you so much!
For longer answer I get a "Exceeded maximum execution time" of probably 30 seconds. is there a way to tweak that?
Hi Rogier, yes, you probably need to reduce your prompt or the max_tokens parameter. Please watch this video for more information: czcams.com/video/82Fc9Olldnw/video.html
@@gptforwork Thank you, very helpfull.
I went to use the GPT FILL function, to standardize email or create email from names, but it is limited to only 25 lines, you can do it with more lines like 1000?
you can do that by having only one row of input, and then drag the formula down.
How could you have GPT rewrite the existing text in a range of cells?
Hi, just provide the cell or range of cells in the value parameter
Thank you Stan for making accesibable to the world. Indeed very powerful.
Can it also be used with excel _?
Without a doubt it can soon be replacing somehow the functionality of spreedsheets......
Thank you ! It’s not yet available on Excel.
Hello Stan, I am having trouble using the FILL function. I am trying to automate product descriptions on a sheet that has several columns of attributes and tagging information (which is essential for mapping to fields website product detail pages). Questions: How do I select/indicate just certain columns to feed the prompt and what is "temperature"? I would also like to include a tone. Thank you.
Hello Michelle,
You can include columns that are unnecessary, otherwise you probably have to reorder them temporarily, as GPT_FILL currently doesn't support ignoring some intermediate columns.
It might also be easier through the GPT function especially if you want to include other parameters such as the tone (put the examples and tone in the prompt parameter).
If you don't manage by yourself, could you please send me your spreadsheet through this form? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Temperature is creativity. See here: gptforwork.com/guides/openai-gpt3-temperature
@@gptforwork Hi Stan- thank you. I just submitted my question and pasted a link to my doc.
I'd love to learn more on your process. Are your creating product descriptions for ecom?
hey stan, great video. How do you use chat GPT in google cheet to create categories based on a set of say 100 lines of data and output the correct category for each cell?
Hi Isaam, there are a few ways to do that with GPT_FILL, GPT_TAG or GPT_CLASSIFY. Please fill the Google Form here and I will help you out: forms.gle/umHpbGBYHzNq8TsMA
@@gptforwork Vielen Dank!.. ive sent u the forms
How many lines can it do?
I am looking to get it to create a personalized first line of an email from position, company, & name or from Linkedin profile link. Any clue how to program this?
Hi there, please see this video: czcams.com/video/XDHug_doqZU/video.html and let me know if it answers your question
After experimenting with your extension, I found that the function doesn't like large| process large prompts e.g. 200+ words. Is there a setting I need to adjust to get large prompts to work? Thank you.
Hi Dennis,
If your prompt is large (200+ words) and you're expecting a long answer as well, you will need to increase the max_tokens parameter.
However, Sheets functions require a response in less than 30 seconds, so unfortunately for longer prompts or responses, OpenAI's response doesn't come quickly enough. We are going to work on another mode of interaction (via a sidebar) which will not suffer from the same limitation.
In the meantime, I advise to use values of max_tokens lower than 500. You can play around with values.
Otherwise, you can also use our Google Docs integration, which easily handles big prompts and answers (up to 4000 tokens in total per request)
Hope that helps
@@gptforwork Wow! Super thanks for such a thoughtful and detailed response!
Stan This is pretty sweet but can you provide some examples or functionality with creating charts or analyzing numbers? I have a hotel and I want AI to find day of week trends for Occupancy, Average daily rate, Revenue per available room, etc. Thats What I was really hoping for...numbers. It is sheets after all. :)
Hello! Currently our add-on is not made to create charts or analyze numbers. It is mostly made to work with text in bulk.
Hi, can I add a Cell inside the prompt like : "Write 5 Variations of Cell: A1"?
yes you can with a CONCAT or CONCATENATE function. Otherwise you can use the value parameter, or the CREATE_GPT_PROMPT function
Hi, how could I import data from a another worksheet.
Thank you
Hello, you can use IMPORTRANGE or Awesome Table Connectors.
Hi Stan! Thank you for the great tutorials! I have 1 question. Maybe you know why I can't generate a result with more than 150 words using GPT for Sheets? I tried to add word count to my prompt but it doesn't work.
Hello! You can try tweaking the max_tokens parameter: gptforwork.com/help/gpt-for-sheets/settings/max-tokens
is it possible to get chat gpt to work with data that's in the sheet? i try to analyze 500 rows of data but for some reason can't get it to work.
Hello, could you please clarify what you're trying to do in this form? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Hi, I do not get the 'value' in my =GPT(prompt, model, temperature, maxTokens, cache) as seen in your demo. Is it because i don have access to chatGPT 4?
Yes, I have the same problem. I use the paid GPT 4. When I double-click on the formula, no dialog opens. So I can't claim any value. Therefore the software is worthless to me. Please support. Thanks.
Hello! It is possible you are using a copycat addon. Please make sure to use GPT for Work: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
Guys I'm trying to just grab information from my excell columens and present it with CHat GPT can someone save me seems like a simple task but I'm struggling so hard to find that functionality and I'm missing something?
Hello! Our support team would be happy to help you: support.gptforwork.com/hc/en-us/requests/new
Is it possible for GPT Sheets to visit websites so you can mass personalize?
Hello! A web scraping function is to come very soon! In the meantime, we developed a script to enable web scraping in GPT for Sheets. You can find here how to do it: gptforwork.com/help/gpt-for-sheets/scrape-web-pages
hi I am using office 365 from my university account. Do I have to pay if I use these gpt for office
yes you do
Do you know how to ask for a review of a specific URL ?
hello, ChatGPT cannot access the web yet, sorry.
Hi, I don't get the option to set it up. The only thing I see on the submenu is "help" what should I do?
Hi Melissa, just refresh the spreadsheet and wait a few seconds. Add-ons sometimes fail to load.
I started to fall in love with this🌹💖
I am trying a no-code tool called Frontly which helps me build apps over G Sheet .. you connect your G Sheet account and build the interface with no code and publish the Frontly app as a web app.. so users don't have to interact directly with sheets.. I am wondering if this can be useful with a sheet that's running the GPT for Sheets?
Thinking about giving my teammates our own AI Copywriter 🤩
Also is there any suggestions on how to limit their usage?
Hi Mohammed, we already have this kind of tool at awesome-table.com if it interests you. Of course you can build your own, and of course GPT for Sheets would be useful to manipulate the data in the Sheet ;)
you can limit usage in the OpenAI dashboard
Hey! Really great plugin congrats!! When I try to load long responses, I get this error "Exceeded maximum execution time (ligne 0)." in Google Sheets, now way to bypass that? Thanks a lot :)
Hey there, we're working on a way to bypass this, but currently, there is no other way than by reducing the max_tokens parameter or trying outside of peak hours.
@@gptforwork Thanks a lot for your prompt response ;)
Can I embed the result of a cell into my prompt ? it doesn't seem possible with the current syntax of this add-on
Could you please clarify your question? Ideally show an example of what you want to do.
@@gptforwork I managed to make it work, it was an error from my side.
I fixed the error by splitting the prompt and the result of another cell and used =GPT() on the 2 cells together, it worked perfectly.
awesome!
Just tried it, works well, except, I have found that I have been getting incomplete results for longer answers, which means there is some character limit for the returned result for the GPT function, is there a way to increase that? Thanks.
Hi Jack absolutely, you need to increase the maxTokens parameter which by default is 250.
See our reference here: gptforwork.com/gpt-for-sheets/reference#6fc7eba8f45d4e87bb68d676e6893ea4
Keep in mind that in Google Sheets, maxTokens value of above 700 are more susceptible to timeouts, and it is better to use our Google Docs integration for long-form content generation.
Hi Jack, we have just integrated with the new gpt-3.5-turbo model, which should solve this concern!
Hi, i've some problem. When i was trying to generate a new texts for next rows a i received an error "Exceeded maximum execution time (line 0)." Can U help me?
Hi, this unfortunately happens frequently during US peak hours.
We are working on a perennial solution that should be out in 3 weeks. In the meantime, here's what you can do:
- simply retry, it usually works after a few retries
- set up a paid account on platform.openai.com if you haven't yet (this is unrelated to ChatGPT Plus, which doesn't cover API usage). We've noticed better response times on paid accounts (though it takes 48 hours to get full rate limits) as per platform.openai.com/docs/guides/rate-limits/overview
- use it outside of US peak hours for better chances
- use another model (such as text-davinci-003 or text-curie-001)
@@gptforwork Hi, the problem persists. Do you already have a solution?
Hi Stan, I keep getting asked to authorize the use of my API. How can I enable the authorization?
Hi Mohamad, please follow the tutorial here: gptforwork.com/set-up/how-to-set-up-api-key
@@gptforwork That tutorial doesn't mention anything regarding authorization.
Thank you for creating this! I'm having an issue however. When I enter the API key I get the error message "ScriptError: Authorization is required to perform that action." Any help would be much appreciated!
Hi, Robert, please follow the guide here: gptforwork.com/help/errors#ef6b5004bb9f4928ad585d49b574db03
@@gptforwork That did the trick! Thank you so much!
Does it work with GpT 4 now ?
yes it does: gpt-4-turbo, gpt-4, from OpenAI or Azure
Cool stuff. I wonder if there is a free way to usea chat gpt api key
Hi Patricio, openai provides a free trial.
@@gptforwork already used in December 😢
Amazing! ❤❤❤ can use to creates posts on Instagram?
Of course !
How do I put a topic in cell A1 and get it to refer to it?
You can do GPT(A1) if your whole prompt is in A1.
If your prompt is in multiple cells in column A, you can do GPT(A1:A3) for example
And if it is in multiple columns, you can do GPT(A1:B3)
😍😍😍
Do you charge for your services? I need something bespoke created for my business.
Hi, we do not do custom engagements, but if it's something simple, you can send me a request through docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform and I will try to help.
would there be anyway to integrate aiprm into your sheets, in a quick way so it set the prompt and tasks as a nice template?
hi, you can copy any prompt into the spreadsheet and use it from there. I understand it's not ideal and we will release prompt libraries at some point.
@@gptforwork great thank you. Is there an example on how I could for example write a prompt and then set an example to follow the format . For example for a product title , to rename a list of titles then follow the format of an example set out . I’m not great with sheets yet . Thank you so much
@@eldean0 hello, can you please fill this form docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform and share your spreadsheet with me, so that I can help you
@@gptforwork absolutely ! Will do that now thank you so much!
@@eldean0 you didn't share your spreadsheet with me, I can't see it ;)
Hello...I've wanted to test stand-alone ChatGPT and this version as a Google Sheets extension, but I'm stymied by the Open AI verification process which insists that the user has a cell phone. I do not. Only a landline. Is there a way to get around that so I can test GPT? Thanks.
Hi there. Do you know anyone who has a cellphone?
@@gptforwork I've thought about asking to use a friend's cell. Would they see all my ChatGPT activity, or is the phone just used for verification? Thanks.
@@dougcallaghan6075 it's just used for verification, they won't see anything
@@gptforwork Thanks.
Hey Stan! copying my comment over here:
Do you happen to know the function code of this plug-in so I can combine it with "=subtotal" functions?
Trying to use Chat GPT to summarize filtered data but need the subtotal function... I believe. Any guidance would be amazing!
Hi Spencer, sent you an email, I think I found the solution with GPT_CREATE_PROMPT and FILTER
I get errors when i use it! Do i need chat gpt 4?
Hello! You don't need ChatGPT4 to use the addon. You can contact our support team to better identify what's not working: support.gptforwork.com/hc/en-us/requests/new
When I write "=gpt(A1,,1)" It gives an error. I dont know why
Hello Ayça, what error exactly? if you want you can fill our support form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Funciona en español?
It should! Try it :)
bonjour est-ce que cela fonctionne avec gpt4v?
Bonjour! Oui vous pouvez utiliser GPT4 ainsi que d'autres modèles. Tous les modèles disponibles sont ici: gptforwork.com/help/supported-models
@@gptforwork oui lorsque je suis dans mon playgroud je n'ai accès qu'à l'api du 3.5
hello Stan, you are genius!! you do a great job. Stan, can I ask the question on your dirty name from sheet that can this be filled in Column A -Surname, B- Given name? How to do it? Thanks again.👍
seems I've suddenly got it.😂
great! so you don't need help anymore?
@@gptforwork yes. well done now. Thanks anyway for your great videos.
@@DarrelLau if you have a minute to spare, don't hesitate to leave us a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
it really helps!
Por favor que poco ritmo, gracias por la info pero me he dormido dos veces en 17 minutos y eso que lo he puesto a 1.5
you can use 2x :) but I will try to do better next time