Woo masterclasses

How to Sync WooCommerce & Google Sheets Without Plugins!

switch, pc, computer, circuit, data processing, the distribution server, data exchange center, electronic products, line, system, switch, switch, switch, switch, switch, data processing, electronic products

Want to connect WooCommerce with Google Sheets without relying on plugins, Zapier, Make, or third-party connectors? In this class, you’ll discover how to push orders, products, customers, and more data directly into a Sheet—using nothing but simple code you can copy & paste! Say goodbye to extra costs and dependencies, and take full control of your data. Want to see how it’s done?

Hosted by Rodolfo Melogli

Session overview

Are you tired of relying on plugins, Zapier, Make, or other third-party services just to sync your WooCommerce data with Google Sheets? What if you could do it all yourself—with simple, copy-and-paste code?

In this exclusive class, you’ll learn exactly how to send WooCommerce data to Google Sheets without any external connectors. Whether you want to export orders, products, customers, or specific data, this session will give you full control over your integration.

Most WooCommerce store owners and developers rely on third-party automation tools to sync their data with Google Sheets. While these tools can be convenient, they often come with:

  • Recurring subscription fees – Paying monthly for something that should be simple.
  • Limited customization – You only get predefined integrations, not full flexibility.
  • Extra points of failure – If a plugin, API, or service goes down, your data stops syncing.

This webinar will teach you how to achieve the same (or even better) results without plugins or middleman apps. You’ll discover how to set up a direct connection from WooCommerce to Google Sheets using custom code, giving you complete control over how and when data is updated.

By attending this session, you’ll gain practical skills and insights, including:

  • How to connect WooCommerce to Google Sheets without Zapier or plugins.
  • How to push new WooCommerce orders, products, or customers into a Sheet automatically.
  • How to customize the data that gets sent (e.g., order details, stock levels, sales reports).
  • How to schedule automated updates without using third-party automation tools.

This is not a theoretical session. You’ll walk away with real, working code that you can implement immediately. Whether you’re a store owner, developer, or WooCommerce consultant, you’ll find these techniques incredibly useful for optimizing workflows and reducing reliance on external apps.

This webinar is perfect for:

  • WooCommerce store owners who want direct access to their data without plugin bloat.
  • Developers who need a flexible and customizable solution for exporting WooCommerce data.
  • Agencies and freelancers looking to offer better solutions to their clients.
  • Anyone tired of paying for third-party automation tools when a simple solution exists!

This is a live, interactive session where you’ll see everything in action and get the chance to ask questions. By the end of the class, you’ll have a fully working solution for syncing WooCommerce with Google Sheets—without any external apps.

Ready to take control of your WooCommerce data?

Author, WooCommerce expert and WordCamp speaker, Rodolfo has worked as an independent WooCommerce freelancer since 2011. His goal is to help entrepreneurs and developers overcome their WooCommerce nightmares. Rodolfo loves travelling, chasing tennis and soccer balls and, of course, wood fired oven pizza.
Rodolfo Melogli
Rodolfo Melogli@rmelogli

Video Recording

Sorry, this video recording is only visible to logged in Business Bloomer Club members.
If you are a member, please log in.
Otherwise, here is why you should join the Club.

Class Materials

Documentation

4 Steps to Integrate WooCommerce With Google Sheets

You can set up a Google Apps Script that receives data and writes it to a Google Sheet. Combine it with a WooCommerce webhook (/wp-admin/admin.php?page=wc-settings&tab=advanced&section=webhooks) to send order data when a new order is placed.

Step 1: Create a Google Sheet

And add column headers e.g. Order ID, Total, Products

Step 2: Open Apps Script

Click Extensions > Apps Script in the Google Sheet. Delete any existing code and replace it with one of the JavaScript snippets that you find below and Save.

Step 3: Deploy as a Web App

Click Deploy > New Deployment. Under “Select type,” choose Web app. Set Description: “WooCommerce Order Webhook”, Execute as: “Me”, Who has access: “Anyone”. Click Deploy. Grant permissions and copy the provided Web App URL.

