WordPress.org

Plugin Directory

GSheetConnector for WooCommerce – Send your Orders and Products to Google Sheet in Real-Time

GSheetConnector for WooCommerce – Send your Orders and Products to Google Sheet in Real-Time

Descripción

GSheetConnector for WooCommerce is a powerful and easy-to-use Google Sheets integration plugin that connects your WooCommerce store directly with Google Sheets. Automatically sync WooCommerce orders, products, customers, and more into a Google Spreadsheet to organize, analyze, and manage your store data efficiently.

With real-time data sync, every new WooCommerce order is instantly added as a new row in your selected Google Sheet. You can also create separate tabs based on order status (Processing, Completed, Pending, Cancelled, Refunded) for better tracking and reporting.

This plugin is perfect for store owners, marketing teams, and accounting departments who want a simple and reliable way to maintain WooCommerce order data for reporting, analytics, inventory planning, and team collaboration.

🚀 Why Use This Plugin?

➜ Real-time sync of WooCommerce orders to Google Sheets
➜ Sync Products, Product Variations, Coupons, and Customers
➜ Automatically create separate sheets tabs based on order status
➜ Customize and organize column headers in Google Sheets
➜ Simple and secure Google account authentication
➜ Debug logs for quick troubleshooting

🧪 Check Live Demo

Demo Link: Open Demo

Google Sheet (View Submitted Data): View Sheet

Cómo usar este plugin

  • Paso: 1 – En Hojas de cálculo de Google
    ➜ Inicia sesión en tus Hojas de cálculo de Google.
    ➜ Crea una hoja nueva y nómbrala. (También puedes seleccionar una hoja existente mientras configuras la conexión según el Paso 3).

  • Paso: 2 – En el administrador de WordPress
    ➜ Ve a WooCommerce > Hoja de Google > Pestaña Integración
    ➜ Identifícate con Google usando el nuevo «Código de acceso de Google» mientras haces clic en «Obtener código»
    ➜ Asegúrate de PERMITIR los permisos de Google para Google Drive y Google Sheets y luego copia el código y pégalo en el campo Código de acceso de Google, y presiona Guardar & Identificar.
    ➜ Ahora obtén los detalles de la hoja haciendo clic en «Haz clic aquí para obtener los detalles de la hoja que se establecerán en los ajustes de WooCommerce».

  • Paso: 3 – Conectar con Google Sheet
    ➜ Ve a WooCommerce > Hoja de Google > Ajustes de datos de WooCommerce.
    ➜ Selecciona la hoja adecuada en el cuadro desplegable «Nombre de la hoja de Google».
    ➜ Selecciona Estado del pedido de WooCommerce para crear pestañas de hoja y añadir cabeceras a tu hoja de Google seleccionada.
    ➜ Por último, prueba pidiendo cualquier producto y colocándolo en diferentes estados de pedido (Procesando, En espera, etc.).

🚀 Pro Plugin Features

➜ Sync all WooCommerce orders (default + custom order statuses) to Google Sheets in real time.
➜ Sync all Products, Product Variations, Coupons, and Customers.
➜ Sync existing orders, missed entries, and data based on order status or date range.
➜ Cron-based automatic syncing at user-defined time intervals.
➜ Bi-directional sync for Orders, Products, Variations, Coupons, and Customers (Google Sheet WooCommerce).
➜ Sync Custom Fields and Meta Fields (including third-party plugin data).
➜ Choose from three different integration methods based on organizational needs.
➜ Create multiple feeds and send data to different Google Sheets as required.
➜ Create Individual feeds with individual sheets for Orders, Products, Products Variations, Users & Coupons
➜ 2-way Sync – Send data from Google Sheets to your WooCommerce store via the connected sheet.
➜ Easy tracking and monitoring through advanced error logs.
➜ Freeze headers, add header color, and apply odd/even row background colors in Google Sheets.
➜ Manage data row structure order-wise or product-wise.
➜ Filter and sync data based on selected product categories.
➜ Add and customize header names as needed.
➜ Compatible with 50+ popular WooCommerce add-on plugins.
🔒 Upgrade to Pro? Get it Now

🔗 Other Google Sheets Integrations

Contact Forms to Google Sheet Integration
CF7 GSheetConnector Pro
WPForms GSheetConnector Pro
Gravity Forms GSheetConnector Pro
Ninja Forms GSheetConnector pro
Forminator Forms GSheetConnector Pro
Formidable Forms GSheetConnector Pro
Fluent Forms GSheetConnector Pro

eCommerce to Google Sheet Integration
WooCommerce GSheetConnector PRO
GSheetConnector PRO for Easy Digital Downloads

Page Builders to Google Sheet Integration
Elementor Forms Google Sheet Connector
Avada Forms Google Sheet Connector
DIVI Forms Google Sheet Connector
GSheetConnector For Core

