ShopMagic for Google Sheets

July 25, 2024

ShopMagic for Google Sheets Plugin

Integrate your WooCommerce store with Google Sheets - the most popular Spreadsheet service for free.

★★★★★

THE BEST AND FREE GOOGLE SHEETS INTEGRATION FOR WOOCOMMERCE

ShopMagic for Google Sheets will let you connect your WordPress with Google Sheets. You’ll be able to export all the data from WooCommerce orders to Google Sheets ⭐.

No need to use any external or 3rd party software to establish a connection between your WordPress and Google Sheets. Thanks to our plugin, it is set directly between your store and Google Sheets.

You can decide to which spreadsheet your data should be exported. You can also select rows and tabs of your document.

All of that is available just within a few clicks – no burdensome configuration is needed. Connect your Google account with ShopMagic and you will be ready to save any data to all of your spreadsheets.

When installed and activated, there will be a new action type called Add row to Google Sheets. Select it, and choose the sheet from your account to integrate.

See the whole process on our blog → 😊

SHOPMAGIC FOR GOOGLE SHEETS USE CASES

Every time a new order will be created in WooCommerce, ShopMagic will export its data to the new row of a spreadsheet of your choice. However, it is not the only way how you can use our plugin.

ShopMagic for Google Sheets will let you:

  • Save any CF7 form submission in WordPress or WooCommerce
  • Add a review to your spreadsheets database
  • Create a list of your users updated in realtime
  • Send the data from your WordPress forms and WooCommerce orders to Google Sheets
  • Gather WordPress blog posts, comments, subscriptions, and bookings in spreadsheets

Why choose ShopMagic for Google Sheets:

  • Ultra-fast configuration
  • Free WooCommerce and Google Sheets integration
  • No need to use external software
  • Multiple integrations
  • 90+ placeholders
  • The possibility of further extending with ContactForm 7 or Gravity Forms
  • Sending data from WordPress and WooCommerce to Google Sheets with a few clicks

When connected, you can use choose any of your Sheets in the automation settings.

★★★★★

SHOPMAGIC FOR GOOGLE SHEETS IS AVAILABLE FOR FREE

That’s right. We believe that everyone should have the possibility to benefit from modern marketing strategies and solutions. Especially in the current world situation. That’s why we are giving this add-on for free, to every WooCommerce store owner. It is the fourth ShopMagic add-on which is available for free. The rest are:

  • ShopMagic Abandoned Carts, designed to recover WooCommerce abandoned carts, lower the abandoned cart rates, send personalized emails and cart reminders.
  • ShopMagic for Twilio integration to send SMS directly from the WordPress dashboard or text messages and notifications for your WooCommerce customers. You may also use the plugin to send SMS reminders about the customer’s abandoned cart in WooCommerce to the specific reminder list of customers.
  • ShopMagic for Contact Form 7 that will let you use data from the Contact Form 7 submission forms in your automation. You can use the Contact Form 7 integration to create a custom WordPress or WooCommerce product enquiry, order, and checkout form.

You can use all free add-ons together to boost your email marketing in WordPress and WooCommerce 🚀!

IS THERE A PRO VERSION OF SHOPMAGIC FOR GOOGLE SHEETS?

No. ShopMagic for Google Sheets is designed as free, and it will be free once and for all. All of the features are included in this add-on.

You may use the add-on to export data from WordPress form submissions or WooCommerce to Google Sheets.

Start by configuring Google Account within ShopMagic settings using a token. Then, create new automation and choose the Add row to Google Sheets from the Actions list. Finally, choose the settings for the data export from your WordPress or WooCommerce to Google Sheets. The ShopMagic will do everything for you automatically!

No additional login, credit card, or external account is needed. Simply download, activate our plugins, and you are good to go!

However, there’s a non-direct way of extending ShopMagic for Google Sheets features. If you are using ShopMagic PRO you’ll have access to some add-ons like Gravity Forms, Manual Actions or Customer Coupons. You can use them to create better, more personalized WooCommerce marketing automation.

MORE ADD-ONS

ShopMagic for Google Sheets is available for free and can be used as your only ShopMagic add-on. However, it integrates with the rest of the add-ons. If you want to extend its functionality, all the ShopMagic PRO add-ons will work. To name a few:

  • Delayed Actions – Use it to delay your email. You can choose from delay for a specified number of minutes, hours, days, or weeks or to send an email at a specified time. Delay both SMS and email notifications.
  • Review Requests – Request a review from your customer. You can automate your review request flow, and create an automated thank-you email when a customer will review your product.
  • Manual Actions – Trigger custom emails, directly from your WordPress dashboard, whenever you want, and to whomever you want. Send manual emails, and manually trigger SMS messages. Use it to notify your customers about special offers in your WooCommerce store.
  • Advanced Filters – Adds conditional logic and custom filters for your email marketing automation based on specific criteria like order total value.
  • Customer Coupons – Send the WooCommerce discount coupons automatically in emails to boost your sales and rescue abandonment carts with special offers.
  • ShopMagic's Integrations – Integrate your store with WooCommerce Bookings, WooCommerce Memberships, and WooCommerce Subscriptions plugins.
  • Slack Integration for ShopMagic is also here to let you send notifications from WordPress and WooCommerce!

