background
Due to changes in Google's access requirements, in JMP 17.1, JMP updated the way it connects to Google Sheets.
This change requires you to remove the old Google grant token and reconnect to your Google account. If you do not remove the old Google grant token, an error occurs (see JMP Note 579563 ). The following steps explain how to remove the old Google grant token and connect to Google Sheets using the new method.
oldGoogleDeleting the authorization token andGoogle Reconnect to your spreadsheet
oldGoogleDeleting an authorization token
On Windows:
- Press the Windows key and R on your keyboard at the same time to open the Run window.
- Enter %APPDATA%\SAS\JMP .
- Press Enter.
- Find and delete all files named OAuthTokens .
On macOS:
- In Finder, select Go > Go to Folder…
- Enter ~/Library/Application Support/JMP .
- Press Enter.
- Find and delete all files named OAuthTokens .
JMPtoGoogleAuthorizing access to your account
- Open JMP.
- Select File > Open from Internet > Google Sheets …
- Enter your Google Account email address in Google Account.
- Enter the web address of your Google Spreadsheet in Spreadsheet URL or ID .
- Click Settings .
*Some parts of the image below have been masked.
- In the "Sign in with Google" window, click " Launch Browser . "
- Select the Google account you want to sign in with.
*Some parts of the image below have been masked.
- Click Continue .
*Some parts of the image below have been masked.
- In the browser window that opens, copy the web address (URL) from the address bar (outlined in yellow in the image below).
*Some parts of the image below have been masked.
- Paste the web address into the "Sign in with Google" window (in the blue box) and click OK .
*Some parts of the image below have been masked.
- "Import Google Spreadsheet" will be displayed, so set it as appropriate and click " Import " .
Your Google Spreadsheet is now connected to JMP.
Additional Information
For more information about using Google Sheets, see the JMP online help .
Note: This FAQ is based on the following JMP Note:
JMP Note 654434 - How To Connect To Google Sheets Using New Method in JMP 17.1 and Newer
