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!

A: Hi yes, you can connect to OpenRouter to use different AI image models with our =API() formula. The OpenRouter API allows you to interact with various AI models using a consistent request format similar to the OpenAI Chat API.

To get started, you'll need to obtain an API key from OpenRouter. Once you have your API key, you can create requests to the OpenRouter API endpoint, specifically to /api/v1/chat/completions for generating model responses.

Here's an example of how to structure your request using the =API() formula in Google Sheets:

=API("POST", "https://openrouter.ai/api/v1/chat/completions", {
"headers": {
"Authorization": "Bearer <YOUR_OPENROUTER_API_KEY>",
"Content-Type": "application/json"
},
"body": JSON.stringify({
"model": "your_selected_model",
"messages": [{
"role": "user",
"content": "What image would you like to generate?"
}]
})
})
Make sure to replace <YOUR_OPENROUTER_API_KEY> with your actual key and define "your_selected_model" according to the models available in OpenRouter. Remember to check the OpenRouter API documentation for a complete list of supported models and parameters you can use in your requests.
Here to get Openrouter API key https://openrouter.ai/keys
This setup should enable you to generate images and other content as needed from various AI models available through OpenRouter. If you need further assistance, feel free to ask!