If you are looking for more information about available add-ons, check our ShopMagic website.

★★★★★

How to create ShopMagic’s automation?

Creating automation in ShopMagic is a simple process. You can use below video guide:

On the other hand, ShopMagic has a bunch of built-in recipes, which you can import if you prefer not to start from scratch.

Use the ShopMagic plugin to prepare best automatic newsletters, customize emails, surveys, reviews, and automate email marketing with WordPress and for WooCommerce customers!

Requirements

The only requirement is the core version of the ShopMagic plugin.

Installation

  1. Install either via the WordPress.org plugin directory or by uploading the files to your server.
  2. Activate the plugin through the “Plugins” menu in WordPress.
  3. Go to WooCommerce → Automations in your WordPress admin area and add automation.
  4. Choose an event and an action for automation based on your preferences.
  5. Configure Google Account within ShopMagic settings using a token.
  6. Edit email automation and choose the Add row to Google Sheets from the list of Actions.
  7. Choose the settings to export data from your WordPress or WooCommerce to Google Sheets automatically.

Screenshots

  1. Enable Google Sheets integration for ShopMagic in the plugin settings with one click.

    Enable Google Sheets integration for ShopMagic in the plugin settings with one click.

  2. Google Sheets Token to send data from WooCommerce and WordPress with ShopMagic.

    Google Sheets Token to send data from WooCommerce and WordPress with ShopMagic.

  3. ShopMagic for Google Sheets integration to WooCommerce and WordPress - free plugin.

    ShopMagic for Google Sheets integration to WooCommerce and WordPress - free plugin.

  4. Add customers that cancelled WooCommerce orders to Google Sheets automatically.

    Add customers that cancelled WooCommerce orders to Google Sheets automatically.

  5. Get all users that created WooCommerce accounts to Google Sheets - free integration.

    Get all users that created WooCommerce accounts to Google Sheets - free integration.

  6. Gather blog lists from your WordPress to Google Sheets.

    Gather blog lists from your WordPress to Google Sheets.

  7. Lower the WooCommerce abandonment cart rate - create a list in Google Sheets, send emails, or add customers to your Mailchimp list.

    Lower the WooCommerce abandonment cart rate - create a list in Google Sheets, send emails, or add customers to your Mailchimp list.

  8. Add new WooCommerce subscribers to Google Sheets (requires ShopMagic WooCommerce Subscriptions PRO add-on and WooCommerce Subscriptions itself).

    Add new WooCommerce subscribers to Google Sheets (requires ShopMagic WooCommerce Subscriptions PRO add-on and WooCommerce Subscriptions itself).

  9. Install the free Google Sheets integration for ShopMagic from the WordPress Plugins menu.

    Install the free Google Sheets integration for ShopMagic from the WordPress Plugins menu.

  10. Connect Google with ShopMagic for WooCommerce.

    Connect Google with ShopMagic for WooCommerce.

  11. Copy the Google integration token.

    Copy the Google integration token.

  12. Save the token for the Google Sheets WooCommerce integration with the ShopMagic plugin.

    Save the token for the Google Sheets WooCommerce integration with the ShopMagic plugin.

  13. Add new marketing automation for WordPress and WooCommerce.

    Add new marketing automation for WordPress and WooCommerce.

  14. Export WooCommerce new order data to Google Sheets.

    Export WooCommerce new order data to Google Sheets.

  15. Send new order data from WooCommerce to Google Sheets (details).

    Send new order data from WooCommerce to Google Sheets (details).

FAQ

Do I need anything else to use this plugin?

Yes. This plugin is an extension for ShopMagic – a free email marketing plugin for WooCommerce ⭐!

What are the benefits of using Google Sheets for ShopMagic?

Thanks to this add-on, ShopMagic can save the data you want to Google Sheets automatically! It’s great if you want to:

  • Save the emails from Contact Form 7 🔔
  • Send WordPress blog posts to a separate spreadsheet 📣
  • Export WooCommerce order data to Google Sheets 💰

How to use the add-on to export data from WooCommerce to Google Sheets?

You can use ShopMagic for Google Sheets to easily export order data from your WooCommerce to Google Sheets. Read how to use ShopMagic with Google Sheets. If you have any questions let us know!

How to use the plugin to export data to Google Sheets from WordPress?

You may send the user form submission data in WordPress automatically with new automation. You can use a free Custom Form 7 add-on for ShopMagic to gather the data from registration, or product enquiry forms to your Google Sheets. You may also send additional custom emails with surveys or prepare the best email marketing newsletter campaigns for some users based on additional criteria.

