[GNC] Getting GEMINI to email statements (account reports) to customers.

[Adrien Monteleone]

Your best bet would be to ditch the bot, switch the backend of your file 
to use SQLite so you can use queries, or, investigate using the Python 
bindings for your automation.

I'm fairly certain there is a thread here on the list within the last 
few years of someone doing exactly what you are attempting. (it rings a 
bell) If they didn't already share the specific steps and/or code in the 
thread, they may be willing to do so.

I can certainly say there is someone on here who has mentioned an 'app' 
which is essentially a visual macro writer that you use to record clicks 
and data entry, and it simply repeats the process. I think I have it 
flagged somewhere in this giant pile of threads, so I'll shuffle around 
for it, but it is indeed here somewhere. That may not be the best 
solution, but it would save you having to learn/write SQL queries or Python.

Regards,
Adrien

On 2/26/26 6:19 PM, David Long wrote:
> I was able to get Gemini to e mail contents for a single customer (one at a
> time), but it saves no work  It would though if it could work through a
> batch of account reports which I would save on a folder in Google Drive in
> PDF format with minimum interaction from myself.
> Anybody any experience of this with Gemini or any other AI tool?
> What Gemini does is extract infomation from the customer report and put it
> into an e mail after matching the name with my contacts. Probably if I
> included the e mail in customers address it would not need to look up my
> contact details.
> Would like to automate the process.