Is there a way to generate comments using LLM?

I'm looking to integrate a LLM-based language model to automatically generate comments on charts. The process can be run monthly on specific dates.

Is there a way to apply any integration or dynamically connect the dashboard with a Python script that inputs the chart's data and runs a prompt linked to the LLM API?

Solved Solved
0 1 1,018
1 ACCEPTED SOLUTION

@mbmabadie 
As of now there is no way of retrieving data from dashboard using APi meaning you cannot use Python to read your exact data from Looker Studio directly.
Instead you can try to connect with BiGquery dataset or wait until Google Ships its new feature which is going to be a gemini connected to Looker Studio. But its capabillities are still unclear for most of us but Google Employees.

A solution you could use is a multimodal Gemini reading and interpreting a data from PDF. I would rather not expect anything really deeply advanced but it has some decent capabilities in reading PDFs and images and parsing data into JSON or summarizing as text.

It would be a definitely fun development process but not sure what kind of outcome you expect.

Here you can read about Gemini multimodal  model:
https://cloud.google.com/vertex-ai/generative-ai/docs/multimodal/image-understanding

Try Vertex Ai and test first before you go too deep into development without clearly seeing results.

View solution in original post