I just bought the APP and am trying to connect to Straico, unfortunately your instructions don't really help me. Can you tell me how I have to enter this under API so that Straico is connected?
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:
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!
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
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!
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Client sends wsp message x day we get timestamp he wants to do x our data days x takes 30 days client received reminded ever x days to remind him he only has x days to do this
A: Hi thanks for your question. Power Formulas is designed specifically as an AI tool to enhance functionality within Google Sheets, rather than for direct automation purposes. If you're looking for automation features, I recommend exploring Logic Sheet, which is also available on AppSumo. Logic Sheet offers more extensive capabilities for automating tasks based on data and can be a better fit for your requirements. If you have any other questions or need further assistance, feel free to ask!
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
A: Hi thanks for reaching out. Power Formulas supports OpenRouter via its API, you can set up connections using the OpenRouter API and our =API() formula to connect to all the AI models it supports. Let me know if you need more help! Wei
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Does this work with gemini 2.5?
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Straico Anleitung API
Hello,
I just bought the APP and am trying to connect to Straico, unfortunately your instructions don't really help me.
Can you tell me how I have to enter this under API so that Straico is connected?
Wei_Sheng
Jun 26, 2025A: 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!
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Can it connect to openrouter to use different ai image models?
Wei_Sheng
May 8, 2025A: 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!
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Can I automate based on data
Client sends wsp message x day we get timestamp he wants to do x our data days x takes 30 days client received reminded ever x days to remind him he only has x days to do this
Wei_Sheng
May 8, 2025A: Hi thanks for your question. Power Formulas is designed specifically as an AI tool to enhance functionality within Google Sheets, rather than for direct automation purposes. If you're looking for automation features, I recommend exploring Logic Sheet, which is also available on AppSumo. Logic Sheet offers more extensive capabilities for automating tasks based on data and can be a better fit for your requirements. If you have any other questions or need further assistance, feel free to ask!
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Can we use any ai open router Claude etc use API webhooks etc?
Wei_Sheng
Apr 28, 2025A: Hi thanks for reaching out. Power Formulas supports OpenRouter via its API, you can set up connections using the OpenRouter API and our =API() formula to connect to all the AI models it supports. Let me know if you need more help! Wei
Share Power Formulas: Use ChatGPT & AI in Google Sheets