ChatGPT in Google Sheets: a beginner's guide (101)

[@kenanga60]

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..🥰

[@lilfooX2]

This blew my mind and I think I've spent 3 hours on a Friday night playong around with this! Thanks so much!

[@gptforwork]

Love to hear this, thank you!

[@dextercagan5615]

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!

[@gptforwork]

Thank you Dexter!

[@LoneBagels]

The part about angry flowers was hilarious 😆... awesome video! I'm sold.

[@nhatanhtao3658]

Many thanks Bro. Your instructions are very specific and detailed. Waiting for your next useful videos. Hope your channel grows more and more !

[@gptforwork]

Thanks a lot, that’s very nice! Some new videos coming this week

[@jamespower2670]

This looks very interesting, Also I really appreciate your videos explaining everything.

[@gptforwork]

Thanks for watching and for your feedback!

[@nickpage9138]

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.

[@gptforwork]

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

[@rquintanajr]

I just got the GPT for Sheets and Docs. Amazing!! Can't wait to learn more. Thanks for the videos!

[@gptforwork]

Enjoy!

[@samuelkodjoe1645]

the part which suprised me most was the data cleaning ability......that was powerful!!!

[@gptforwork]

Thanks! A new video on cleaning spreadsheets is coming very soon, keep an eye out :)

[@samuelkodjoe1645]

@@gptforwork wow...can't wait to see that!!!

[@MrEdenBezerra]

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! 👏👏👏

[@gptforwork]

thank you for your feedback!

[@josephnicholas3677]

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.

[@gptforwork]

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

[@SouthbayCreations]

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.

[@gptforwork]

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

[@WinstonChurchillFan]

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.

[@stevepirie8949]

This is incredible thanks, How might we able to use this to fill in LinkedIn links to contacts and add description to contacts?

[@gptforwork]

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.

[@danieldbryant]

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?

[@gptforwork]

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

[@GiovanniMonia]

Hello. Nice add on. Is it possible to “fine tune” a davinci model? I need to instruct the model with a preset of language translation

[@gptforwork]

hello, it is not possible to fine-tune from the add-on yet, but it is possible to use a fine-tuned model from the add-on. Use ### as separator and END as stop sequence during fine-tuning.

[@gerardmiller2161]

Awesome, thanks for this. Would it be able to perform thematic analysis on qualitative data for me?

[@gptforwork]

Yes absolutely, you can ask GPT to categorize or tag your data.

[@jim-wells]

This is excellent! Thank you very much. Will this extension remain free?

[@gptforwork]

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.

[@tiwale6387]

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.

[@gptforwork]

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.

[@aidrivendesigners]

You are an absolute legend brother!

[@gptforwork]

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

[@stepherriffic]

This is super awesome. Great video!

[@gptforwork]

Thank you Stephanie!

[@lawvalerie5522]

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?

[@nietfullthings7135]

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.

[@gptforwork]

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

[@bhanujinaidu]

Good job, excellent video. Thanks

[@gptforwork]

Glad you liked it!

[@franclommm]

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?

[@gptforwork]

hi, yes you can do this with the GPT_WEB function (pricing is $0.05 / request)

[@PAULMEYERSNorthBay]

awesome video, awesome extension. Thank you

[@gptforwork]

Thank you! About to get even more awesome soon.

[@Hoopskingbasketball]

How could you have GPT rewrite the existing text in a range of cells?

[@gptforwork]

Hi, just provide the cell or range of cells in the value parameter

[@keysinuñez-e8c]

very good explanation, it is incredible what can be done in google sheets.

[@gptforwork]

Glad you liked it

[@JustMe-ju7wd]

❤ Thanks so much for sharing. This is amazing!

[@gptforwork]

Glad you enjoyed it!

[@Ricardo_Parker-3.14]

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?

[@gptforwork]

you can do that by having only one row of input, and then drag the formula down.

[@RogierChang]

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?

[@gptforwork]

