Rating 0 stars - 0 votes

How to Generate Google API Key to Get Access to Google Sheets with Store Manager for WooCommerce

To import WooCommerce products from Google Sheets, upload data, append, prepend, create new files you will need Google API keys. In this article, we will guide you how to generate your API keys and use Google Sheets functionality further. In case you have any questions, please contact us at [email protected] and we’ll gladly assist you.

Follow few steps to get your Google Drive and Google Spreadhseet 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 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.


Selecting a Project on Google Cloud

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".


New Project Creation on Google Cloud

Use a clear name, such as “WooCommerce 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.


APIs and Services on Google Cloud

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


Enable APIs and Services Option

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

8. Enable Google Drive API.


Enabling Google Drive API

9. Enable Google Sheets API.


Enabling 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.


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.


App and Developer Contact Information

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

Updating Selected Scopes on Google Cloud

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.


New Test User on Google Cloud

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".


Back to Dashboard After Test User Creation

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


OAuth Client ID

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.


Application Type in OAuth Client ID Settings

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

Do not provide the above credentials to anyone.


Client ID and Client Secret

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.


WooCommerce Google Sheets Authentication in Store Manager

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

21. Grant all permissions to proceed.


Sign In to Google Account via Store Manager for WooCommerce

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. In the end, you'll see "Authentication successful" screen.

Now you can use Store Manager for WooCommerce and Google SpreadSheets integration.

If you need any assistance, contact us at [email protected]

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.

Use Store Manager for WooCommerce for Google Sheets integration

Try now FREE

Related Articles:
Card image
WooCommerce – Bulk Category Import Through a Google Sheet

Import category tree or separate subcategories provided by your supplier in Google Sheets format using Store Manager application. Read More...

Card image
Export WooCommerce Products to Google Sheets

Export WooCommerce filtered products and separate fields to Google Sheets sharing with a supplier for replentishment via Store Manager smart Export Wizard. Read More...

Card image
How to Set Up WooCommerce Automated Import of Products

Set up an automated upload tasks from suppliers for catalog update from local files, HTTP or FTP links and more. Read More...

Card image
"Export WooCommerce Products to Google Shopping

Create and upload your WooCommerce catalog feed to Google Merchant Center via Store Manager software. Read More...

COMMENTS
Be the first to comment.