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?
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 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
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
I have a list Reddit URL's in a column. Can your software loop through each one automatically, scrape all the comments on the page, and post it into a Google Sheet or Google Doc?
Here is an example link I would like to scrape: https://old.reddit.com/r/phoenix/comments/1ecbyo2/ac_unit_went_out_any_advice_would_be_appreciated/
Thanks for your question about scraping Reddit with Power Formulas. Unfortunately, Power Formulas doesn't have the capability to scrape web pages directly. Instead, it allows you to include page content within an AI formula, which can be useful for certain tasks but doesn't extend to automated scraping of comments from specific web pages like those on Reddit.
If you have any more questions about what Power Formulas can do, feel free to ask!
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: output to single cell cs output horizontal, vertical, table
Do you have plans to extend the output of your AI formular beyond a single cell? Some tools allow to query GPT to return a table or a bullet list and for those to be automatically places into a google sheets table, column or row and I find that very helpful! Thanks
A: Hi, we are currently developing new formulas like AI_LIST, AI_JSON, and AI_TABLE that will do exactly the same as you have described. Please stay tuned!
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Can we use NeuronWriter and other similar dedicated Ai platform to generate content using PowerFormulas in Google Sheet similar to offered by AahSheet?
A: Hello! Thanks for your question, Power Formulas currently does not integrate directly with NeuronWriter or similar dedicated AI platforms for content generation. Instead, it allows you to leverage AI models such as OpenAI’s GPT-4, Anthropic's Claude, Google AI, and Cohere to create content directly within Google Sheets using functions like =AI().
So while you can use Power Formulas to generate content based on your spreadsheet data, it won't function as a bridge to other dedicated platforms like NeuronWriter. However, you could input the data from those platforms into Google Sheets and then apply Power Formulas to generate or refine content using the supported AI models.
Let me know if you have any further questions or need additional information!
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Hello, Could I have a Power Formula automatically calculate numbers from a form or email leads which then I can place the results from the formula into a nice looking grid with four rows and columns? Thank you
A: Thank you for your question! Unfortunately, Power Formulas is not designed to calculate numbers. Instead, Power Formulas is a Google Sheets addon that primarily allows users to connect to AI or APIs, and even SQL databases, to streamline data processing and analysis within Sheets. Let me know if you have other questions! Wei
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Workflow: 1. I provide the product link in Gsheets (column a) 2. It gathers the following data columns -Manufacturer -Product Name -Price -Features -Description -Specs -Download product images and video to Gdrive folder for each product.
Not every product has these specific fields of information so it would be up to an AI model to decide where to fill in each column of information.
A: Hi, if there is one single page that contains all the information, it is possible to as the AI model to extract informaiton such as Manufacturer and price. However, it is not possible to download product images and videos to Gdrive with Power Formulas. THanks
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
the new Open AI models like o1 and o3 mini are missing and for Vision o1 is really imporant? When do you update?
Also could you please integrate Perplexity API? So we can use Websearch with that?
Else I think i need to refund with these outdates Modells.
A Bonus would be Straico and this should be fairly easy to integrate and with one api call you call alsways have all models like perplexity, gemini and all with one API:
A: Hi we are testing the new models from OpenAI and these models will be available in our next update. We will look into Perplexity and Straico and see if they fit into our AI formula. For now, you can use the =API() function to connect to these APIs.
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
A: Hi, these services are supported by our =API() formula and not inclided in the AI formulas. It's possible to call these services using the API formula following their documentations.
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Is there training for those of us who are newbies?
Hi Wei_Sheng Looks super. Being a newby, is there training to support our understanding of the possibilities of using power formulas. I don't know what I don't know. Cheers Mark
A: Hi, all our product can be easily followed using the help articles here https://help.powerformulas.co/. It is very straightfoward to use Power Formulas and the functions are just any other Google Sheets functions.
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Can it generate google appscript code for the task i desire based on the sheet context for e.g. if i have a sheet of some product usage day by day of users then can i ask ai to create different types of analysis on it and create charts plus do some automation by generating google script code with this?
A: Hi, thanks for your question. Power Formulas is mainly used to analyze data or generate content in Google Sheets using AI. Theoratically you can use the AI formulas to generate google appsscript code, but it's not as efficient as other chat based AI tools.
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Greetings, it possible to compare several Sheets. For example if I make two surveys and put them in two sheets can I ask questions like "what comom emails are in the both sheets?". Thanks in advance.
A: Hi it is possible if the data is in another sheet/tab in the same spreadsheet file, you can reference data in different sheet using cell reference in the formula.
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
A: Hi openrouter is not an AI service, it is a routing service for AI models, which is essentially the same as what Power Formulas is capable of in Google Sheets, so we will not support openrouter. Thanks.
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Can I use an image in Google Sheet for the AI to describe?
Hello,
I have a question before buying your tool. In Google Sheet, I can add images via a URL for example. I would like to know if I can use this image or several images in my case, to ask the AI like Claude to describe the image to me. While adding a prompt next to it in order to get something precise, but this point is the base, so I have no doubt about it. Thank you.
A: Hi, yes, this is possible with our =AI_VISION() function, which allows you to include the URL of a image and let AI describe the image. Currently it is available via OpenAI, but we will add support for other language models.
Share
Share Power Formulas: Use ChatGPT & AI in Google Sheets
can i use it only from my google account? how can i allow my programmer to use gpt for sheets on my spreadsheets remotely without him having to log in to my google account?
A: Hi thanks for your question. The license is applied to the actual "user" of the function, so if you have a license, when you create a spreadsheet and share it with someone without a licence, they will not be able to use Power Formulas. However, if you create the AI function and share the sheet, other people will be able to see the results.
Share
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?
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 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 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
Q: Scraping Reddit
I have a list Reddit URL's in a column. Can your software loop through each one automatically, scrape all the comments on the page, and post it into a Google Sheet or Google Doc?
Here is an example link I would like to scrape: https://old.reddit.com/r/phoenix/comments/1ecbyo2/ac_unit_went_out_any_advice_would_be_appreciated/
https://www.reddit.com/r/phoenix/comments/1ecbyo2/ac_unit_went_out_any_advice_would_be_appreciated/
Wei_Sheng
Apr 14, 2025A: Hi there!
Thanks for your question about scraping Reddit with Power Formulas. Unfortunately, Power Formulas doesn't have the capability to scrape web pages directly. Instead, it allows you to include page content within an AI formula, which can be useful for certain tasks but doesn't extend to automated scraping of comments from specific web pages like those on Reddit.
If you have any more questions about what Power Formulas can do, feel free to ask!
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: output to single cell cs output horizontal, vertical, table
Do you have plans to extend the output of your AI formular beyond a single cell? Some tools allow to query GPT to return a table or a bullet list and for those to be automatically places into a google sheets table, column or row and I find that very helpful!
Thanks
Wei_Sheng
Sep 9, 2024A: Hi, we are currently developing new formulas like AI_LIST, AI_JSON, and AI_TABLE that will do exactly the same as you have described. Please stay tuned!
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Verified purchaser
Exciting :)
Verified purchaser
Hello Wei, I wanted to check-in if there has there been any progress with those functions? Thank you
Q: Is it possible to rewrite a text from a specific field, based on a prompt that describes the Tone of Voice?
That would be great!
Wei_Sheng
Mar 22, 2025A: Hi yes, this is possible with our AI function, you just need the right prompt to concatenate all these fields and ask AI to rewrite the texts.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Can we use NeuronWriter?
Can we use NeuronWriter and other similar dedicated Ai platform to generate content using PowerFormulas in Google Sheet similar to offered by AahSheet?
Wei_Sheng
Mar 18, 2025A: Hello! Thanks for your question, Power Formulas currently does not integrate directly with NeuronWriter or similar dedicated AI platforms for content generation. Instead, it allows you to leverage AI models such as OpenAI’s GPT-4, Anthropic's Claude, Google AI, and Cohere to create content directly within Google Sheets using functions like =AI().
So while you can use Power Formulas to generate content based on your spreadsheet data, it won't function as a bridge to other dedicated platforms like NeuronWriter. However, you could input the data from those platforms into Google Sheets and then apply Power Formulas to generate or refine content using the supported AI models.
Let me know if you have any further questions or need additional information!
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: replace a calculator at Jotform
Hello, Could I have a Power Formula automatically calculate numbers from a form or email leads which then I can place the results from the formula into a nice looking grid with four rows and columns? Thank you
Wei_Sheng
Mar 18, 2025A: Thank you for your question! Unfortunately, Power Formulas is not designed to calculate numbers. Instead, Power Formulas is a Google Sheets addon that primarily allows users to connect to AI or APIs, and even SQL databases, to streamline data processing and analysis within Sheets. Let me know if you have other questions! Wei
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Scraping product data
Can this be use to accomplish the following?
Workflow:
1. I provide the product link in Gsheets (column a)
2. It gathers the following data columns
-Manufacturer
-Product Name
-Price
-Features
-Description
-Specs
-Download product images and video to Gdrive folder for each product.
Not every product has these specific fields of information so it would be up to an AI model to decide where to fill in each column of information.
Wei_Sheng
Mar 4, 2025A: Hi, if there is one single page that contains all the information, it is possible to as the AI model to extract informaiton such as Manufacturer and price. However, it is not possible to download product images and videos to Gdrive with Power Formulas. THanks
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Update to Models and Perplexity?
Hi,
the new Open AI models like o1 and o3 mini are missing and for Vision o1 is really imporant? When do you update?
Also could you please integrate Perplexity API? So we can use Websearch with that?
Else I think i need to refund with these outdates Modells.
A Bonus would be Straico and this should be fairly easy to integrate and with one api call you call alsways have all models like perplexity, gemini and all with one API:
Wei_Sheng
Feb 14, 2025A: Hi we are testing the new models from OpenAI and these models will be available in our next update. We will look into Perplexity and Straico and see if they fit into our AI formula. For now, you can use the =API() function to connect to these APIs.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Straico and Openrouter coming?
Wei_Sheng
Feb 7, 2025A: Hi, these services are supported by our =API() formula and not inclided in the AI formulas. It's possible to call these services using the API formula following their documentations.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Is it possible without BYOK? If yes what is the limitation?
question see above
Wei_Sheng
Jan 29, 2025A: Hi, Power Formulas is a BYOK product and you have to provide the corresponding API key to use the AI models.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Is there training for those of us who are newbies?
Hi Wei_Sheng
Looks super.
Being a newby, is there training to support our understanding of the possibilities of using power formulas. I don't know what I don't know.
Cheers
Mark
Wei_Sheng
Jan 27, 2025A: Hi, all our product can be easily followed using the help articles here https://help.powerformulas.co/. It is very straightfoward to use Power Formulas and the functions are just any other Google Sheets functions.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Google Script code
Can it generate google appscript code for the task i desire based on the sheet context for e.g. if i have a sheet of some product usage day by day of users then can i ask ai to create different types of analysis on it and create charts plus do some automation by generating google script code with this?
Wei_Sheng
Jan 14, 2025A: Hi, thanks for your question. Power Formulas is mainly used to analyze data or generate content in Google Sheets using AI. Theoratically you can use the AI formulas to generate google appsscript code, but it's not as efficient as other chat based AI tools.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: API integration
Is this possible with one Code plan to integrate and schedule 3 part API?
There is any limitation in the usage from Powerformulas API?
I need to integrate Outscarper API and schedule it
Thank you in advance
Antonio
Wei_Sheng
Jan 9, 2025A: Hi there is no limit on the use of API requests. One code will enable all spreadsheets in one Google account to use Power Formulas.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Presale question
Greetings, it possible to compare several Sheets. For example if I make two surveys and put them in two sheets can I ask questions like "what comom emails are in the both sheets?". Thanks in advance.
Wei_Sheng
Jan 3, 2025A: Hi it is possible if the data is in another sheet/tab in the same spreadsheet file, you can reference data in different sheet using cell reference in the formula.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: openrouter?
are you planning to add openrouter anytime soon?
Wei_Sheng
Dec 26, 2024A: Hi openrouter is not an AI service, it is a routing service for AI models, which is essentially the same as what Power Formulas is capable of in Google Sheets, so we will not support openrouter. Thanks.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: Can I use an image in Google Sheet for the AI to describe?
Hello,
I have a question before buying your tool.
In Google Sheet, I can add images via a URL for example. I would like to know if I can use this image or several images in my case, to ask the AI like Claude to describe the image to me.
While adding a prompt next to it in order to get something precise, but this point is the base, so I have no doubt about it.
Thank you.
Wei_Sheng
Dec 17, 2024A: Hi, yes, this is possible with our =AI_VISION() function, which allows you to include the URL of a image and let AI describe the image. Currently it is available via OpenAI, but we will add support for other language models.
Share Power Formulas: Use ChatGPT & AI in Google Sheets
Q: shareable usage questions:
can i use it only from my google account? how can i allow my programmer to use gpt for sheets on my spreadsheets remotely without him having to log in to my google account?
Wei_Sheng
Nov 25, 2024A: Hi thanks for your question. The license is applied to the actual "user" of the function, so if you have a license, when you create a spreadsheet and share it with someone without a licence, they will not be able to use Power Formulas. However, if you create the AI function and share the sheet, other people will be able to see the results.
Share Power Formulas: Use ChatGPT & AI in Google Sheets