Video Tutorial: #
Go to your admin dashboard and navigate to Plugins > Add New. Then search for “Stock Sync for WooCommerce with Google Sheets”.
Then install and activate the plugin.
Now follow the below part for step-by-step instructions on the setup procedure. You can also follow this video to follow visual instructions:
Step 1: Uploading credentials.json file
First, go to your admin dashboard and click on the Stock Sync with Google Sheet. Then click on Start Setup to initiate the setup steps.
In the next step, navigate to the Google Cloud Platform to create a service account.
After navigating to the Google Cloud Platform, click on Create Credentials and select Service account from the dropdown menu.
Here, set the service account name and click on CREATE AND CONTINUE.
Then click on Continue and then select DONE.
Finally, click on the service account ID.
Navigate to the KEY tab from the top bar and click on Create new key followed by ADD KEY.
Choose the JSON file format. Then download the file and upload it to the plugin dashboard.
Step 2: Enabling the Google Sheet API
Select the highlighted Click here from the plugin dashboard.
Next from the Google Cloud Platform, click on Enable.
Go back to the dashboard and make sure to tick the checkbox. Then click on next.
Step 3: Adding Google Sheet URL
Go to Google Sheets and open a new spreadsheet where you want to store your products. Copy the URL from the browser’s address bar.
Paste the URL in the URL section of the plugin. Also, paste your spreadsheet’s tab name.
Copy the editor access ID from the dashboard and go back to Google Sheets.
Click on the Share option from the top right corner of the screen and paste the editor access ID. Then click on Share. If Google Sheets ask for any permission make sure to provide that.
Step 4: Adding script code
Copy the script code and go back to Google Sheets.
From the navigation tab on the top bar, click on Extensions. Then from the drop-down menu choose Apps Script.
There remove the existing code and paste the code you just copied from the plugin dashboard. Next, click on Next and then Run.
Google might ask for authorization permission in this step. In that case, click on Review permissions. Then select Hide (Advanced) and then Go to Untitled project (unsafe).
Finally, click on Allow to provide access to provide editing access to the spreadsheet.
Step 6: Adding trigger #
Go to the Apps Scripts from the Extensions menu again. Click on Triggers from the left navigation menu.
On this window choose Triggers to add triggers for the spreadsheet. From the dropdown menu in Choose which function to run option, choose onEdit. Then click on Select event type and from the dropdown menu select onEdit again. Finally, save the settings.
That’s it! Go back to the plugin dashboard and get ready to live sync from Google Sheets.