Integrate Google Ads API with Zapier with Custom Action

Description

I'm trying to set up a Zap in Zapier that pulls the "Cost" metric from a Google Ads account every hour and inserts it into a Google Sheet. I believe this can be done using a "Custom Action" in Zapier using the Google Ads API.
A couple of bits to note:
- The Google Ads account is an MCC account that has multiple customer accounts in it. I only want to pull metrics from specific accounts.- I will need to be able to duplicate the Zap and change the Google Ads customer ID to pull other accounts.