Power Formulas: Use ChatGPT & AI in Google Sheets Questions

A: HI, the API connector can connect to any API endpoint. You can read instructions from your desired API and see how to connect using Power Formulas.

A: Hi, our help center (https://help.powerformulas.co/) has all the resources you need to get started with Power Formulas. You can also use the live chat on our website to reach out to us for more help.
Wei

A: Hi yes, we are adding support to the lastest AI models.

A: HI here is how to use Power Formulas for the prompt completion API of Scraico.

Prepare your API key:
Make sure you have your Straico API key.

Format your request:
Use the following formula in Google Sheets, replacing the placeholders as needed:

=API(
"POST",
"https://api.straico.com/v1/prompt/completion",
"Authorization=Bearer YOUR_API_KEY,content-type=application/json",
"{""models"": [""model-1-id""], ""message"": ""Your prompt text""}"
)
Replace YOUR_API_KEY with your actual Straico API key.
Replace model-1-id with the ID of the language model you want to use (refer to your Straico documentation for valid model IDs).
Replace "Your prompt text" with your actual prompt/question.
Advanced options:
To add optional features (like file URLs, images, YouTube URLs, temperature, or max tokens), expand your JSON request body accordingly. For example:

=API(
"POST",
"https://api.straico.com/v1/prompt/completion",
"Authorization=Bearer YOUR_API_KEY,content-type=application/json",
"{""models"": [""model-1-id""], ""message"": ""Your prompt text"", ""temperature"": 0.7, ""max_tokens"": 256}"
)

Notes:

The JSON in the formula must have all double quotes escaped by doubling them ("").
You can specify up to 4 models in the models array if you want completions from multiple models.
If you want to use the smart selector, replace the models key with smart_llm_selector.
If you need help formatting a more complex request or have an error/response you want help with, just let me know!