Hi Rogier, yes, you probably need to reduce your prompt or the max_tokens parameter. Please watch this video for more information: kzbin.info/www/bejne/bmOplGyFodGXpNk

[@RogierChang]

@@gptforwork Thank you, very helpfull.

[@cungxemphim]

Very Useful!!!!

[@gptforwork]

Glad you think so!

[@AliSyed-z2x]

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.

[@gptforwork]

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

[@glenngutmacher4622]

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.

[@gptforwork]

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.

[@glenngutmacher4622]

@@gptforwork thanks for your prompt response. I've submitted the google sheet in question and an annotated screeenshot.

[@gptforwork]

I fixed it for you, see my email :)

[@melissafernandez3902]

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?

[@gptforwork]

Hi Melissa, just refresh the spreadsheet and wait a few seconds. Add-ons sometimes fail to load.

[@DanielChongvideos]

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?

[@gptforwork]

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

[@archiehollingsworth3179]

Thank you so much!!! :) would it be able to organise a large data set?

[@gptforwork]

Hi Archie, that question is a little too broad for me to answer ;)

[@DesertGardenPrepper]

thanks for a good laugh out loud 3:40, so funny.

[@LW-vj4ud]

What subscription are you on? I upgraded to Google Premium to Setup the API key, but it's not working, do I need to upgrade to the AI Premium subscription? Can I use the free version of Chat GPT to do this? It's not linking for me. Please help me eep

[@gptforwork]

hello, please check our pricing page: you do not need to set an api key, nor do you need a chatgpt subscription.

[@LW-vj4ud]

@@gptforwork I got the extension for work, it's fantastic, thank you. Videos are great to. If there a way to tell the formula to deliver the information transposed?

[@LW-vj4ud]

I got it, I just put =TRANSPOSE(GPT_ .....)

[@ProGeekReview]

Thanks for the tool! Is davinci-003 the default model of =GPT()?

[@gptforwork]

you're welcome! yes text-davinci-003 is the default model

[@kylehessling2679]

This is really effing cool... Thanks so much for this incredible tool! You've certainly got my Sub and like!

[@gptforwork]

Awesome, thank you!

[@sheilaforde836]

Thank you - this is cool!

[@gptforwork]

Glad you liked it!

[@goodvietnam]

Great tool! Love it!

[@gptforwork]

thank you!

[@pleabargain]

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.

[@gptforwork]

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

[@pleabargain]

@@gptforwork Wow! Super thanks for such a thoughtful and detailed response!

[@Justbehappy_123-h4m]

Hi Stan, thank you so much for sharing this ,

[@gptforwork]

you're welcome! please share a nice review here if you can: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654

[@do0rkeeper]

thaks, it's GREAT!

[@gptforwork]

you're welcome!

[@MrLittletube]

Can’t wait till the next time I angrily receive flowers.

[@diegosandoval7462]

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!

[@probloggingbusiness]

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 :)

[@gptforwork]

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.

[@probloggingbusiness]

@@gptforwork Thanks a lot for your prompt response ;)

[@NateG-u5d]

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. :)

[@gptforwork]

Hello! Currently our add-on is not made to create charts or analyze numbers. It is mostly made to work with text in bulk.

[@TheZnnikos]

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 ?

[@gptforwork]

hello, please write to our support for help on your use-case. it's very likely doable.

[@MatthewSlaven]

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?

[@gptforwork]

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

[@MatthewSlaven]

@@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")

[@michellepizzurro1664]

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.

[@gptforwork]

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

[@michellepizzurro1664]

@@gptforwork Hi Stan- thank you. I just submitted my question and pasted a link to my doc.

[@learningstuff5679]

I'd love to learn more on your process. Are your creating product descriptions for ecom?

[@eldean0]

So grateful for this thank you’s. PS just curious, how do you change the model and check which model you are using ?

[@gptforwork]

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

[@ariguinsberg9740]

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?

[@gptforwork]

Hello! Your use case sounds interesting, could you please contact our support team: support.gptforwork.com/hc/en-us/requests/new

[@isaamrafee9902]

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?

