How to Sync WooCommerce & Google Sheets Without Plugins!

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@rmelogli

Video Recording

Class Materials

Documentation

• WooCommerce Webhooks: learn more about webhooks, when you can trigger them, and what you can do with them
• Debugging in WordPress: how to enable WP_DEBUG, so you can see webhook content
• Google Apps Script: technical docs re: web app scripting

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://fa8faab2-7736-467b-aa28-860b32869022.express.conves.io/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://fa8faab2-7736-467b-aa28-860b32869022.express.conves.io/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://fa8faab2-7736-467b-aa28-860b32869022.express.conves.io/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);
}

More WooCommerce Masterclasses

Here’s a list of free live webinars and member-only class recordings (we usually take a break for June-August, otherwise you should expect about 2 live classes per month). Make sure to attend live so you can interact with the teacher and the other attendees!

– 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.

Learn about sponsorship opportunities →