How do you generate an automatic report every week that will pull me data from last week?

Hey friends

I am trying to produce an automatic report that goes out to the client every week on the progress of the campaigns.

In the first step - I want to withdraw all the “spend” from the Google and Facebook campaigns.

I can’t figure out how to do it, I’d appreciate a short tutorial please. Thank you!