Pulling Email Reports from Automation going to our Google Sheet, is this possible with Zapier?

Wanted to pull out some reporting from our Email Campaign and want it to send in our Google sheet, is there anyone who knows how to integrate this stuff through Zapier? would really be happy to know more about this.