You can now manage the cache of GPT for Sheets in order to decide:
- if you want easy quick experimentation and get different results for the same command, for example by simply dragging your formula
- or if you want to prevent the same command from incurring OpenAI cost every time.
You can only cache up to 900 executions, and the cache will auto-expire after roughly 6 hours
You can enable or disable the cache from the sidebar:
Extensions > GPT for Sheets and Docs > Launch & Enable functions > Control GPT formulas > Manage cache