Automating a task and understanding it are not the same skill, and skipping straight to the first one usually backfires.

I've watched people automate a report before ever manually building it once and the automation just encodes whatever mistake was already baked into the process. The manual version is where you find the edge cases. The automated version is where you scale them.

Do it by hand once before you let a script do it forever.