Capturas

  • Google Sheet Integration Shown with Authentication along with Permissions.
  • Fetch Sheets.
  • Google Sheet Tab Creation as per order status and Google Sheet headers with form submitted data.
  • Role Settings.
  • Beta-version.
  • System Status.
  • Feed Settings.
  • 2way Sync.
  • Extensions.

Instalación

  1. Sube «wc-gsheetconnector» en el directorio «/wp-content/plugins/», o «Administrador del sitio > Plugins > Nuevo > Buscar > GSheetConnector WooCommerce > Instalar».
  2. Activa el plugin a través de la pantalla de «Plugins» en WordPress.
  3. Usa el Panel de administrador > WooCommerce > Hoja de Google > Pantalla de integración para conectarte a Hojas de cálculo de Google ingresando el código de acceso. Puedes obtener el código de acceso haciendo clic en el botón «Obtener código».
    ¡Disfruta!

FAQ

¿Los nuevos pedidos enviados no se muestran en mi hoja configurada?

Si los nuevos pedidos enviados nunca aparecen en tu hoja, entonces una de estas cosas podría ser la razón:
1. Código de acceso incorrecto o no hubo permisos para Google Drive y Google Sheets (comprueba el registro de depuración en la pestaña Integración)
Vuelva a comprobar esos elementos y, con suerte, corregirlos solucionará el problema.

Ver el registro de depuración está vacío en las pestañas de integración

Asegúrate de activar el registro de depuración de wp-config.php si el pedido enviado no se muestra en la hoja, ayudará a mostrar el problema del conflicto (si lo hay) o muestra lo que está causando un problema.

Reseñas

15 de abril de 2025
There were errors in the plugin, but they were resolved by the support team. Huge thanks to them for their effort and assistance—it was a great help. The plugin is now working well and syncing perfectly with the Google Sheet.
18 de marzo de 2025 1 respuesta
WooCommerce Google Sheet Connector has been a game-changer for my organization! It completely streamlined our order processing and made managing WooCommerce data effortless. Before using this plugin, accessing and understanding our orders, products, and customer data was a challenge. Now, everything is neatly organized in Google Sheets, with automatic syncing, editable headers, and status-based sheets. Beyond the great functionality, the technical support is phenomenal—responsive, knowledgeable, and always willing to help. If you want to simplify your WooCommerce data management, I highly recommend this plugin!
8 de septiembre de 2023 1 respuesta
This has been a great plugin! The team has also been a great support.
Leer todas las 14 reseñas

Colaboradores y desarrolladores

«GSheetConnector for WooCommerce – Send your Orders and Products to Google Sheet in Real-Time» es un software de código abierto. Las siguientes personas han colaborado con este plugin.

Colaboradores

«GSheetConnector for WooCommerce – Send your Orders and Products to Google Sheet in Real-Time» está traducido en 2 idiomas. Gracias a los traductores por sus contribuciones.

Traduce «GSheetConnector for WooCommerce – Send your Orders and Products to Google Sheet in Real-Time» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios

1.4.7 (25-03-2026)

  • Fixed: Addressed all identified issues to improve overall stability and compliance.

1.4.6 (14-11-2025)

  • Added: «Next Steps…» section in the Integration tab.
  • Updated: Updated the header logo and the dashboard widget logo.
  • Fixed: Improved responsive CSS.

1.4.5 (19-09-2025)

  • Added: Feed settings for Pro features.
  • Updated: Readme file.
  • Updated: UI design improvements.

1.4.4 (23-07-2025)

  • Added: Extension tab added.
  • Added: Debug logs file will be created under wp-upload folder.
  • Moved freemius folder under Library folder insider vendor folder.

1.4.3 (16-07-2025)

  • Fixed: Solved Licensing/Trademark issues in main plugin file and readme.
  • Removed direct links to 5-star reviews to comply with WordPress plugin guidelines.
  • Updated “Tested Up To” value to reflect compatibility with the latest WordPress version.
  • Replaced static and tags with wp_enqueue_script and wp_enqueue_style for proper asset loading and dependency management.
  • Eliminated all remote file inclusions to improve security and meet WordPress repository requirements.
  • Removed plugin folder write operations and any instructions requiring users to manually edit/write files inside the plugin directory.
  • Escaped all variables and options before outputting to the frontend or admin interface.
  • Replaced generic function/class/constant/option names with properly prefixed versions to avoid naming collisions.
  • Corrected text domain to match the plugin slug for consistent internationalization support.
  • Blocked direct file access by adding appropriate file-level checks (e.g., defined( ‘ABSPATH’ ) || exit;).
  • Implemented proper nonce verification and security best practices throughout AJAX and form submissions.
  • Passed Plugin Check review with all critical issues resolved.

1.3.20 (21-04-2025)

  • Fixed: Connected Email display issue.

1.3.19 (19-04-2025)

  • Added: Moved saving of credentials to database for Auto API Integration.

1.3.18 (27-01-2025)

  • Fixed: Minor UI Changes.
  • Added: Require plugins added.

1.3.17 (07-01-2025)

  • Added: A Dashboard Widget has been added.
  • Added: Showcased the «Manual Method» button on the Integration tab.
  • Added: The «Copy Log» button has been added.
  • Fixed: Undefined error when clicking the «Copy to Clipboard» button in the System Info tab.
  • Fixed: The issue with the Debug Log view and the close button has been fixed.

1.3.16 (27-07-2024)

  • Fixed: The issue of the Shipping Method Title Field displaying code in the sheet has been resolved.

1.3.15 (07-06-2024)

  • Fixed: Undefined error.

1.3.14 (04-04-2024)

  • Fixed: UI changes.
  • Added: Added links for support,docs and upgrade to pro.

1.3.13 (20-02-2024)

  • Secured code from the Vulnerabilities.

1.3.12 (16-02-2024)

  • Fixed: Uninstallation of Plugin.
  • Added: Pro features(Custom Order Status,Other Sheet Tabs to Enable,Custom Static Headers,Custom Static Blank Headers, Coupons Header,Subscriptions Header,Sync Coupons,Sync Subscriptions ) display on woocommerce data settings page and also Pro features display(Beta Version, Debug Logs)Tabs.

1.3.11 (29-12-2023)

  • Fixed : Fixed validate parent plugin exists or not then show alert message display issue.

1.3.10 (02-12-2023)

  • Added : Orders Header – Values ​​are shown in extra header related to order and extra header related to order’s product option.

1.3.9 (17-10-2023)

  • Fixed : Undefined image path issue resolved.

1.3.8 (13-10-2023)

  • Fixed : Solved Conflict CSS Issue in Google Sheet Tab Settings.

Version 1.3.8 (09-10-2023)

Key Highlights:

  • Client library updated : Google API V-2.12.6 .
  • Authorization Form Settings: Alerts for Unauthorized Access.
  • Streamlined Authentication: Replaced «Get Code» button with «Sign in with Google» for ease of use.
  • Permissions Alert: Users lacking Google Drive and Sheets permissions now receive a clear alert during authentication.
  • Enhanced System Status: Redesigned System Status and Error Log for improved functionality.
  • Pro-Version Feature Expansion: Extended a Pro-Version feature tab for added capabilities.

Bug Fixes and Updates:

  • Deprecation Fixes: Resolved deprecated function errors related to Freemius integration.
  • Multi-Site Optimization: Freemius optimized for multi-site compatibility.
  • UI Enhancements: Several user interface fixes and additions to the Integration Page.

1.3.6 (07-08-2023)

  • Fixed : Vulnerabilities issues.

1.3.5 (05-07-2023)

  • Updated Freemius SDK version to 2.5.10.

1.3.4 (08-06-2023)

  • Fixed : Undefined option issues is resolved.
  • Change UI : Pro features display on setting page and Integration Page.

1.3.3 (28-04-2023)

  • Fixed : Vulnerabilities issue resolved.

1.3.2 (08-04-2023)

  • Removed unused code.

1.3.1 (15-03-2023)

  • Undefined «get_sku()» function issue resolved.

1.3.0 (02-08-2022)

  • Freemius issues resolved: (1)Undefined property: stdClass::$plugins

1.2.9 (01-08-2022)

  • Problemas de Freemius – (1)recuento (): el parámetro debe ser un array o los problemas de un objeto se resuelven.

1.2.8 (30-07-2022)

  • Se ha resuelto el problema del nombre incorrecto de la opción.

1.2.7 (29-07-2022)

  • Nuevo método de integración de Google implementado mediante una aplicación web.
  • Optimización de código

1.2.6 (18-06-2022)

  • Compatible con WooCommerce GSheetConnector PRO.

1.2.5 (30-05-2022)

  • ¿Se resolvió el error del plugin activo en algunos casos?

1.2.4 (28-05-2022)

  • Gratis y Pro, ambos plugins se pueden activar al mismo tiempo.

1.2.3 (21-03-2022)

  • Freemius SDK actualizado a 2.4.3
  • Aviso de PHP resuelto: «Propiedad no definida: stdClass::$plugin»
  • Advertencia de PHP resuelta: «count(): el parámetro debe ser un array o un objeto que implemente contable»

1.2.2 (22-02-2022)

  • Se modificó la interfaz de usuario de la página de ajustes de la hoja de Google.

1.2.1 (18-09-2021)

  • Error de aviso resuelto para WooCommerce como plugin obligatorio.

1.2 (12-09-2021)

  • Integración Freemius.

1.1 (18-11-2021)

  • Added Validation For Google Settings Form.
  • Corregido: se producen errores al actualizar los pedidos sin cambiar el estado del pedido.

1.0 Released Initial version