Step 4: Add Webhook in WooCommerce

In WordPress, go to WooCommerce > Settings > Advanced > Webhooks. Click Add Webhook and configure Delivery URL = Paste the Web App URL from Step 3.

Code Snippets

/**
 * @snippet       Google App Script: append Woo order row
 * @author        Rodolfo Melogli, Business Bloomer
 * @compatible    WooCommerce 9
 * @community     https://businessbloomer.com/club/
 */

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);
  sheet.appendRow([
    data.id, 
    data.total, 
    data.line_items.map(item => item.name).join(", ")
  ]);
  return ContentService.createTextOutput("Success").setMimeType(ContentService.MimeType.TEXT);
}

/**
 * @snippet       Google App Script: append Woo product row
 * @author        Rodolfo Melogli, Business Bloomer
 * @compatible    WooCommerce 9
 * @community     https://businessbloomer.com/club/
 */

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);
  sheet.appendRow([
    data.id,
    data.name, 
    data.sku, 
    data.manage_stock ? data.stock_quantity : "n/a"
  ]);
  return ContentService.createTextOutput("Success").setMimeType(ContentService.MimeType.TEXT);
}

/**
 * @snippet       Google App Script: append Woo coupon row
 * @author        Rodolfo Melogli, Business Bloomer
 * @compatible    WooCommerce 9
 * @community     https://businessbloomer.com/club/
 */
 
function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);
  sheet.appendRow([
    data.date_created, // coupon date
    data.code, // coupon code
    data.discount_type, // coupon type
    data.amount // coupon amount
  ]);
  return ContentService.createTextOutput("Success").setMimeType(ContentService.MimeType.TEXT);
}

Upcoming masterclasses

As a Business Bloomer / WooWeekly subscriber you can attend as many live classes you wish – for free. Here’s a list of upcoming events (we usually take a break for June-August, otherwise you should expect about 2 classes per month). Make sure to attend live so you can interact with the teacher and the other attendees!

Available webinar recordings

As a Business Bloomer Club member you have full lifetime access to previous class recordings (as well as online courses, private community and more). Here’s the list of all past classes:

WooCommerce AMA with Rodolfo Melogli

Join me for an ‘Ask Me Anything About WooCommerce’ session – covering customization, development, plugins, analytics, marketing, forking, and more!…

– BACKED BY –

Is your WooCommerce store prepared for traffic spikes? Improve speeds up to 200% with our
managed WooCommerce hosting. Enjoy scalable server resources, rock-solid security, and 24/7 support.

#1 WooCommerce Website Development Agency

Pixel Manager for WooCommerce Plugin

Professional Plugins for WooCommerce Stores

High-Performance WooCommerce Hosting

IT Monks is a leading WordPress development agency with over 15 years of experience in custom WooCommerce design and development, delivering 500+ successful eCommerce projects.

Learn about sponsorship opportunities →

6 thoughts on “How to Sync WooCommerce & Google Sheets Without Plugins!”

  1. Azzurra

    Great tutorial, again! Thanks a lot, Rodolfo đŸ™‚

    Reply
    1. Rodolfo Melogli

      You’re welcome!

      Reply
  2. Condorito

    Hello Rodolfo,

    I registered for this masterclass, but unfortunately I was unavailable for the live session.
    Do you provide a replay ?

    Reply
    1. Rodolfo Melogli

      Sorry you couldn’t make it! Live events are free, but access to 25+ class recordings, 3 online courses, and WooCommerce support is reserved for lifetime Business Bloomer Club members. PPP discounts are available in most countries.

      Reply
  3. Amro

    Rodolfo, you always make great and helpful tutorials, thank you for sharing your WooCommerce experience

    Reply
    1. Rodolfo Melogli

      My pleasure!

      Reply
Leave a Reply

Your email address will not be published. Required fields are marked *