Automate WooCommerce with Google Sheets
Unlock the superpowers of WooCommerce + Google Sheets and automate your tasks without having to write a single line of code.
WooCommerce and Google Sheets
your way
Check out the available triggers and actions in the automation of apps WooCommerce + Google Sheets
Created order
For each created order on WooCommerceTrigger
ID
Status
Coin
Discount
Shipping
Taxa
Total
Total in Reais (text)
Date/Time Created (ISO8601 formatted)
Date/Time Created (formatted YYYY-MM-DD H:M:S)
Update date/time
Update date/time (formatted YYYY-MM-DD H:M:S)
Payment Date/Time (ISO8601 formatted)
Payment Date/Time (formatted YYYY-MM-DD H:M:S)
Date/Time Approved (ISO8601 formatted)
Date/Time Approved (formatted YYYY-MM-DD H:M:S).
Customer ID
Payment method
Transaction ID
Item Names
Product IDs with variation
SKU and quantity of products
Product SKU
Quantity of products
Subtotal of products separated by commas
Line-items parent names
Total amount of fees
Total amount of fees without discount
Total amount of fee discounts
Delivery Titles
Billing Email
Billing Name
Billing surname
Billing Company
Billing phone
Billing cell phone
Billing address
Billing Supplement
City of Collection
Billing State
Billing Country
Billing Zip Code
Billing Number
Cobrança neighborhood
Billing Person Type
Billing CPF
Billing CNPJ
Billing ID
Delivery Name
Delivery Surname
Delivery Company
Delivery address
Delivery Complement
Delivery City
Delivery State
Delivery Zip Code
Delivery Country
Delivery Phone
Delivery number
Delivery District
Coupons
Failed order
For each failed order on WooCommerceTrigger
ID
Status
Coin
Discount
Shipping
Taxa
Total
Total in Reais (text)
Date/Time Created
Date/Time Created (formatted YYYY-MM-DD H:M:S).
Update date/time
Update date/time (formatted YYYY-MM-DD H:M:S).
Payment Date/Time
Payment Date/Time (formatted YYYY-MM-DD H:M:S)
Date/Time Completed
Date/Time Completed (formatted YYYY-MM-DD H:M:S).
Customer ID
Payment method
Transaction ID
Item Names
Product IDs with variation
SKU and quantity of products
Product SKU
Quantity of products
Subtotal of products separated by commas
Line-items parent names
Total amount of fees
Total amount of fees without discount
Total amount of fee discounts
Delivery Titles
Billing Email
Billing Name
Billing surname
Billing Company
Billing phone
Billing cell phone
Billing address
Billing Supplement
City of Collection
Billing State
Billing Country
Billing Zip Code
Billing Number
Cobrança neighborhood
Billing Person Type
Billing CPF
Billing CNPJ
Billing ID
Delivery Name
Delivery Surname
Delivery Company
Delivery address
Delivery Complement
Delivery City
Delivery State
Delivery Zip Code
Delivery Country
Delivery Phone
Delivery number
Delivery District
Coupons
Refunded order
For each refunded order on WooCommerceTrigger
ID
Status
Coin
Discount
Shipping
Taxa
Total
Total in Reais (text)
Date/Time Created
Date/Time Created (formatted YYYY-MM-DD H:M:S).
Update date/time
Update date/time (formatted YYYY-MM-DD H:M:S).
Payment Date/Time
Payment Date/Time (formatted YYYY-MM-DD H:M:S)
Date/Time Completed
Date/Time Completed (formatted YYYY-MM-DD H:M:S).
Customer ID
Payment method
Transaction ID
Item Names
Product IDs with variation
SKU and quantity of products
Product SKU
Quantity of products
Subtotal of products separated by commas
Line-items parent names
Total amount of fees
Total amount of fees without discount
Total amount of fee discounts
Delivery Titles
Billing Email
Billing Name
Billing surname
Billing Company
Billing phone
Billing cell phone
Billing address
Billing Supplement
City of Collection
Billing State
Billing Country
Billing Zip Code
Billing Number
Cobrança neighborhood
Billing Person Type
Billing CPF
Billing CNPJ
Billing ID
Delivery Name
Delivery Surname
Delivery Company
Delivery address
Delivery Complement
Delivery City
Delivery State
Delivery Zip Code
Delivery Country
Delivery Phone
Delivery number
Delivery District
Coupons
Cancelled order
For each cancelled order on WooCommerceTrigger
ID
Status
Coin
Discount
Shipping
Taxa
Total
Total in Reais (text)
Date/Time Created
Date/Time Created (formatted YYYY-MM-DD H:M:S)
Update date/time
Update date/time (formatted YYYY-MM-DD H:M:S)
Payment Date/Time
Payment Date/Time (formatted YYYY-MM-DD H:M:S)
Date/Time Completed
Date/Time Completed (formatted YYYY-MM-DD H:M:S)
Customer ID
Payment method
Transaction ID
Item Names
Product IDs with variation
SKU and quantity of products
Product SKU
Quantity of products
Subtotal of products separated by commas
Line-items parent names
Total amount of fees
Total amount of fees without discount
Total amount of fee discounts
Delivery Titles
Billing Email
Billing Name
Billing surname
Billing Company
Billing phone
Billing cell phone
Billing address
Billing Supplement
City of Collection
Billing State
Billing Country
Billing Zip Code
Billing Number
Cobrança neighborhood
Billing Person Type
Billing CPF
Billing CNPJ
Billing ID
Delivery Name
Delivery Surname
Delivery Company
Delivery address
Delivery Complement
Delivery City
Delivery State
Delivery Zip Code
Delivery Country
Delivery Phone
Delivery number
Delivery District
Coupons
Waiting order
For each order awaiting payment on WooCommerceTrigger
ID
Status
Coin
Discount
Shipping
Taxa
Total
Total in Reais (text)
Date/Time Created
Date/Time Created (formatted YYYY-MM-DD H:M:S).
Update date/time
Update date/time (formatted YYYY-MM-DD H:M:S).
Payment Date/Time
Payment Date/Time (formatted YYYY-MM-DD H:M:S)
Date/Time Completed
Date/Time Completed (formatted YYYY-MM-DD H:M:S).
Customer ID
Payment method
Transaction ID
Item Names
Product IDs with variation
SKU and quantity of products
Product SKU
Quantity of products
Subtotal of products separated by commas
Line-items parent names
Total amount of fees
Total amount of fees without discount
Total amount of fee discounts
Delivery Titles
Billing Email
Billing Name
Billing surname
Billing Company
Billing phone
Billing cell phone
Billing address
Billing Supplement
City of Collection
Billing State
Billing Country
Billing Zip Code
Billing Number
Cobrança neighborhood
Billing Person Type
Billing CPF
Billing CNPJ
Billing ID
Delivery Name
Delivery Surname
Delivery Company
Delivery address
Delivery Complement
Delivery City
Delivery State
Delivery Zip Code
Delivery Country
Delivery Phone
Delivery number
Delivery District
Coupons
New added row
When a new row is added on Google SheetsTrigger
Line No.
Completed order
For each completed order on WooCommerceTrigger
ID
Status
Coin
Discount
Shipping
Taxa
Total
Total in Reais (text)
Date/Time Created
Date/Time Created (formatted YYYY-MM-DD H:M:S).
Update date/time
Update date/time (formatted YYYY-MM-DD H:M:S).
Payment Date/Time
Payment Date/Time (formatted YYYY-MM-DD H:M:S)
Date/Time Completed
Date/Time Completed (formatted YYYY-MM-DD H:M:S).
Customer ID
Payment method
Transaction ID
Item Names
Product IDs with variation
SKU and quantity of products
Product SKU
Quantity of products
Subtotal of products separated by commas
Line-items parent names
Total amount of fees
Total amount of fees without discount
Total amount of fee discounts
Delivery Titles
Billing Email
Billing Name
Billing surname
Billing Company
Billing phone
Billing cell phone
Billing address
Billing Supplement
City of Collection
Billing State
Billing Country
Billing Zip Code
Billing Number
Cobrança neighborhood
Billing Person Type
Billing CPF
Billing CNPJ
Billing ID
Delivery Name
Delivery Surname
Delivery Company
Delivery address
Delivery Complement
Delivery City
Delivery State
Delivery Zip Code
Delivery Country
Delivery Phone
Delivery number
Delivery District
Coupons
Processing order
For each order processing on WooCommerceTrigger
ID
Status
Coin
Discount
Shipping
Taxa
Total
Total in Reais (text)
Date/Time Created
Date/Time Created (formatted YYYY-MM-DD H:M:S).
Update date/time
Update date/time (formatted YYYY-MM-DD H:M:S).
Payment Date/Time
Payment Date/Time (formatted YYYY-MM-DD H:M:S)
Date/Time Completed
Date/Time Completed (formatted YYYY-MM-DD H:M:S).
Customer ID
Payment method
Transaction ID
Item Names
Product IDs with variation
SKU and quantity of products
Product SKU
Quantity of products
Subtotal of products separated by commas
Line-items parent names
Total amount of fees
Total amount of fees without discount
Total amount of fee discounts
Delivery Titles
Billing Email
Billing Name
Billing surname
Billing Company
Billing phone
Billing cell phone
Billing address
Billing Supplement
City of Collection
Billing State
Billing Country
Billing Zip Code
Billing Number
Cobrança neighborhood
Billing Person Type
Billing CPF
Billing CNPJ
Billing ID
Delivery Name
Delivery Surname
Delivery Company
Delivery address
Delivery Complement
Delivery City
Delivery State
Delivery Zip Code
Delivery Country
Delivery Phone
Delivery number
Delivery District
Coupons
Insert row in spreadsheet
add data to a new row on a Google Sheets spreadsheetAction
Columns
Update/insert row in spreadsheet
update or add data in Google Sheets spreadsheet's row(s)Action
Didn't find your use case? Send suggestion.
Automate WooCommerce and Google Sheets
with Pluga integrationsExplore automation templates
For each created order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each failed order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each completed order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each order processing on WooCommerce, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each refunded order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each cancelled order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each order awaiting payment on WooCommerce, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each created order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each failed order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each completed order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each order processing on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each refunded order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each cancelled order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each order awaiting payment on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREMiss an automation with this apps?
Say to us!How to integrate apps with Pluga?
Pluga allows you to integrate two or more apps in a simple, practical way without needing to type a single line of code. Here are the steps to automate your tasks and start focusing on what really matters.
Automate WooCommerce + Google Sheets
and say goodbye to manual (and tedious) tasks!
By connecting the apps you use through Pluga, you can automate various processes in your routine and have time for tasks that really matter. WooCommerce
EcommerceWooCommerce is an e-commerce plugin for WordPress. This app allows creating and managing online stores, adding products, processing payments, managing inventory, and analyzing sales.
Integrations with WooCommerce Visit WooCommerceGoogle Sheets
SpreadsheetGoogle Sheets is Google's online spreadsheet app that allows users to create, edit, share, and collaborate on documents both synchronously and asynchronously. It's a versatile tool for any type and size of business, serving purposes from CRM to inventory management spreadsheets.
Integrations with Google Sheets Visit Google Sheets