To let G-Connector correctly work with your Salesforce.com org when you are offline, the G-Connector app needs to be installed and you need to make sure some app policies are adjusted correctly.

To do it, go to Setup – Connected Apps oAuth Usage and click on Manage App Policies next to G-Connector:

If the app is not installed, click on Install to make it available in your Salesforce org.

Then make sure that the refresh token is valid until revoked and the IP restrictions are set to “Relax IP Restrictions”:

You will then need to perform the following steps to clear all your legacy settings:

  1. Click Add-ins -> G-Connector for Salesforce -> Schedule Automatic Data Operations -> Other Settings -> Reset Spreadsheet Settings.
  2. Click Add-ins -> G-Connector for Salesforce -> Schedule Automatic Data Operations -> Other Settings -> Reset All Settings.
  3. Log back in.
  4. Re-schedule your automatic refresh job(s) by clicking on Add-ins -> G-Connector for Salesforce -> Schedule Automatic Data Operations and clicking Apply in that dialog box.

If you have multiple Google Sheets scheduled, please, do the following:

  1. Open all your sheets in separate tabs.
  2. Click on Schedule Automatic Data Operations -> Other Settings in each sheet.
  3. Go through the sheets one by one and click the Reset Spreadsheet Settingsbutton.
  4. In the very last sheet – click on Reset All Settings
  5. At this point none of your documents should be clear of any automatic schedules and you can start from clean slate.