How do you send weekly reports to customers?

Hey IndieHackers!

While working in my previous role at a SaaS startup we struggled to find a tool to send weekly product usage reports to our customers. We didn't want to build it ourselves and looked for paid solutions but could only find tools aimed at bigger guys. We ended up doing it by hand in Google DataStudio, exporting to PDF and just sending them via email, which was very time-consuming.

Was wondering do you send weekly email reports to your SaaS customers? If so, how do you do it?