You need to deploy your apps script and put that url in http module in make.com. Please check this reference to run apps script in make automation.
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel