Need help getting the port that Google Sheet use to talk to App Script server

[Patompong Savaengsuk]

Hi all,

First time here as I'm stuck. A bit of background, we're creating an add-on on Google Sheet.

The problem is that we're required to provide the port that Google Sheet use to talk to the App Script server to our service provider (this supposed to be an internal port in a private network). I've been looking into this and I can't find any info about how I can do that.

Does anyone know what port they're using to talk to each other? Or does Google have a range of port that Google Sheet use to talk to App Script server?

Thank you in advance!

Pond

[Kim Nilsson]

That sounds like a question based on some incorrect assumptions.

All of the traffic happens on Google's servers.

None of it on your system or servers.

[Bruce Mcpherson]

Yes - but if talking to another service (from a google server), it's possible that the service insists on whitelisting particular ip addresses - or perhaps domains. As far as the port is concerned, surely that would be the service being accessed that would be defining that.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/f6c6b75a-2650-4c5f-94fb-9410b654e29dn%40googlegroups.com.

[Patompong Savaengsuk]

Hi Kim,

Thanks for the reply!

I understand that none of that is on our system/servers. I'm focusing on seeing Google Sheet as a client and App Script as the server. We can see that the script on Google Sheet talks to the App Script server internally, but we can't see which port they're using to talk to each other. That's what I'm trying to acquire so we can send it to our service provider as a fraud prevention matter.

I doubt if that's even possible, but want to ask here first to make sure.

[Patompong Savaengsuk]

Agreed.

Although Google should have a page where they list a range of IP address that they use for App Script server, no? Or maybe their cloud IP got changed all the time and doesn't have a specific range?

[dimud...@gmail.com]

This might help:

https://webmasters.stackexchange.com/questions/24103/what-ip-address-range-do-urlfetch-queries-come-from

[Patompong Savaengsuk]

Thank you, it's helpful.

The IP range is no longer on that page. However, there is a link to this page which contains the list of IP to be whitelisted https://www.gstatic.com/ipranges/goog.txt

[CBMServices Web]

All of apps script and Google docs functionality runs on the Google servers. The only ports you should need on your side is the http/https ports to be opened.

They may use ftp/sftp ports as well for downloading any attached files if you have that capability being used.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/3bdf6a87-b0db-48ca-b150-ef9715dfb623n%40googlegroups.com.

[Patompong Savaengsuk]

Thank you George for the reply :)

I'll update our provider.

[Crypto Minh]

hello, can you solve your problem? can you check your Google App Script IP address ? or can you specify Urlfetch run on specific IP service ?

Thank you