In order to utilize the Google Sheets Essbase Add-on, Google Sheets must be able to access the ExoInsight URL(s):
Your local networking team will be able to determine the best way to do this that aligns with your company’s GSuite security strategy.
At a minimum, the ExoInsight URL must be discoverable either directly, or through a web server designed to filter incoming traffic (recommended). This is typically done by whitelisting the standard set of Google IP addresses.
The list of Google IP addresses that need to be able to access the ExoInsight URL can be determined by running the following command from a command prompt on the ExoInsight server in the <installation directory>/casabase folder:
java -Xms512m -Xmx1024m -Dfile.encoding=UTF8 -cp "./*" Utils
It is highly recommended that SSL be turned on for ExoInsight. Please see the ExoInsight SSL Setup article for more information.