Power Formulas: Use ChatGPT & AI in Google Sheets Questions

Showing 1 - 20 of 136 questions

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?

Q: 2 quick presale questions

1) Can PowerFormulas do everything that another AppSumo tool – Apipheny – can do in regards to handling/integrating APIs and sending/receiving API requests with Google Sheets?

2) Is there an easy way to use my Straico API key with PowerFormulas (similar, to how I'd be able to use my OpenAI API key) – without having to manually insert it every single time?

Thanks!

VikingfinityPLUSNov 11, 2024
See detail
Founder Team
Wei_Sheng

Wei_Sheng

Nov 12, 2024

A: Hi thanks for your questions.
1. Power Formulas provides an =API() formula which allows you to connect to an API using the formula interface. However, it is not as sophisticated as Apipheny, because it can't handle OAuth connections. For a full Apipheny alternative, please check our other product Uniquery. However, it is not on Appsumo.
2. Regarding the usage of the Straico API key with Power...

Share
Helpful?

Q: What if I don't Have an openai api?

sokhonNov 10, 2024
See detail
Founder Team
Wei_Sheng

Wei_Sheng

Nov 12, 2024

A: Hi, thanks for your question. Power Formukas needs you to provide your own API for the AI usage. There is no AI credits. If you don't have an OpenAI API key, you can use Google, Cohere, Claude instead, as they are well supported by Power Formulas.

Share
Helpful?