How to Integrate Google SpreadSheet with WooCommerce

1) Connect your Site to GoogleSpreadsheet

Go to WC GoogleSpreadsheet =>Settings.

You will need Client ID and Client Secret Key to get started.

-Client ID & Client Secret Key : Follow the step by step tutorial mentioned here to get your Client ID and Client Secret Key.

Add the Client ID & Client Secret Key & hit Save button.

 

– Now Click on Generate Token button: This will open new tab, Sign in with google account & allow drive & sheet api access.

 

 

 

Copy the Generated token code 

–  Paste it in Client Token Code Field & click on Update Settings button.

 

–  Now you should see Authorized Green text.

 

2) Send Order data to Google Spreadsheet

Create a New Feed & then select SpreadSheet & Sheet to map Sheet headers with Order data.

NOTE: First row in your sheet are the sheet headers.

 

 

 

 

 

That’s it .. Now when you receive new order it will add new row in Google Spreadsheet.

You can download the plugin from here