Connect Google Sheets with WooCommerce
Connect Google Sheets with WooCommerce to scale and automate your operations.
Explore automation templates
Automate Google Sheets and WooCommerce with Pluga integrations
For each created order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
For each failed order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
For each completed order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
For each order processing on WooCommerce, add data to a new row on a Google Sheets spreadsheet
For each refunded order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
For each cancelled order on WooCommerce, add data to a new row on a Google Sheets spreadsheet
For each order awaiting payment on WooCommerce, add data to a new row on a Google Sheets spreadsheet
For each created order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
For each failed order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
For each completed order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
For each order processing on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
For each refunded order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
For each cancelled order on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
For each order awaiting payment on WooCommerce, update or add data in a new row of a Google Sheets spreadsheet
For each created order on WooCommerce, add the data to multiple rows in a Google Sheets spreadsheet
Didn't find the template you wanted? Build the integration your own way. ;)
Google Sheets and WooCommerce
your way
Check out the available triggers and actions in the automation of apps Google Sheets + WooCommerce
New added row
When a new row is added on Google Sheets
Line No.
Cancelled order
For each cancelled order on WooCommerce
Order items
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
Anotações do cliente
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 WooCommerce
Order items
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
Anotações do cliente
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
For each row created/updated
For each row created or updated in Google Sheets
Nº da linha
Completed order
For each completed order on WooCommerce
Order items
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
Anotações do cliente
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 WooCommerce
Order items
Order ID/number
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
Anotações do cliente
Payment method
ID do método de pagamento
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
Created order
For each created order on WooCommerce
Order items
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
Anotações do cliente
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 WooCommerce
Order items
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
Anotações do cliente
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 WooCommerce
Order items
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
Anotações do cliente
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 spreadsheet
Columns
Insert/update row in spreadsheet
add or update data in Google Sheets spreadsheet's row(s)
Insert multiple rows in spreadsheet (only for multiple items)
add the data to multiple rows in a Google Sheets spreadsheet
Search rows in a spreadsheet
Search rows in a spreadsheet in Google Sheets
Search Column Required
Condition
Search value
Additional filters
Result limit
No rows found?
Boost this flow in your workflow
With Pluga, you connect Google Sheets + WooCommerce to build anything from the simplest integration to the most advanced flows, with several layers of logic.
- Basic 1
Pick the source app and the trigger
Choose which app starts the automation and which event works as the trigger. For example, "For each order processing on WooCommerce".
- Basic 2
Set the destinations and the actions
Select the apps that make up the flow with Google Sheets and what Pluga should run automatically at each step. Example: "add or update data in Google Sheets spreadsheet's row(s)"
- Basic 3
Map the information
Point out, visually, which data from the source app should fill in each field of the destination action.
- Intermediate
Only move forward when it makes sense
Set "AND" or "OR" conditions so the automation only runs in the cases that matter
- Intermediate
Pause the flow for as long as you need
Set the automation to wait minutes, hours or days and resume the next action on its own
- Intermediate
Standardize data across apps
Adjust dates, numbers and characters to the format the next app expects to receive
- Advanced
Send data in several directions
Route each piece of data down the right path within a single flow, according to specific conditions
- Advanced
Add a code block
Run JavaScript or Python in the middle of the automation to transform data before the next step
- Advanced
Create loops
Take lists of items, go through each row and run the same action for every one of them
- Advanced
Use generative AI
Send data to an AI assistant or agent and use the response in the next step
- Advanced
Connect to (almost) any app
Send and receive data through a dedicated URL, and connect to apps that are not integrated with Pluga
- Advanced
Requests to external APIs
Query or send data to any external API inside your automation
Google Sheets
SpreadsheetConnect Google Sheets to 133+ apps with Pluga and turn your work into a productive machine. Centralize data from several apps in a single spreadsheet, keep your reports updated in real time and use the spreadsheet as a bridge between the apps you already work with.
WooCommerce
E-commerceConnect WooCommerce to 133+ apps with Pluga and turn your work into a productive machine. Automate order processing — created, paid, shipped or cancelled: each stage triggers the next steps, from customer notifications to finance and inventory entries.