
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?
Video Recording
If you are a member, please log in.
Otherwise, here is why you should join the Club.
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§ion=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!
Send These 7 WooCommerce Emails & Watch Sales Grow
Think email marketing is too complicated? Think again… If you’re only sending…
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:
How to Find and Fix Slow Database Queries in WooCommerce
Learn how to resolve slow database queries in WordPress / WooCommerce websites. Use the right…
Live Coding a “Deal of the Week” Functionality For WooCommerce
I’ve always wanted to set up an automatic promotion on a different Woo product each…
Web Accessibility Basics for WooCommerce
Accessibility in ecommerce is increasingly a legal requirement, but it also helps you expand your…
How to Avoid Timeouts When Running Millions of WooCommerce Tasks
Meet Action Scheduler – a scalable processor of large queues of PHP jobs. Learn how…
WooCommerce Reimagined: Powering Up with the AI Advantage
Say goodbye to the same old, boring WooCommerce experience. Let’s dive in and see what…
Live Coding a WooCommerce LMS Plugin
Watch me code a simple WooCommerce plugin for selling and managing online courses. Masterclass overview…
WooCommerce No-Code Automations Make* Simple
* Not a spelling mistake. Here’s how you can build entire workflows and connect WooCommerce…
Better Than Subscriptions: Building a Re-order Page in WooCommerce
Transform WooCommerce re-ordering into a seamless, customer-centric experience that goes beyond the ordinary. Hosted by…
How to Contribute to WooCommerce Core
Learn how to contribute to the WooCommerce plugin code by submitting your first pull request…
– 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.
Hello Rodolfo,
I registered for this masterclass, but unfortunately I was unavailable for the live session.
Do you provide a replay ?
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.
Rodolfo, you always make great and helpful tutorials, thank you for sharing your WooCommerce experience
My pleasure!