[@gptforwork]

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

[@isaamrafee9902]

@@gptforwork Vielen Dank!.. ive sent u the forms

[@josephdeangelis6844]

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?

[@gptforwork]

Hello! You can definitely use Mailchimp or any emailing tool you want if you prefer with GPT for Sheets.

[@moneyjuice]

Can I embed the result of a cell into my prompt ? it doesn't seem possible with the current syntax of this add-on

[@gptforwork]

Could you please clarify your question? Ideally show an example of what you want to do.

[@moneyjuice]

@@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.

[@gptforwork]

awesome!

[@papp_erla_papp]

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

[@gptforwork]

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

[@papp_erla_papp]

@@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 :)

[@gptforwork]

​@@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.

[@sanguinj]

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......

[@gptforwork]

Thank you ! It’s not yet available on Excel.

[@eldean0]

Thank you so much for this! Genius! 🙏🏼🙏🏼

[@gptforwork]

You're so welcome!

[@gandsdiamondsonline]

Many thanks very useful!

[@gptforwork]

You're welcome!

[@royaconferrxconferrxllc9751]

Hi Stan thanks for video-My question is can you use GTP for Website Scrapping? or apply it for frontend-backend App?

[@gptforwork]

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.

[@joethomas4176]

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?

[@gptforwork]

Hi there, please see this video: kzbin.info/www/bejne/jnWrppqVmdSkkLc and let me know if it answers your question

[@KilianWorks]

Hi, can I add a Cell inside the prompt like : "Write 5 Variations of Cell: A1"?

[@gptforwork]

yes you can with a CONCAT or CONCATENATE function. Otherwise you can use the value parameter, or the CREATE_GPT_PROMPT function

[@MohammedAli-tq8ln]

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 🤩

[@MohammedAli-tq8ln]

Also is there any suggestions on how to limit their usage?

[@gptforwork]

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 ;)

[@gptforwork]

you can limit usage in the OpenAI dashboard

[@mohamaddahduli1829]

Hi Stan, I keep getting asked to authorize the use of my API. How can I enable the authorization?

[@gptforwork]

Hi Mohamad, please follow the tutorial here: gptforwork.com/set-up/how-to-set-up-api-key

[@mohamaddahduli1829]

@@gptforwork That tutorial doesn't mention anything regarding authorization.

[@JackWangNZ]

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.

[@gptforwork]

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.

[@gptforwork]

Hi Jack, we have just integrated with the new gpt-3.5-turbo model, which should solve this concern!

[@DarrelLau]

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.👍

[@DarrelLau]

seems I've suddenly got it.😂

[@gptforwork]

great! so you don't need help anymore?

[@DarrelLau]

@@gptforwork yes. well done now. Thanks anyway for your great videos.

[@gptforwork]

@@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!

[@kristiansrbrden8835]

Is it possible for GPT Sheets to visit websites so you can mass personalize?

[@gptforwork]

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

[@ayseozkal1208]

hi I am using office 365 from my university account. Do I have to pay if I use these gpt for office

[@gptforwork]

yes you do

[@largoenjapon3377]

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

[@gptforwork]

You probably spent 10x more time posting on each video than writing it haha! Thanks a lot

[@largoenjapon3377]

@@gptforwork 😉

[@damianperna132]

Hi, how could I import data from a another worksheet. Thank you

[@gptforwork]

Hello, you can use IMPORTRANGE or Awesome Table Connectors.

[@eldean0]

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?

[@gptforwork]

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.

[@eldean0]

@@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

[@gptforwork]

@@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

[@eldean0]

@@gptforwork absolutely ! Will do that now thank you so much!

[@gptforwork]

@@eldean0 you didn't share your spreadsheet with me, I can't see it ;)

[@snp5508]

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.

[@gptforwork]

Hello, could you please clarify what you're trying to do in this form? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform

[@DimaBatan]

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.

[@gptforwork]

Hello! You can try tweaking the max_tokens parameter: gptforwork.com/help/gpt-for-sheets/settings/max-tokens

