About Importing Google Sheets
• Information that Google uses to authenticate your account is stored in C:\Users\<user name>\AppData\Roaming\JMP\JMP\OAuthTokens on Windows. On Mac, oAuthTokens is stored in ~/Library/Application Support/JMP. (Passwords are not stored on the computer, and access tokens are encrypted.) Storing tokens in a data table enables you to import and export data using the same Google account without providing the authentication information again. Note that a user with access to your computer’s user account has access to all of your Google spreadsheets. If the spreadsheets contain confidential information, reconsider sharing your user account.
• @gmail.com is not required for your account name. However, if you do use it, <user name>@gmail.com and <user name> are treated as separate accounts. You must enter the authentication code for both accounts when importing or exporting.
• If Display intranet sites in Compatibility View in Internet Explorer on Windows is selected, the Google Sheet cannot be imported. To avoid this issue, follow these steps:
1. In Internet Explorer, select the Tools button 
and then select Compatibility View settings.
2. Deselect Display intranet sites in Compatibility View.
Note: In Google Sheets, you can select File > Publish to the web to publish the sheet for an audience to view. In this case, the link to the published sheet includes the pubhtml suffix. Use File > Internet Open to open these sheets. See Import Data from the Internet or a Remote Computer.