You can use a content tree workflow to activate the content. To automate this, we can create a batch or Groovy script to call the workflow using the payload used in your content set. The script will make the curl call to the workflow. In the below example batch script, it accepts the input.txt which contains the path added in content sets.
set "inputFile=input.txt"
set "outputFile=output.txt"
set "curlURL=https://aem-author-url/etc/workflow/instances"
set "token=Your Token"
for /f "tokens=*" %%a in (!inputFile!) do (
set "payload=%%a"
echo Sending payload: !payload! >> !outputFile!
curl -H "Authorization: Bearer !token!" -d "model=/var/workflow/models/adobe-publish-content-tree&payloadType=JCR_PATH&payload=!payload!" !curlURL! >> !outputFile!
echo Delaying for 15 minutes...
timeout /t 900 >nul
) To call the workflow via curl you need to pass the token which can be generated from the developer console of the respective environments - https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/implementing/developing/generating-access-tokens-for-server-side-apis#developer-flow .