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.