We’ve recently updated this so that it outputs the exact error so that you can learn & fix the issue yourself.
That being said, we typically see two types of errors…
Error #1: The model `gpt-4` does not exist or you do not have access to it
Fix: As of August 4, 2023, you fix this by going to your OpenAI billing settings and make sure you have a paid OpenAI account and paid at least $1 to OpenAI. If it’s not working, check the OpenAI help article on how to get GPT-4 access as this may be more up to date as they make changes.
Error #2: You exceeded your current quota, please check your plan and billing details
Fix: To fix this, go your OpenAI billing settings and make sure you have a paid OpenAI account and paid at least $1 to OpenAI. If it’s still not working, make sure you don’t have any quota settings as that may make you hit your limit.
If you’re still having trouble, please include a shareable link to your sheet in your support message so we can check the issue and let us know what error you’re seeing.
We’ll be fixing this issue soon.
For now, give your browser a hard refresh to reload the sheet and clear the browser cache. That should fix the issue.
By default, it will require each user to individually input an OpenAI API key. This helps prevent any accidental sharing of your API key in case someone shares the sheet with someone else outside of your organization.
No! These are completely free of charge and you can use them in an unlimited fashion 🙂
Most companies limit this, but there is unlimited use when you use SheetMagic!
Google Sheets has a hard limit of 30 seconds for each function to run, so we limited the responses to only include 800 tokens so that it does not timeout. If you’re trying to create huge 2,000+ word responses, it will not work because it takes too long and it will cause an error because of the Google Sheets limit.
If you want a long response, we recommend doing it step by step in different cells and combine them in the end using the =CONCAT() function
SheetMagic requires an OpenAI key to use it, so you’ll need to attach your API key regardless.
Whether you’re using GPT-3.5 or GPT-4, you’ll need an OpenAI key no matter what.
Even if you have ChatGPT account or ChatGPT plus, you’ll still need to attach your OpenAI key.