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.



2) Authorize access to Drive & Sheet Api

After saving Client ID & Secret click on Authorize Button.



Signin using your google account & allow access to sheet & drive api.



3) 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