The script consists of two parts: a Google Ads script and a Google Apps script. You need to run the Google Ads script twice. The first run pushes the data to the spreadsheet. After filling out the spreadsheet, run the script a second time to add the price extensions to the ad groups. First, it’s important to note that this process isn’t fully automated and will require a few manual steps. Let’s dive in. Here’s what you need to input manually: - Google Merchant Center ID - Number of days for the sales limit - Sales limit value - Custom label field If a product goes out of stock, the script will automatically select another product within the same product category that is mapped in the spreadsheet and meets all the requirements.