Can I export data from WooCommerce Subscriptions, WooCommerce Memberships, or WooCommerce Booking to Google Sheets? Is it possible?

Yes. You can do that for customers buying subscriptions or booking services with WooCommerce Bookings, WooCommerce Subscriptions, or WooCommerce Memberships PRO add-ons for ShopMagic.

I’m new to WooCommerce. Will I be able to configure ShopMagic?

Of course! It only takes a few minutes to configure a follow-up email in our plugin. If you encounter any problems, we have a team of dedicated specialists ready to help you.

Do you provide support?

We’d love to hear from you! You can ask a question on WordPress forums or send us a direct support message. We leave no questions unanswered!

Will ShopMagic for Google Sheets slow down my site?

No. Just like WooCommerce, our plugin stores everything locally in the WordPress database. All emails and actions are queued and sent or performed in batches, so even if you have a big store with lots of customers and orders, it will run smoothly.

Are coding skills needed to use the ShopMagic plugin?

Not at all! No coding skills are required. One of our goals is to simplify the creation of every automation. Usually, it only takes a few minutes to create a working automation.

Is there documentation for this add-on?

Yes, there is. ShopMagic and each of its add-ons have extensive documentation available for you. Here’s the article about how to use ShopMagic for WooCommerce to export data to Google Sheets.

Do you offer more free plugins?

Yes. Check out our free WooCommerce plugins →

You can also choose one from the list below.

  • Flexible Invoices – create free PDF invoices in WordPress and WooCommerce.
  • Custom Price – let customers name the product prices in WooCommerce. Sell products at custom prices and receive donations in WooCommerce.
  • Flexible Checkout Fields – customize the checkout page in WooCommerce with the free customizer.
  • Flexible Product Fields – add custom fields to the WooCommerce product page for free!
  • Flexible PDF Coupons – offer pdf gift cards, vouchers, and tickets in WooCommerce.
  • Flexible Wishlist – let customers save product wishlists in WooCommerce, share their favorite products, or easily save carts for future shopping!
  • Dropshipping XML – Import Products – import and update WooCommerce products from any CSV or XML file.
  • Flexible Quantity – change units of measure for WooCommerce products.
  • Flexible Refund – speed up customer refunds in WooCommerce with the refund form and better refund process.

Changelog

2.1.0 – 2024-07-23

  • Changed spreadsheet select into text input field due to changes in Google API access.
  • Added support for WordPress 6.6
  • Added support for WooCommerce 9.1

2.0.8 – 2024-03-21

  • Added support for WordPress 6.5

2.0.7 – 2024-03-07

  • Added support for WooCommerce 8.7

2.0.6 – 2024-01-11

  • Added support for WooCommerce 8.5
  • Improved handling disconnection from Google services.

2.0.5 – 2023-12-18

  • Added support for WooCommerce 8.4

2.0.4 – 2023-11-07

  • Added support for WordPress 6.4
  • Added support for WooCommerce 8.3

2.0.3 – 2023-10-09

  • Added support for WooCommerce 8.2

2.0.2 – 2023-06-16

  • Bumped WordPress compatibility to 6.3.
  • Bumped WooCommerce compatibility to 8.0.

2.0.1 – 2023-03-23

  • Added support for ShopMagic 4.0.
  • Bumped WooCommerce compatibility to 7.9.

2.0.0 – 2023-03-23

  • Rewriten plugin to use ShopMagic 3.x
  • Changed method of authorization to Google Services.
  • Bumped WooCommerce compatibility.
  • Bumped WordPress compatibility.

1.0.11 – 2022-10-31

  • Bumped WooCommerce compatibility
  • Bumped WordPress compatibility

1.0.10 – 2022-07-22

  • Bumped WooCommerce compatibility

1.0.9 – 2022-06-22

  • Bumped WooCommerce compatibility

1.0.8 – 2022-05-24

  • Bumped WooCommerce compatibility
  • Bumped WordPress compatibility

1.0.7 – 2022-04-28

  • Bumped WooCommerce compatibility

1.0.6 – 2022-03-09

  • Bumped WooCommerce compatibility

1.0.5 – 2022-03-02

  • Bumped WooCommerce compatibility

1.0.4 – 2022-02-01

  • Fixed revoking Google authorization
  • Bumped WordPress compatibility

1.0.3 – 2022-01-18

  • Bumped WooCommerce compatibility

1.0.2 – 2021-12-27

  • Bumped WooCommerce compatibility
  • Added styled Google button for authentication

1.0.1 – 2021-11-17

  • Added WordPress assets

1.0.0 – 2021-11-15

  • Initial release!

Details

  • Version: 2.1.0
  • Active installations: 300
  • WordPress Version: 6.4
  • Tested up to: 6.6.1
  • PHP Version: 7.2

Ratings


5 Stars
4 Stars
3 Stars
2 Stars
1 Stars