How frequently does the letter o appear in:
Q: IP Restrictions are not allowing the use of Google Sheets SF Add-On Data connector for Salesforce So we enabled IP Restrictions for various profiles. One of our users uses the Google Sheets SF Add-On and cannot log in to SF when there is IP restrictions (even though they are on the correct IP network). I troubleshooted this by removing the IP Restrictions from their profile and once I did, the user is able to log in to SF on the Google Sheet SF Add-On.
The Add-on is Data connector for Salesforce:
https://gsuite.google.com/u/0/marketplace/app/data_connector_for_salesforce/857627895310?hl=en&pann=sheets_addon_widget
What is going on here? What is the work around so that we can keep the IP restriction.

A: This is a simple fix using a few quick steps:


*

*Reinstate the IP Restrictions on the Users Profile

*Have the user attempt to OAuth the Data Connector for Salesforce through Google sheets (they should get an error, we want that)

*Navigate to the Users page in Salesforce, and scroll down to Login History, you should see something akin to the below:





*Fetch the IP from the failed login attempt and whitelist that.


**Note: its very likely that the IP you end up whitelisting right now isnt the only one that could / will be used by the Data Connector, so you may need to repeat this intermittently as they run into the issue again.

user
I counted 104 "o"s in that text.
assistant