How can I automate beautiful PDF report generation from Google Sheets?

Since you've chosen Python, you might want to try using libraries like fpdf2 or ReportLab to generate your PDFs directly. They offer flexibility in design and can handle charts if you generate them using another library. Take a look at Typst-py too; it just launched and could be useful for your needs. It might help you produce nice layouts with less hassle.

Your approach depends on how polished you want these reports. If they're just for internal use, you might mesh your Excel with VBA to create the PDF directly from there. But if you're set on using Python, you could think about generating a simple webpage with HTML and CSS, then exporting that to PDF. For ongoing reports, consider services like PDFBolt. It allows for quick document creation from templates, which could save you time.

It sounds like you need something straightforward but nice to look at! Given your needs—2-3 reports a week—using something like HTML/CSS for layout and then converting it to PDF might be your best bet. You’ll have easy control over formatting and visuals without needing to dive deep into complex programming. Just be sure to design for readability!