Sticker Sticker
StickerSticker
  • 00 :

    Days
  • 00 :

    Hours
  • 00 :

    Minutes
  • 00

    Seconds
Sticker Sticker

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

First, install and activate “WooCommerce” if you haven’t done that yet.

Install & Activate Order Sync With Google Sheets for WooCommerce Ultimate #

Go to your WordPress admin dashboard. Navigate to the “Plugins” menu and click on the “Add New” button.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now, search for “Order Sync with Google Sheets for WooCommerce”.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Click on the “Install Now” button and then activate the plugin by clicking the “Activate” button.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

After activating the plugin, Now, you’ll need to activate the Ultimate version of the plugin and the license key. To do that go to https://wppool.dev/my-account/.

Login to your account to find a similar interface. From here you can download the Ultimate plugin’s zip and get your License Key.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now, go back to the WordPress dashboard and navigate to the Plugin menu. Click on Add New and select Upload Plugin. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Upload the premium plugin file you just downloaded from your account and then hit “Install Now”. Also, activate the plugin in the next step.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

In the next step, go to the “Order Sync with Google Sheet” plugin menu in your dashboard and click on “License”. Here enter your license key and activate the license.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now Order Sync with Google Sheet Ultimate is ready for you to set up.

How To Set Up Order Sync with Google Sheets For WooCommerce #

Set Up Credentials: #

After activating the plugin, it will take you to a page to set up. Click on “Start setup

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

There, click on “Google Cloud Platform” to create a service account.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now, you need to create a new project from the option shown below and you can skip this step if you’ve already created one. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate
How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Next, click on the Service account under the Create credentials button. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Here, set your account information by clicking on the Continue button and then finish with the Done button.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now click on the service account you created.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Then go to the KEYS tab to click on the ADD KEY

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Next, click on the Create new key.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now, set the key type to JSON and click on “CREATE”. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Upon clicking, the credentials will be downloaded to your PC. 

Now go to your plugin section and upload the JSON file  

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Then click on the link that says click here so that you can enable the API for Google Sheets. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Enable the Google Sheets API

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now go back to the plugin and check the box to confirm that you have enabled the Google Sheets API and hit next.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Add Google Sheet URL & Sheet Tab Name #

To add Google Sheets to the plugin, create a new spreadsheet, set a title, and copy the URL of the spreadsheet.  

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Paste the sheet URL in the URL field of the plugin.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Also, copy the sheet tab and paste the tab name. Finally, click on “next”

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Add Editor Access to The Plugin #

In the next step, copy the provided ID to share editor access to this ID from your Google spreadsheet.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Share the editor access of the spreadsheet to the ID.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now, go back to your plugin and confirm that you’ve provided the editor access. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Add Script Code on Editor #

In this step, copy the Apps Script code.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Then go to “App Script” under the extensions menu of the Google Sheet you created. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Remove the existing code and paste the code you just copied and hit save and then the “Run” button.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now, give permission by setting your email. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Click on Advanced and click on Go to the untitled project.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate
How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Then, allow Google to access your account. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now go back to your plugin and confirm that you have added the code script. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Add The Triggers #

To set the trigger, go to the app script and under trigger click on “add trigger”. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Now, Set the function to “onEdit” and then set the event type to “On Edit” and hit save. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Go back to your plugin and confirm the trigger and the permission and hit next. 

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

Complete The Setup #

Finally, click on “Sync orders on Google Sheet” to complete the setup.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate

And your WooCommerce orders will be synced on Google Sheets.

How To Install And Activate Order Sync With Google Sheets for WooCommerce Ultimate