Score:0

Can Google Virtual Private Cloud be used to give a GAS project access to resources inside a corporate network?

in flag

By default, a Google Apps Script project cannot access a resource (like an API or a DB using JDBC) inside a corporate network. The company would have to put holes in their firewall for the GAS servers to be able to connect to those internal resources.

But since all GAS projects run on the same Google servers, using the same APIs, putting holes in the firewall means that ANYONE, including GAS projects outside the organization's G-Suite enterprise account, can access the resource inside the corporate network.

If we created a VPC between Google and our corporate network, would that allow only GAS projects in our G-Suite Enterprise organization to access internal resources?

Abhijith Chitrapu avatar
tr flag
Could you please up-vote/accept if my solution is useful to you!
Score:0
tr flag

GAS is meant for light-weight application development as part of G-Suite. But GCP recommends using GCP projects.

Since you want to connect to On-premise Network it's mainly on how you use it instead of what you are using. Simply add an IP range in your Database to exclude GAS IP(as you said holes). If you want to connect to other services then you can connect from any cloud node to On-premise Network; if you have authentication or firewall that doesn't restrict that IP.

Else, you can connect from any application(any IP) with pre-registered credentials that are generated on an on-premises network server like JWT authentication.

Abhijith Chitrapu avatar
tr flag
@IMTheNachoMan Could you please update regarding your issue.
in flag
Hello. This doesn't really answer my question. I am specifically asking about a GAS project (even if its using a standard vs default GCP project) connecting to an on-prem resource without putting holes in our FW. I don't want to put holes in the FW as that would be very bad.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.