Creating a Google JSON Credentials File

Creating a Google JSON Credentials File

Step by Step Instructions for Creating Google Credentials JSON File

Unfortunately, Google has made creating the credentials for sharing Google Spreadsheets a fairly lengthy process. Fortunately, you only need to go through this process once.
Follow these steps to create and download the JSON file:

1. Head to Google Developers Console: https://console.developers.google.com/project
   
   
2. If you haven’t already, Sign in to your google account:
   
   
3. Select the “Overview” tab (in the left pane) and select the “Google APIs” tab in the right pane. Then in the search box type “google drive”:
   
   
   
4. Select “Google Drive API”
   
   
5. Click the “Create project” button:
   
   
   
6. In the “Project name” entry, type a project name, e.g., “cross country”, under “Please email me”, select “No” (or “Yes” if you like getting lots of emails). Then select “Yes” to agree to the Terms of Service. Then click the “Create” button.
   
   
   
7. On the next screen, click the “Enable” button:
   
   
   
8. Then click the “Credentials” tab in the left pane.
   
   
9. Now click the “Create credentials drop down button and select the “Service account key” drop down:

10. In the “Service account” drop down, select “New service account”. In the “Service account name” entry, type in your gmail user-id. For “Key type”, verify that JSON is selected, then press the “Create” button:
    
    
    
11. This will create and download a new JSON file. Save it in a location of your choice that you can remember.