How to control the execution of your GPT for Sheets functions

[@MohammedAli-tq8ln]

It's incredible how you are developing this extension and how useful are your videos. Thanks and keep it up

[@gptforwork]

Thank you, those messages help a lot! Please don't hesitate to leave a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654

[@MohammedAli-tq8ln]

@@gptforwork done ✅ Well deserved.

[@madhavojha9046]

This is just amazing how you used this function in the executions you made! BRAVO 👏👏 Thanks for this use-case, Stan. Also, Loved the complete playlist you provided ✌❣🙌🙌

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

[@UnapologeticallyAFChristinaRae]

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

[@Artazar777]

I would generate thousands of words of thanks in an excel spreadsheet for you, but youtube just won't let them through, so just thank you so much, for these lifehacks, they are awesome, just like your product

[@gptforwork]

thank you! don't hesitate to leave a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654

[@jthlau]

This is my life-saver, since I've 10K+ rows, with 20+ columns needed to execute a prompt. Before watching your video, I'm using a keyboard recorder software & set a time interval to separate the execution. And your video shows it's just an easy hack to solve my "pain" completely. Thank you so much.

[@gptforwork]

Awesome ! Would love to know what you do to these 200k cells !

[@FutureTechMarketing-ff9mr]

Thank you for making this plug-in. I wonder how many people have figured out how powerful it is. I'm making some pretty insane tools with it!!! Hopefully, once I understand how to implement this into my sheet it will fix my errors and crazy load times. Seriously, this plug-in is game-changing.

[@gptforwork]

We're happy to hear you love our product! don't hesitate to leave a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654

[@Hall]

Here is an example formula from the video: =if(B21"wait",GPT("continue this story by adding one sentence:",B21,1),"wait")

[@gptforwork]

Indeed!

[@moonisal]

Thank u from korea It is nice video, like how to utilize the formulas.

[@gptforwork]

Glad it was helpful!

[@ZepHiR021]

Great example of sequential computation! But if you're using a free API, it will start giving an error after 30-50 computations. To solve this issue, we had to add a script that introduces a 4-second delay between computations, but it's not a perfect solution because the script's execution time is limited to 6 minutes. Is it possible to set an interval through your solution without using scripts?

[@gptforwork]

Hi Mikhail, do you mean free OpenAI account? In this case yes the rate limit is 20 requests / minute, so you will get rate-limited quickly. To my knowledge, there is no way to add a delay without script. I encourage you to upgrade to a paid account because it is very cheap (cheaper than the time it takes to code a script :)) Best

[@ZepHiR021]

​@@gptforwork Agreed, we shouldn't be greedy and pay for a subscription ) But the script was also written by ChatGPT, so I wanted to get a completely free solution :))

[@keithhupp5995]

That is amazing!

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

[@AndriusMinkevičius]

Nothing fancy, but thanks, you saved some of my brain cells, so now I don't have to invent all this :)

[@gptforwork]

sure, happy to help!

[@manticyde]

I have a question, and it is partially on this segment and partially in regards to the GPT_FILL function. I am trying to essentially do some scraping of a particular page. All of the data is available in one spot, and it seems to work in smaller batches sometimes and not others. I can download the main contact list right from the page but it has everything but phone number and email for example. Hitting the view button on the page triggers that information on a new page. There are approximately 2000 entries though. The times it makes a handful of entries that seem correct it times out and just adds a line underneath after the 10 rows for example that says ...[continued for 1910 rows] with no actual data. Is it a time out or?

[@gptforwork]

Hello! for web scraping use cases, 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 If that doesn't help please contact our support team here: support.gptforwork.com/hc/en-us/requests/new

[@abdullahchaudary1445]

life saver!!!!

[@gptforwork]

We're glad to know you love our product! don't hesitate to leave a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654

[@VIDEOGRAFIKO]

this is useful when chaining

[@elcormusic]

#error! "Exceeded maximum execution time (line 0)." on every loading cells. Just after few executions everytime

[@Lstrader1]

same issue here

[@gptforwork]

Hello! There are 2 workarounds that we recently integrated to the addon to circumvent this type of error: 1. you can select an Azure model to run your formulas. Azure models are faster than other available models. 2. If you use GPT-4, you can enable the "GPT-4 safe mode" in the sidebar to bypass the 30-second runtime limit (gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/gpt4-safe-mode)

[@milehighseo]

I was able to use this technique (which is fantastic), but the formulas errored out after roughly 1000 rows of computations. Any thoughts on getting around that?

[@gptforwork]

hmmm I tried it with multiple thousand rows and it worked fine. could you please share your spreadsheet with me? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform

[@Salif467]

Im constantly getting the "Exceeded maximum execution time" error in google sheets and it gets much worst when i switch over to GPT 4. Is there a way to increase the time limit pass 30 secs? because right now it struggles to even write a 95 word answer without throwing this error.

[@gptforwork]

Hello! There are 2 workarounds that we recently integrated to the addon: 1. you can select an Azure model to run your formulas. Azure models are faster than other available models. 2. If you use GPT-4, you can enable the "GPT-4 safe mode" in the sidebar to bypass the 30-second runtime limit (gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/gpt4-safe-mode)

[@taac968]

Hi guys, Thanks for the video. However, I still get errors after 30-40 rows. Any ideas why this could be happening? I need to process 3000 rows and now I'm back to manual, because it's faster.

[@gptforwork]

Hello! There are 2 workarounds that we recently integrated to the addon: 1. you can select an Azure model to run your formulas. Azure models are faster than other available models. 2. If you use GPT-4, you can enable the "GPT-4 safe mode" in the sidebar to bypass the 30-second runtime limit (gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/gpt4-safe-mode)

[@almichael191]

I keep having bugs on this extension, do you have any email I could send the video of the sample bug. I would love to keep using this extension so long as it could be fixed.

[@gptforwork]

Hi Michael, I'm sorry you're having problems with the extension. As per the video description, please fill the following form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform and I'll try to help you

[@Ikerposcaart]

dont works

[@gptforwork]

could you be more precise? you can reach out here with more detail: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform