How WooCommerce data reaches Google Sheets

WooCommerce Google Sheet Connector PRO connects a WooCommerce store to Google Sheets. New orders can be added to a selected spreadsheet as rows in real time, with separate tabs for default or custom order statuses. Tabs can represent statuses such as Processing, Completed, Pending, Cancelled and Refunded. Teams can use these spreadsheet views for reporting, order analysis, inventory planning and collaboration.

Which data can you sync?

PRO supports synchronization of orders, products, product variations, coupons and customers. You can import existing orders, missed entries, or data selected by order status or date range. Cron-based synchronization can execute at user-defined intervals.

For supported orders, products, variations, coupons and customers, data can move between WooCommerce and Google Sheets. The plugin also supports custom fields and meta fields, including data from third-party plugins. Choose from three integration methods, create multiple feeds for various spreadsheets, or set up individual feeds for orders, products, variations, customers and coupons. Product category filters let you choose which products to sync.

How can teams organize spreadsheet data?

Customize header names and pick a row structure organized by order or product. You can freeze headers, add header colors and apply alternating row backgrounds. Separate feeds and order-status tabs help organize the spreadsheet around the information a team needs to review. Advanced error logs provide synchronization activity for tracking and troubleshooting.

Accounting teams can review orders, marketing teams can work with customer and coupon data, and inventory planning can use product and variation entries. The plugin is compatible with more than 50 popular WooCommerce add-on extensions.

How do you connect a spreadsheet?

1. Sign in to Google Sheets and create a spreadsheet, or prepare one you already use.
2. In WordPress, open WooCommerce > Google Sheet > Integration, select Get Code, complete Google authentication, allow the requested Google Drive and Google Sheets permissions, then save the access code.
3. Fetch the spreadsheet details for the WooCommerce settings.
4. Open WooCommerce > Google Sheet > WooCommerce Data Settings and select a spreadsheet from the available list.
5. Choose the order statuses, create the needed tabs and headers, then test the connection by placing an order and changing its status.

After connecting, review the feeds, headers, category filters and synchronization settings to make sure the spreadsheet matches your reporting and store-management workflow.