Sheet Integration Plugin – for wp – how to:
Step-by-Step instructions to create service account :
Step 1 :
1. Click to the **Spreadsheet Integration** button on WP Admin.
2. Click to the **Settings** button.
3. Click to the **enable API & create a service account** link. It will open Google API console in another Browser Tab. See the next step.
Step 2 :
1. After clicking to the **3. enable API & create a service account** link. Below Window will Open. click to the Dropdown Arrow. ( text may not be the same as 'demo-account' ).
Step 3 :
1. Click to **NEW PROJECT** and create a New API Project.
Step 4 :
1. Change to your **Project name\***
2. Click to **CREATE** button. for creating the Project.
Step 5 :
1. Click to the Dropdown Arrow and Select Newly Created project ( text may not be the same as 'New Spreadsheet Integration' ).
2. Click to the **Library** button. API Library will open.
Step 6 :
1. After clicking the **Library** button. The below page will open. Make sure that Project is your Newly Created one ( text may not be the same as 'New Spreadsheet Integration' ).
2. Now click Google Drive API & Enable it
3. After Enable Google Drive API, Now Enable Google Sheets API
1. Click the **ENABLE** button. and enable Google Drive API.
1. Make sure API Enabled.
1. Now click to Burger menu Icon.
2. Click to APIs & Services.
3. Select library again to see the API lists.
1. Click **ENABLE** button. and enable Google Sheets API.
1. Make sure API Enabled.
1. Make sure Both Drive and Sheets API is Enabled.
Step 7 :
1. Click to **Credentials** button.
2. Make Sure Project is your newly created one ( text may not be the same as 'New Spreadsheet Integration' ).
3. Click to **+ CREATE CREDENTIALS** button.
4. Select **Service account**
Step 8 :
1. Now you have to create a Google service account to access its services. click to the **Service account**
2. Make Sure Project is your newly created one ( text may not be the same as 'New Spreadsheet Integration' ).
3. Name your service account in our case I used **Spreadsheet Integration Service Account**
4. After naming it will create a service account Email address.
5. Click the **DONE** button.
1. Click the service account Email Address.
1. Now you have to create a Google service account to access its services. click to the **KEYS**tab
2. Click **ADD KEY** dropdown.
3. Select **Create new key**A new popups will open.
1. Select **JSON** on popups.
2. Click on **CREATE** after that a JSON file will download on your PC. Open that file & copy the content carefully **as is**
Step 9 :
1. Click to the **Spreadsheet Integration** button on WP Admin.
2. Click to the **Settings**
3. Past the Downloaded key here. Make sure Key starts with **{**
4. Make sure Key ends with **}**
5. Click on the **SAVE** button.
Step 10 :
1. This is your service account Email address, share your Google sheets with this address.
2. For Remove click **Remove Credentials** button.
3. If everything is Okay this “ will show.
4. If you face any Error Regarding this Plugin, See the Log. This Log is Specific to this Plugin.
1. Go to your Google Spreadsheet & Click on the **Share** button.
2. Place your service account email address here.
3. Click to the **Share** button
1. You can also see the below video, for the video tutorial.
Note : If you fail then Try again. Please don't skip any step. try from PC. if you fail again Create a Support ticket from the Plugin Contact Us menu. – Best Regards