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.

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

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. 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 FREERelated Articles:

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

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

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

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