woocommerce to google sheets

WooCommerce Docs

Documentation, Reference Materials, and Tutorials for your WooCommerce products

Save New WooCommerce Orders to Google Sheets

Keep a log of your WooCommerce orders on Google Sheets with Zapier .

Prepare your accounts ↑ Back to top

Install Zapier: To connect your WooCommerce store to Zapier, ensure that you have the WooCommerce Zapier extension installed. Learn more about WooCommerce on Zapier at Getting Started with Zapier and WooCommerce .

Create a Google spreadsheet: To link Google Sheets to your WooCommerce store using Zapier, you need to create a new spreadsheet. Learn more about Google Sheets on Zapier at Getting Started with Zapier and Google Sheets and Create Google Sheets .

Connect your accounts ↑ Back to top

To save new WooCommerce orders as rows on a Google Sheet , you need to connect your WooCommerce store to Google.

1. Copy and paste the provided URL into the Webhook URL field on your WordPress dashboard.

2. Click the Ok, continue button.

3. Confirm that you have a working spreadsheet on Google Sheets, and click Ok, continue.

4. Log into your Google account with Email Address and Password, or select an already connected account.

5. Click Allow when Zapier requests access.

5. Select the Spreadsheet and Worksheet where you want to save order details. Then match the fields from WooCommerce with the fields in Google Sheets.

6. Click Save + Finish to complete the Zap.

7. Test the Zap to make sure it works.

Once you’re satisfied, WooCommerce orders can be saved as rows on Google Sheets!

FAQ ↑ Back to top

How do I make changes?

If you want to alter the Zapier and WooCommerce integration, go to your Zapier dashboard and tweak anything you wish.

What else can I do with WooCommerce on Zapier?

Check out everything that’s possible with WooCommerce on Zapier , plus other ways to connect Google Sheets and WooCommerce .

Relevant Links

Installing and Activating WooThemes Licenses

How to Get Help

WooCommerce – the most customizable eCommerce platform for building your online business.

Google Sheets and WooCommerce Integration

Keep your team informed and collaborate better. Connect Google Sheets and WooCommerce. Run workflows.

Popular Integrations

Add a Row in Google Sheets on a New Product in WooCommerce

Add or Update Customer in WooCommerce on a New Row in Google Sheets

Add a Row in Google Sheets on a New Customer in WooCommerce

Add or Update Customer in WooCommerce on a New Row (old) in Google Sheets

Update a Row in Google Sheets on a New Product in WooCommerce

Add a Row in Google Sheets on a New Order in WooCommerce

Add a Row in Google Sheets on a New Order Line Item in WooCommerce

Update a Row in Google Sheets on a New Customer in WooCommerce

Looking for something else?

Create your own Integration

  • New Row (old)
    Triggers when a new row is added in a worksheet
  • New Row
    Triggers when a new row is added in a worksheet (recommended)
  • New Spreadsheet
    Triggers when a Spreadsheet is created
  • New Worksheet
    Triggers when a Worksheet is created
  • New Customer
    Triggers when there is a new Customer
  • New Order
    Triggers when there is a new Order. This will trigger for orders with any Order Status, such as, Completed, Cancelled, Failed, Refunded, etc.
  • New Order Line Item
    Triggers for each line item of a new Order.If there is a new Order with 5 Line Items, the bot will run 5 times, each time with the details of one of the Line Items
  • New Product
    Triggers when there is a new Product
  • Modified Customer
    Triggers when Customer data gets Modified or when new Customer is Created
  • Order Status Changed
    Triggers when the Order Status changes to the Selected Status, or when a new Order is created with the Selected Status

  • Add or Update Customer
    Add a new Customer or Update an existing Customer
  • Add an Order
    Add a new Order
  • Add Order Line Item
    Add Line Item to an existing Order
  • Add or Update a Product
    Add a new Product or Update an existing Product
  • Add or Update a Product Variation
    Add a new Product Variation or Update an existing Product Variation
  • Search Customers
    Search a Customer based on Email Address or Customer Id
  • Update an Order
    Update an existing Order
  • Search Orders
    Search for an existing Order
  • Search Products
    Search for an existing Product
  • Search Product Variantions
    Search for an existing Product Variantion
  • Add a Row
    Adds a new row to a given Worksheet
  • Add a Worksheet
    Adds a new Worksheet to a given Spreadsheet
  • Search Rows
    Searches a row based on column value
  • Update a Row
    Update a row in a given Worksheet based on row id
  • Add a Row (v4)
    Adds a new Row. Use this only if you have an issue with the other ‘Add Row’ action.
  • Delete a Row
    Delete a Row from the specified Worksheet based on the Row ID

Create your custom integration by selecting the Trigger event and Action to be performed.

Run Workflows

Connect Google Sheets and WooCommerce with your other apps and run workflows across them.
Trigger workflows automatically when things happen in any of the apps.

Zero coding. No change in existing apps.

About Google Sheets

Google Sheets is a fully featured web spreadsheet application that is also available on major mobile platforms. Create, share and collaborate on spreadsheets on web and mobile.

About WooCommerce

WooCommerce is a powerful and highly customizable Ecommerce platform built on top of WordPress. It offers all you need to create a store and sell online.

Leave a Reply

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