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 a spreadsheet or save any form submission with ease to name a few examples of usage.
The add-on requires ShopMagic.
Install ShopMagic for Google Sheets#
You can download the plugin from the WordPress repository, just head to the 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 the ShopMagic settings screen with the link to retrieve the access code.
Our plugin is incredibly easy to set up - just follow the authorization link in the 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 the automation editor, you will see a new action in the list - Add row to Google Sheets.
Setting up the action is pretty simple. You have a few fields to fill:
- Description - a description to make identification of the data easier
- Key - the unique identifier of a spreadsheet or a specific range of cells within it
- Value
Now, you are ready to integrate your WooCommerce store with Google Sheets in a nice and easy way!
You may read more on how to send data from WordPress & WooCommerce to Google Sheets (with a free plugin).