Power Formulas: Use ChatGPT & AI in Google Sheets

Product details

Q: Can I/how can I set the defaults so I can make the calls to use this coding easier, example, now is makes me ...

do something like this:
=AI(B2, "gpt-4",, 0, A2,, false)
But I want to have the same settings each time, just changing the prompt and the content to action on the prompt, the B2 and A2 in this example, meaning I'd like to ideally just be able to do:
=AI(B2, A2)
We used GPT for Sheets and that was what we did using that, as we just set the defaults for all the other values, and the system knew the 1st value was the prompt, 2nd value is the value for the prompt, others that left empty used the default values.

Would LOVE LOVE LOVE if it you could do that for us with your tool, just so we can really optimize the process, without having to open/remember all your ,'s and values in the strings.

ctevnPLUSFeb 5, 2024
Founder Team
Wei_Sheng

Wei_Sheng

May 15, 2024

A: Hi, thanks for your question. The parameters, including models and temperature, are essential to fine control the final response fro OpenAI. I understand that is it tedious to type them every time. You can either use our Formula Helper(from the sidebar) to help you generate the formula or use the pull-down feature in Google Sheets to automatically populate the formulas in a column. Meanwhile, I will definitely look into the default setting feature and see how we can impletment it. Best wishes, Wei

Share
Helpful?
Log in to join the conversation