This change provides an example workaround to this problem using Google Ads Scripts. The solution is still mostly controlled from the Google Sheet, the fetch logic remains the same. However, instead of pushing the changes to the Ads API, Ads script can be scheduled to run an hour later to read the activation formula and apply the changes.
The Google Ads API doesn't support mutating video campaigns.
This change provides an example workaround to this problem using Google Ads Scripts. The solution is still mostly controlled from the Google Sheet, the fetch logic remains the same. However, instead of pushing the changes to the Ads API, Ads script can be scheduled to run an hour later to read the activation formula and apply the changes.