Logging in to Salesforce.com from G-Connector

When you first open your spreadsheet, the G-Connector for Salesforce menu will show these options:

If you click Login, a dialog box will open, where you will be able to select ‘Production‘ or ‘Sandbox.’

After you select the corresponding radio button and click the Login menu item, a dialog box will open where you’ll be able to authenticate with Salesforce.com.

If you are using a custom URL to access your Salesforce org, click the ‘Use Custom Domain’ button at the bottom right.

On the Salesforce side there’s also a set of permissions we need you to give us. We need to have access to your data in order to pull it to Google Sheets and push back to Salesforce. In order to be able to refresh your data on a schedule, we need to be able to keep a refresh token and have access to your Salesforce data offline.

Another option to login is clicking Launch in G-Connector’s dropdown menu. This will open a sidebar panel:

You can follow the same process mentioned above: select the corresponding ‘Production‘ or ‘Sandbox‘ radio button, authenticate with Salesforce.com or click ‘Use custom domain‘ if you are using a custom URL to access your Salesforce org.