Sticker Sticker
Sticker Sticker
  • 00 :

    Days
  • 00 :

    Hours
  • 00 :

    Minutes
  • 00

    Seconds
Sticker Sticker

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

Video Tutorial: #

You can follow this video to know to installation & activation process of the plugin step-by-step:

Install & Activate The Plugin #

You can activate and setup the plugin following these steps:

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

Now Order Sync with Google Sheee is activated for you to set up and enjoy.

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 & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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 & Activate Order Sync With Google Sheets for WooCommerce
How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

Now click on the service account you created.

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

Next, click on ‘Create new key‘.

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

Now go to your plugin section and upload the JSON file  

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

Enable the Google Sheets API

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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 & Activate Order Sync With Google Sheets for WooCommerce

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 & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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 & Activate Order Sync With Google Sheets for WooCommerce

Share the editor access of the spreadsheet to the ID.

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

Add Script Code on Editor #

In this step, copy the Apps Script code.

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

Now, give permission by setting your email. 

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce
How To Install & Activate Order Sync With Google Sheets for WooCommerce

Then, allow Google to access your account. 

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

Add The Triggers #

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

Complete The Setup #

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

How To Install & Activate Order Sync With Google Sheets for WooCommerce

And your WooCommerce orders will be synced on Google Sheets.

How To Install & Activate Order Sync With Google Sheets for WooCommerce