Power Formulas: Use ChatGPT & AI in Google Sheets

Product details

Q: Analyse data, giving insights and create charts

Before I want to buy your product, I would like to know if I can also ask questions in my prompt, like: when you see the data, which 25 insights can you give me?, and another prompt: there is a lot of data, can you visualise it for me to create charts for me?

So my question is: can I ask anything and can he give answers, insights and charts?

bezinningsvakantiesSep 18, 2024
Founder Team
Wei_Sheng

Wei_Sheng

Sep 19, 2024

A: Hi thanks for your question. With Power Formulas, you can indeed ask questions and receive answers, insights, but it can't generate charts for you. No AI product is able to generate charts accurately at the moment. Here’s how it works:

Asking Questions for Insights: You can prompt the AI using the =AI() function, allowing you to ask complex questions based on your data. For example, you could use a prompt like, "When you see the data, which 25 insights can you give me?" and Include the data in the AI prompt using the "context" paramter. This will allow the AI to analyze the specified data range and generate insights based on it.

Again, you can use the AI formula to generate text-based insights, but it can't generate charts, as no AI product is able to generate charts accurately at the moment.

Thanks.

Helpful?
Log in to join the conversation