[@gesmediagesmedia7111]

Do you know how to ask for a review of a specific URL ?

[@gptforwork]

hello, ChatGPT cannot access the web yet, sorry.

[@101-businessreviews7]

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 🙏🏼

[@gptforwork]

let me know which tasks you would like me to cover!

[@101-businessreviews7]

@@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

[@Frity85]

Cool stuff. I wonder if there is a free way to usea chat gpt api key

[@gptforwork]

Hi Patricio, openai provides a free trial.

[@Frity85]

@@gptforwork already used in December 😢

[@BartoszSEO]

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?

[@gptforwork]

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)

[@BartoszSEO]

@@gptforwork Hi, the problem persists. Do you already have a solution?

[@Steven-Bamber]

Do you charge for your services? I need something bespoke created for my business.

[@gptforwork]

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.

[@chrisder1814]

hello about RAG?

[@gptforwork]

hello, you can use openai assistants for RAG

[@chrisder1814]

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

[@lilillllii246]

How do I put a topic in cell A1 and get it to refer to it?

[@gptforwork]

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)

[@philipkehela4250]

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)?

[@gptforwork]

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

thanks for this awesome tools

[@gptforwork]

You're welcome!

[@michelparmentier3063]

excellent !

[@gptforwork]

Thank you! Cheers!

[@robertivanovx]

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?

[@gptforwork]

Hello! Our support team would be happy to help you: support.gptforwork.com/hc/en-us/requests/new

[@RobertLindsley]

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!

[@gptforwork]

Hi, Robert, please follow the guide here: gptforwork.com/help/errors#ef6b5004bb9f4928ad585d49b574db03

[@RobertLindsley]

@@gptforwork That did the trick! Thank you so much!

[@eleizesilvaferreira6471]

Amazing! ❤❤❤ can use to creates posts on Instagram?

[@gptforwork]

Of course !

[@RodrigoCamarena-p7o]

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

[@gptforwork]

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

[@RodrigoCamarena-p7o]

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

[@gptforwork]

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

[@dougcallaghan6075]

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.

[@gptforwork]

Hi there. Do you know anyone who has a cellphone?

[@dougcallaghan6075]

@@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.

[@gptforwork]

@@dougcallaghan6075 it's just used for verification, they won't see anything

[@dougcallaghan6075]

@@gptforwork Thanks.

[@eldean0]

Does it work with GpT 4 now ?

[@gptforwork]

yes it does: gpt-4-turbo, gpt-4, from OpenAI or Azure

[@billardbenjamin6164]

I get errors when i use it! Do i need chat gpt 4?

[@gptforwork]

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

[@muslumyildiz5694]

thanks a bunch

[@gptforwork]

you're welcome

[@NewkFritz]

How many lines can it do?

[@gptforwork]

with our bulk tools, up to 200k rows in a single run works well. It will take ~10 hours.

[@cgc2300]

bonjour est-ce que cela fonctionne avec gpt4v?

[@gptforwork]

Bonjour! Oui vous pouvez utiliser GPT4 ainsi que d'autres modèles. Tous les modèles disponibles sont ici: gptforwork.com/help/supported-models

[@cgc2300]

@@gptforwork oui lorsque je suis dans mon playgroud je n'ai accès qu'à l'api du 3.5

[@aycadogan3417]

When I write "=gpt(A1,,1)" It gives an error. I dont know why

[@gptforwork]

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

[@fabricedemonaco6886]

Thanks you

[@gptforwork]

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

[@GirosDeLaVida-w7s]

Where do I send you money?

[@gptforwork]

haha thanks for the thought, we will release paid plans in the future to get access to even more awesome features ;)

[@gptforwork]

in the meantime, you can purchase our other products (see talarian.io) if they're useful to you!

[@spencerpawliw]

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!

[@gptforwork]

Hi Spencer, sent you an email, I think I found the solution with GPT_CREATE_PROMPT and FILTER

[@AO-uw2oq]

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

[@gptforwork]

you can use 2x :) but I will try to do better next time