Power Formulas: Use ChatGPT & AI in Google Sheets Questions

Showing 1 - 20 of 138 questions

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.

lourenco.azevedoJan 2, 2025
See detail
Founder Team
Wei_Sheng

Wei_Sheng

Jan 3, 2025

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

Q: openrouter?

are you planning to add openrouter anytime soon?

102523093343677681485Dec 22, 2024
See detail
Founder Team
Wei_Sheng

Wei_Sheng

Dec 26, 2024

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

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.

guillaume.hDec 16, 2024
See detail
Founder Team
Wei_Sheng

Wei_Sheng

Dec 17, 2024

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

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?

matteo77PLUSNov 22, 2024
See detail
Founder Team
Wei_Sheng

Wei_Sheng

Nov 25, 2024

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

Q: Book Keeping Option

Is it possible to upload your purchases and Have it turn into a Book Keeper and automatically classify and adjust purchases like a bookkeeper?

dallas49Nov 11, 2024
See detail
Founder Team
Wei_Sheng

Wei_Sheng

Nov 12, 2024

A: Hi, thanks for your question. But I'm afraid this is beyond Power Formulas' capability. Power Formulas provides features that allow you to conenct to AI, API and databases, and there is no book keeping features at the moment.

Share
Helpful?