fmAddCloudStorage 

How to Generate Google API Key to Get Access to Google Spreadsheets with Store Manager for Adobe (ex Magento)

To import Adobe (ex Magento) products from Google Sheets, upload data, append, prepend, and create new files you will need Google API keys. In this article, we will guide you on how to generate your API keys and use Google Sheets functionality further. In case you have any questions, please contact us at contact@emagicone.com and we’ll gladly assist you.

Follow a few steps to get your Google Drive and Google Spreadsheet API details:

1. Go to the API Console: https://console.developers.google.com/

Important! Google API might not be available for all accounts. If you cannot enable Google API, you are welcome to use the Google Drive offline folder to upload or download files from Google Drive.

2. From the projects list, select a project or create a new one.

If you are not redirected to create a new project, click on the projects dropdown right next to the Google Cloud icon in the top left corner. After that you will see a list of your projects as well as a button to create a new one.

3. Specify Project name, organization name and hit Create

Use a clear name, such as “Adobe (ex Magento) to Google Drive sync”, or something similar.

Fill in all required fields and proceed. You will need Google Drive API, OAuth 2.0 Client IDs.

4. Select the project in the top dropdown from the projects list (resources list).

Once the project is created, make sure you select the newly created project in the project list to proceed.

5. Proceed to APIs & Services.

6. Go to Enabled APIs and Services => +Enable APIs and Services.

7. In the list of APIs find Google Drive API and Google Sheets API.

8. Enable Google Drive API

9. Enable Google Sheets API

If you are using Google My Business and cannot see your APIs & services enabled, contact your Google account administrator to enable them, specifically Google Drive API.

In order to enable Google Drive API for Business account, go to https://console.developers.google.com/

Open main menu - Apis & Services - Library

In the Google APIs library find Google Workspace - Google Drive API (Google Enterprise API , Create and manage resources in Google Drive). Enable it to proceed.

https://console.cloud.google.com/apis/library/drive.googleapis.com

10. Go back to the Enabled APIs and Services (as described on step 5) and open OAuth consent screen

Enable external access user type and hit Create.

11. Fill in all required fields to create your App.

You will use your own app for your own needs. Make sure to fill in data that would be informative, add app domain (your site) and policies.

Add developer contact email. Use the same email as you use for app creation.

Hit save and continue

12. Update your scopes (app access).

For that hit Add or remove scopes button and enable the following scopes:

• auth/userinfo.email

• auth/userinfo.profile

• https://www.googleapis.com/auth/drive

• https://www.googleapis.com/auth/drive.file

• https://www.googleapis.com/auth/spreadsheets

If you cannot see the scopes in the list, you can add them manually.

In order to add scopes manually hit ADD OR REMOVE SCOPES and in the search field find the above scopes and add them all one by one.

Once you are done hit Save and Continue

13. Add a new test user. Hit save and continue

You can have up to 100 unique users added to this app. The limitation is lifetime for each app.

14. On the summary step check all settings and hit Back to dashboard

15. Once you’re on the Enabled APIs & services page and created your app, on the left (in the left menu), choose Credentials: https://console.cloud.google.com/apis/credentials 

Create a new credentials and select OAuth client ID

16 In the Create OAuth client ID select application type - Desktop app and specify credential name

Hit create to generate your api key

17. You have your new Cliend ID and Client secret.

Do not provide the above credentials to anyone.

18. You can find your API key when you click on the API key details:

Additional information:

• Client ID: sampleletters-numbers123lettersnumbers123.apps.googleusercontent.com

• Client secret: SAMPLE123ASD321GFF123WER

• Status: Enabled

19. Open Store Manager software - Preferences (F12) - Cloud storages

Add Cloud storage account. Add storage name, like Google Drive and specify the Client ID, Client secret generated on the step 16 and hit Authenticate.

20. Now you can login with the username specified on step 13

21. Grant all permissions to proceed.

The above permissions are granted only for this user with the above API credentials. Please do not share the above credentials to any third-party.

22. You should see Authentication successful screen.

Now you can use Store Manager for Adobe (ex Magento) and Google SpreadSheets integration.

If you need any assistance, contact us at contact@emagicone.com

Important! Do not save, publish, or transfer your API keys to any third-parties.

Important! eMagicOne does not request your API keys under any circumstances. Use the generated API keys to paste them into the application.

Important! Do not use the revoke button or the regenerate button, as you will need to paste your API keys in Store Manager software again.

Why do you need Google API keys now to work with Google Sheets?

Google changed the process of API verifications in 2024. From now on, all software developers need to go through a paid (costly) security assessment validated by a CASA authorized lab every year.

“To help keep user data safe, every app that requests access to restricted scope is now required to go through a security assessment validated by a CASA authorized lab. This includes local client applications and Google Workspace add-ons. The assessment helps keep Google users’ data safe by verifying that all apps that access Google user data demonstrate capability in handling data securely and deleting user data upon user request.

For more information, you can read the Security Assessment article in the OAuth App Verification Help Center. The assessment process is described in detail on the CASA website.”

“Annual Recertification: All apps must be revalidated every year. The app tier can increase to a higher tier for the following year than what it was the previous year. Once an app has been validated at tier 3 it will continue to be validated at tier 3 level at each following year.“

Since Store Manager to Google Spreadsheets integration requires 3rd level access, we need to go through a costly security assessment validation every year. Unfortunately this does not apply to our pricing model (one-time payment for lifetime usage).

As a workaround we offer our customers an option to register and request their API credentials for personal use, as those do not need a security assessment validation by a CASA authorized lab every year.

Important! We have passed all required validation prior to this change, so you can keep using the software safely.