WooCommerce Google Spreadsheet Addon
Add a new row to the spreadsheet when a new order is placed on your site.
You can add it to any number of sheets with no restrictions.
Submitted data is added as a new row in the selected Sheet within the Spreadsheet, allows mapping of order data to sheet headers so that only selective data is added to sheet.
Order data which can be added to the Sheet:
- -Order ID
- -Order Number
- -Order Date
- -Order Status
- -Shipping Method Title
- -Payment Method Title
- -Transaction ID
- -View Order URL
- -User ID
- -Billing First Name
- -Billing Last Name (Surname)
- -Billing Company Name
- -Billing Email Address
- -Billing Phone Number
- -Billing Address
- -Billing Address (Line 1)
- -Billing Address (Line 2)
- -Billing City
- -Billing State/Province
- -Billing State/Province Name
- -Billing Postcode / Zipcode
- -Billing Country (2 letter code)
- -Billing Country Name
- -Shipping First Name
- -Shipping Last Name (Surname)
- -Shipping Company Name
- -Shipping Address
- -Shipping Address (Line 1)
- -Shipping Address (Line 2)
- -Shipping City
- -Shipping State/Province
- -Shipping State/Province Name
- -Shipping Postcode / Zipcode
- -Shipping Country (2-letter code)
- -Shipping Country Name
- -Currency Code
- -Currency Symbol
- -Item Count
- -Order Line Items
- -Do Prices Include Tax?
- -Order Total
- -Order Subtotal
- -Tax Total
- -Discount Cart Amount
- -Coupons Codes
- -Shipping Total Amount
- -Shipping Tax Amount
- -Customer Note
- -Order Notes List
Best Support, Easy to Use, Free Lifetime Updates
Features:
-Option to select order status for which the data will be added to sheet.
-Option to select the Spreadsheet to which new row of data will be appended.
-Option to select the Sheet within Spreadsheet.
-Option to map form fields with Sheet headers.
-Use on any number of forms.
-Different forms can send data to different sheets.
Woo Sheet Headers Mapping Screenshot:
FAQ:
Can I add data to different sheets?
Yes you can add data to any sheet available in your google account.
Can I send data to sheet based on order status?
Yes you can send data to sheet based on order status. Order Status supported right now are Pending, Failed, On-hold, Processing, Completed, Refunded, Cancelled.
Can I map sheet columns with order fields?
Yes you can map sheet columns with order fields from the feed settings.