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
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