Power Formulas: Use ChatGPT & AI in Google Sheets

Product details

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?

info3110PLUSJun 14, 2025
Founder Team
Wei_Sheng

Wei_Sheng

Jun 26, 2025

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!

Share
Helpful?
Log in to join the conversation