Configuration for Google Sheets API
To allow the Archipelago Multi Importer (AMI) to read from Google spreadsheets, you first need to configure the Google Sheets API as outlined in the following instructions.
- Frequent changes to the Google Sheets API specifications may impact the configurations needed.
- This set of instructions will only work for individuals using Google accounts affiliated with Organizations.
- Please contact us on our Archipelago Commons Google Group with any questions/issues.
Generating Google OAuth2 Credentials
Login to the Google Developer Console. You will see the API & Services Dashboard.
If you have not created Credentials or a Project before, you will need to first create a Project.
- Recommended Project Name: "Archipelago Multi Importer" or "AMI".
- The Organization and Location information should be specific to you and your organization/institution.
Next, click the
Create credentialsselect box and select
OAuth client ID
You will now need to Configure the Consent Screen.
On the initial OAuth Consent Screen setup, select
Internalfor User Type.
AMIas the App name, and your email address in the User support email. You may also wish to add Authorized domains (bottom of image below) as well.
On the Scopes page, select
Add or Remove Scopes. Then either search/filter the API table for the Google Sheets API. Or, under
Manually add scopesenter: https://www.googleapis.com/auth/spreadsheets.readonly
After selecting or entering in the Google Sheets API, you should see this listed under
Review the information on the
Summarypage, then Save.
You will now be able to
Create Oauth client ID. Select
Web Applicationas the
Enter "AMI" under 'Name' and add any URIs you will be using below.
After Saving, you will see a message notifying you that the OAuth client was created. You can copy the
Client Secretdirectly from this confirmation message into a text editor. You can also access the information from
APIs & Servicessection in the Developer console, where you will have additional options for downloading, copying, and modifying if needed.
On the 'Add Google Api Client account' configuration page, enter the following information using your
Client Secret. 'Developer Key' is optional. Select
Google Sheets APIunder 'Services' and
https://www,googleapis.com/auth/spreadsheets.readonlyunder 'Scopes'. Check the box for
Is Access Type Offline. Select the Save button.
You will now need to Authenticate your AMI Google API Client. Return to the Google API Client Listing page. Under the Operation menu on the right-hand side of the AMI client listing, select
You will be directed to the Google Consent Screen. You may need to login to your corresponding Google Account before proceeding. When loged in, you will see the following screen requesting that AMI is allowed to "View your Google Spreadsheets". Click
On the Google API Client Listing page, your AMI client listing should now have 'Yes' under 'Is Authenticated'. You are now ready to use Google Sheets with AMI! Return to the main AMI documentation page to get started.
Thank you for reading! Please contact us on our Archipelago Commons Google Group with any questions or feedback.
Return to the Archipelago Documentation main page.
Created: February 3, 2021