How to use ShopMagic with Google Sheets
Our free extension to ShopMagic - ShopMagic for Google Sheets enables you to easily connect your WordPress site or WooCommerce store with popular spreadsheets. Send your Customer order data to spreadsheet or save any form submission with an ease to name a few examples of usage.
Install ShopMagic for Google Sheets
You can download plugin from WordPress repository, just head to Add plugin section in your WordPress installation and search for ShopMagic for Google Sheets.
To install this extension you need our core plugin, ShopMagic, which also comes for free!
Configuring Google Account with ShopMagic
To communicate our plugin with your spreadsheets you need to authorize our app to access your account data. Don't worry, we are only reading and updating your sheets data. You will find configuration options in ShopMagic settings screen with link to retrieve access code.
Our plugin is incredibly easy to set up - just follow the authorization link in settings tab, allow our app to access your data and paste the code. Hit the save button and you are ready to go!
Saving WordPress data to Google Sheets
After successful configuration, in automation editor you will see new action in the list - Add row to Google Sheets.
Setting up the action is pretty simple. You have a few fields to fill:
- Spreadsheet - a list of all your spreadsheets associated with a Google account
- Spreadsheet Tab - (aka. worksheet) select the tab where you want to save data
- Is first row a header - if yes, you will see labels from your first row, otherwise you can manually add as many rows as you need
- Fields - the juice of the plugin - you can add there any placeholder you want to save to Google Spreadsheet
Now, you are ready to integrate your WooCommerce store with Google Sheets in nice and easy way!