Google Apps Script runs on Google’s servers. Most corporate firewalls will block random inbound requests. That means Google Apps Script cannot connect to internal APIs or DBs.
All Google accounts across the world use the same pool of server IPs. So you can’t just whitelist the IPs cause that would allow anyone in the world to connect to the internal APIs/DBs (even if they can’t authorize to it).
Using an API proxy is a challenge because most require 2-way SSL which Google Apps Script does not support.
We’ve got thousands of folks creating numerous GAS projects. They all use the default GCP project. It would be unmanageable for our internal Google admins to create GCP projects for every user/project for them to use with their GAS project.
GAS is one of Google’s best products/services bar none. But not being able to connect to internal corporate resources is a killer. If we could solve this, it would be a game changer.
I am curious if other companies have this issue and/or how they solved it?