Google Sheets + Maropost Commerce Cloud
Create spreadsheet rows in Google Sheets for new completed orders in Maropost Commerce Cloud
Streamline your e-commerce processes with this efficient workflow. When a new order is completed in the Maropost Commerce Cloud, it instantly creates a row within your chosen Google Sheets document. This not only allows for easy tracking and organization, but also gives you a quick view of all completed transactions, saving you the manual work. Enhance your productivity with real-time updates and ensure your sales data is always up-to-date.
Streamline your e-commerce processes with this efficient workflow. When a new order is completed in the Maropost Commerce Cloud, it instantly creates a row within your chosen Google Sheets document. This not only allows for easy tracking and organization, but also gives you a quick view of all completed transactions, saving you the manual work. Enhance your productivity with real-time updates and ensure your sales data is always up-to-date.
- When this happens...
New Completed OrderTriggers on new completed orders (dispatched or cancelled).
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Cart
Triggers when new abandoned carts are made.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Content
Triggers when new content pages are made.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Item
Triggers when new items are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Paid Order
Triggers on new paid orders.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew RMA
Triggers on new RMAs.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Updated Order
Triggers on new updated orders.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planContent NameRequired
Content TypeRequired
Content Reference
Short Description 1
Short Description 2
Short Description 3
Description 1
Description 2
Description 3
Header Template
Body Template
Footer Template
Search Results Template
Search Keywords
Author
Label 1
Label 2
Label 3
SEO Meta Description
SEO Meta Keywords
SEO Page Heading
SEO Page Title
SEO Canonical URL
Content URL
Automatic URL
Parent Content ID
Sort Order
Active
On Site Map
On Menu
Allow Reviews
Require Login
Date Posted
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SKURequired
Inventory ID
Parent SKU
Accounting Code
Virtual
Brand
Name
Model
Sort Order 1
Sort Order 2
RRP
Default Price
Promotion Price
Promotion Start Date
Promotion Start Date Local
Promotion Start Date UTC
Promotion Expiry Date
Promotion Expiry Date Local
Promotion Expiry Date UTC
Date Arrival
Date Arrival UTC
Cost Price
Unit Of Measure
Base Unit Of Measure
Base Unit Per Quantity
Buy Unit Quantity
Quantity Per Scan
Sell Unit Quantity
Pre Order Quantity
Pick Priority
Pick Zone
Approved
Is Active
Is Neto Utility
Is Gift Voucher
Visible
Tax Free Item
Tax Inclusive
Approved For POS
Approved For Mobile Store
Search Keywords
Short Description
Description
Terms And Conditions
Features
Specifications
Warranty
Artist Or Author
Format
Model Number
Subtitle
Availability Description
Image Name
Image Thumb URL
Image Thumb URL
Image Medium Thumb URL
Image URL
Brochure URL
Product URL
UPC
UPC1
UPC2
UPC3
Type
Sub Type
Numbers Of Labels To Print
Reference Number
Internal Notes
Barcode Height
Is Inventoried
Is Bought
Is Sold
Expense Account
Purchase Tax Code
Cost Of Sales Account
Income Account
Asset Account
Item Height
Item Length
Item Width
Shipping Height
Shipping Length
Shipping Width
Shipping Weight
Cubic Weight
Handling Time
Supplier Item Code
Split Fo rWarehouse Picking
eBay Description
Primary Supplier
Display Template
Editable Kit Bundle
Requires Packaging
SEO Page Title
SEO Meta Keywords
SEO Page Heading
SEO Meta Description
SEO Canonical URL
Is Asset
Serial Tracking
Group
Shipping Category
Job
Monthly Spend Requirement
Item URL
Automatic URL
Misc 01
Misc 02
Misc 03
Misc 04
Misc 05
Misc 06
Misc 07
Misc 08
Misc 09
Misc 10
Misc 11
Misc 12
Misc 13
Misc 14
Misc 15
Misc 16
Misc 17
Misc 18
Misc 19
Misc 20
Misc 21
Misc 22
Misc 23
Misc 24
Misc 25
Misc 26
Misc 27
Misc 28
Misc 29
Misc 30
Misc 31
Misc 32
Misc 33
Misc 34
Misc 35
Misc 36
Misc 37
Misc 38
Misc 39
Misc 40
Misc 41
Misc 42
Misc 43
Misc 44
Misc 45
Misc 46
Misc 47
Misc 48
Misc 49
Misc 50
Misc 51
Misc 52
FreeGifts
Crosssell Product SKU
Upsell Product SKU
Kit Component SKU
Kit Component Value
Kit Component Assemble Quantity
Kit Component Minimum Quantity
Kit Component Maximum Quantity
Kit Component Sort Order
Price Group ID
Price Group Price
Price Group Promotion Price
Price Group Minimum Quantity
Price Group Maximum Quantity
Price Group Multiple
Price Group Multiple Start Quantity
Category ID
Category Priority
Category Name
Item Specific Name
Item Specific Value
Warehouse Quantity ID
Warehouse Quantity Quantity
Warehouse Location ID
Warehouse Location Warehouse ID
Warehouse Location Type
Warehouse Location Priority
Related Content ID
Related Content Type ID
Related Content Priority
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Purchase Order Number
Order Type
On Hold Type
User Group
Document Template
EmailRequired
Bill First Name
Bill Last Name
Bill Company
Bill Street 1
Bill Street 2
Bill City
Bill State
Bill Post Code
Bill Contact Phone
Bill Country
Ship First Name
Ship Last Name
Ship Company
Ship Street 1
Ship Street 2
Ship City
Ship State
Ship PostCode
Ship Contact Phone
Ship Country
Enable Address Validation
Operator
Operator Date Updated
Sales Person
Customer Ref 1
Customer Ref 2
Customer Ref 3
Customer Ref 4
Customer Ref 5
Customer Ref 6
Customer Ref 7
Customer Ref 8
Customer Ref 9
Customer Ref 10
Sales Channel
Ship Instructions
Internal Order Notes
Sticky Note Title
Sticky Note
Sticky Notes
Order Status
Order Approval
Order Line SKU
Order Line Item Serial Number
Order Line Warehouse ID
Order Line Quantity Shipped
Order Line External System Identifier
Order Line External Order Reference
Order Line External OrderLine Reference
Order Line Shipping Method
Order Line Tracking Number
Order Line Date Shipped
Order Line Order Rounding
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Invoice NumberRequired
Customer UsernameRequired
Staff UsernameRequired
Purchase Order NumberRequired
Internal NotesRequired
Date Issued
Shipping Refund AmountRequired
Shipping Refund Tax CodeRequired
Tax Inclusive
Rma Line Quantity
Rma Line SKU
Rma Line Item Description
Rma Line Refund Subtotal
Rma Line Tax Code
Rma Line Warehouse ID
Rma Line Resolution Outcome
Rma Line Return Reason
Rma Line Item Status Type
Rma Line Item Status
Rma Line Resolution Status
Rma Line Manufacturer Claims
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SKURequired
Inventory ID
Parent SKU
Accounting Code
Virtual
Brand
Name
Model
Sort Order 1
Sort Order 2
RRP
Default Price
Promotion Price
Promotion Start Date
Promotion Start Date Local
Promotion Start Date UTC
Promotion Expiry Date
Promotion Expiry Date Local
Promotion Expiry Date UTC
Date Arrival
Date Arrival UTC
Cost Price
Unit Of Measure
Base Unit Of Measure
Base Unit Per Quantity
Buy Unit Quantity
Quantity Per Scan
Sell Unit Quantity
Pre Order Quantity
Pick Priority
Pick Zone
Approved
Is Active
Is Neto Utility
Is Gift Voucher
Visible
Tax Free Item
Tax Inclusive
Approved For POS
Approved For Mobile Store
Search Keywords
Short Description
Description
Terms And Conditions
Features
Specifications
Warranty
Artist Or Author
Format
Model Number
Subtitle
Availability Description
Image Name
Image Thumb URL
Image Thumb URL
Image Medium Thumb URL
Image URL
Brochure URL
Product URL
UPC
UPC1
UPC2
UPC3
Type
Sub Type
Numbers Of Labels To Print
Reference Number
Internal Notes
Barcode Height
Is Inventoried
Is Bought
Is Sold
Expense Account
Purchase Tax Code
Cost Of Sales Account
Income Account
Asset Account
Item Height
Item Length
Item Width
Shipping Height
Shipping Length
Shipping Width
Shipping Weight
Cubic Weight
Handling Time
Supplier Item Code
Split Fo rWarehouse Picking
eBay Description
Primary Supplier
Display Template
Editable Kit Bundle
Requires Packaging
SEO Page Title
SEO Meta Keywords
SEO Page Heading
SEO Meta Description
SEO Canonical URL
Is Asset
Serial Tracking
Group
Shipping Category
Job
Monthly Spend Requirement
Item URL
Automatic URL
Misc 01
Misc 02
Misc 03
Misc 04
Misc 05
Misc 06
Misc 07
Misc 08
Misc 09
Misc 10
Misc 11
Misc 12
Misc 13
Misc 14
Misc 15
Misc 16
Misc 17
Misc 18
Misc 19
Misc 20
Misc 21
Misc 22
Misc 23
Misc 24
Misc 25
Misc 26
Misc 27
Misc 28
Misc 29
Misc 30
Misc 31
Misc 32
Misc 33
Misc 34
Misc 35
Misc 36
Misc 37
Misc 38
Misc 39
Misc 40
Misc 41
Misc 42
Misc 43
Misc 44
Misc 45
Misc 46
Misc 47
Misc 48
Misc 49
Misc 50
Misc 51
Misc 52
FreeGifts
Crosssell Product SKU
Upsell Product SKU
Kit Component SKU
Kit Component Value
Kit Component Assemble Quantity
Kit Component Minimum Quantity
Kit Component Maximum Quantity
Kit Component Sort Order
Price Group ID
Price Group Price
Price Group Promotion Price
Price Group Minimum Quantity
Price Group Maximum Quantity
Price Group Multiple
Price Group Multiple Start Quantity
Category ID
Category Priority
Category Name
Item Specific Name
Item Specific Value
Warehouse Quantity ID
Warehouse Quantity Quantity
Warehouse Location ID
Warehouse Location Warehouse ID
Warehouse Location Type
Warehouse Location Priority
Related Content ID
Related Content Type ID
Related Content Priority
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Username
Type
Active
Email
Company
On Credit Hold
Newsletter Subscriber
User Group
Bill State
Date Added From
Date Added To
Date Updated From
Date Updated To
ActionThis is an event a Zap performs.SearchFind existing data in your appSKU
Accounting Code
Inventory ID
Parent SKU
Brand
Model
Primary Supplier
Approved for Webstore
Approved for POS
Approved for Mobile Store
Is Active
Date Added From
Date Added To
Date Created From
Date Created To
Date Updated From
Date Updated To
Category ID
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder ID
Payment ID
Date Paid From
Date Paid To
ActionThis is an event a Zap performs.SearchFind existing data in your appContent ID
Parent Content ID
Content NameRequired
Active
Content TypeRequired
On Site Map
On Menu
Allow Reviews
Require Login
Date Posted From
Date Posted To
Date Updated From
Date Updated To
Content Reference
Short Description 1
Short Description 2
Short Description 3
Description 1
Description 2
Description 3
Header Template
Body Template
Footer Template
Search Results Template
Search Keywords
Author
Label 1
Label 2
Label 3
SEO Meta Description
SEO Meta Keywords
SEO Page Heading
SEO Page Title
SEO Canonical URL
Content URL
Automatic URL
Sort Order
Date Posted
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSKURequired
Accounting Code
Inventory ID
Parent SKU
Brand
Model
Primary Supplier
Approved
Approved For POS
Approved For Mobile Store
Is Active
Date Added From
Date Added To
Date Created From
Date Created To
Date Updated From
Date Updated To
Category ID
Virtual
Name
Sort Order 1
Sort Order 2
RRP
Default Price
Promotion Price
Promotion Start Date
Promotion Start Date Local
Promotion Start Date UTC
Promotion Expiry Date
Promotion Expiry Date Local
Promotion Expiry Date UTC
Date Arrival
Date Arrival UTC
Cost Price
Unit Of Measure
Base Unit Of Measure
Base Unit Per Quantity
Buy Unit Quantity
Quantity Per Scan
Sell Unit Quantity
Pre Order Quantity
Pick Priority
Pick Zone
Is Neto Utility
Is Gift Voucher
Visible
Tax Free Item
Tax Inclusive
Search Keywords
Short Description
Description
Terms And Conditions
Features
Specifications
Warranty
Artist Or Author
Format
Model Number
Subtitle
Availability Description
Image Name
Image Thumb URL
Image Thumb URL
Image Medium Thumb URL
Image URL
Brochure URL
Product URL
UPC
UPC1
UPC2
UPC3
Type
Sub Type
Numbers Of Labels To Print
Reference Number
Internal Notes
Barcode Height
Is Inventoried
Is Bought
Is Sold
Expense Account
Purchase Tax Code
Cost Of Sales Account
Income Account
Asset Account
Item Height
Item Length
Item Width
Shipping Height
Shipping Length
Shipping Width
Shipping Weight
Cubic Weight
Handling Time
Supplier Item Code
Split Fo rWarehouse Picking
eBay Description
Display Template
Editable Kit Bundle
Requires Packaging
SEO Page Title
SEO Meta Keywords
SEO Page Heading
SEO Meta Description
SEO Canonical URL
Is Asset
Serial Tracking
Group
Shipping Category
Job
Monthly Spend Requirement
Item URL
Automatic URL
Misc 01
Misc 02
Misc 03
Misc 04
Misc 05
Misc 06
Misc 07
Misc 08
Misc 09
Misc 10
Misc 11
Misc 12
Misc 13
Misc 14
Misc 15
Misc 16
Misc 17
Misc 18
Misc 19
Misc 20
Misc 21
Misc 22
Misc 23
Misc 24
Misc 25
Misc 26
Misc 27
Misc 28
Misc 29
Misc 30
Misc 31
Misc 32
Misc 33
Misc 34
Misc 35
Misc 36
Misc 37
Misc 38
Misc 39
Misc 40
Misc 41
Misc 42
Misc 43
Misc 44
Misc 45
Misc 46
Misc 47
Misc 48
Misc 49
Misc 50
Misc 51
Misc 52
FreeGifts
Crosssell Product SKU
Upsell Product SKU
Kit Component SKU
Kit Component Value
Kit Component Assemble Quantity
Kit Component Minimum Quantity
Kit Component Maximum Quantity
Kit Component Sort Order
Price Group ID
Price Group Price
Price Group Promotion Price
Price Group Minimum Quantity
Price Group Maximum Quantity
Price Group Multiple
Price Group Multiple Start Quantity
Category ID
Category Priority
Category Name
Item Specific Name
Item Specific Value
Warehouse Quantity ID
Warehouse Quantity Quantity
Warehouse Location ID
Warehouse Location Warehouse ID
Warehouse Location Type
Warehouse Location Priority
Related Content ID
Related Content Type ID
Related Content Priority
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundOrder IDRequired
Payment ID
Date Paid From
Date Paid To
Payment MethodRequired
Card AuthorisationRequired
Amount PaidRequired
Date PaidRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Completed Order
Triggers on new completed orders (dispatched or cancelled).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Order
Triggers on new orders.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Payment
Triggers on new payments.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Customer
Triggers when a customer is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Item
Triggers when an item is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUsername
Type
Email AddressRequired
Secondary Email Address
Newsletter Subscriber
Parent Username
Approval Username
Referral Username
Referral Commission
Gender
Date Of Birth
Identification Type
Identification Details
Default Discounts
Default Document Template
Registration Date
Internal Notes
ABN
Website URL
Credit Limit
Default Invoice Terms
Classification 1
Classification 2
Sales Channel
Ship Company
Ship Fax
Ship Street Line 1
Ship Street Line 2
Ship City
Ship State
Ship Country
Ship PostCode
Ship First Name
Ship Last Name
Ship Phone
Bill Company
Bill Fax
Bill Street Line 1
Bill Street Line 2
Bill City
Bill State
Bill Country
Bill PostCode
Bill First Name
Bill Last Name
Bill Phone
Active
On Credit Hold
User Group
Account Balance
Available Credit
Account Manager
Default Order Type
User Custom 1
User Custom 2
User Custom 3
User Custom 4
User Custom 5
User Custom 6
User Custom 7
User Custom 8
User Custom 9
User Custom 10
User Custom 11
User Custom 12
User Custom 13
User Custom 14
User Custom 15
User Custom 16
User Custom 17
User Custom 18
User Custom 19
User Custom 20
User Custom 21
User Custom 22
User Custom 23
User Custom 24
User Custom 25
User Custom 26
User Custom 27
User Custom 28
User Custom 29
User Custom 30
User Custom 31
User Custom 32
User Custom 33
User Custom 34
User Custom 35
User Custom 36
User Custom 37
User Custom 38
User Custom 39
User Custom 40
User Custom 41
User Custom 42
User Custom 43
User Custom 44
User Custom 45
User Custom 46
User Custom 47
User Custom 48
User Custom 49
User Custom 50
Date Added
Date Added Local
Date Added UTC
Date Updated
Date Updated Local
Date Updated UTC
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Purchase Order Number
Order Type
On Hold Type
User Group
Document Template
Date Placed UTC
Date Placed
Date Required
Date Required UTC
Date Invoiced
Date Invoiced UTC
Date Due
Date Due UTC
UsernameRequired
EmailRequired
Bill First Name
Bill Last Name
Bill Company
Bill Street 1
Bill Street 2
Bill City
Bill State
Bill Post Code
Bill Contact Phone
Bill Country
Ship First Name
Ship Last Name
Ship Company
Ship Street 1
Ship Street 2
Ship City
Ship State
Ship PostCode
Ship Contact Phone
Ship Country
Enable Address Validation
Operator
Operator Date Updated
Sales Person
Customer Ref 1
Customer Ref 2
Customer Ref 3
Customer Ref 4
Customer Ref 5
Customer Ref 6
Customer Ref 7
Customer Ref 8
Customer Ref 9
Customer Ref 10
Sales Channel
Ship Instructions
Internal Order Notes
Sticky Note Title
Sticky Note
Sticky Notes
Order Status
Order Approval
Payment Method
Payment Terms
Tax Inclusive
Tax Free Shipping
BPAY CRN
Shipping Method
Shipping Cost
Signature Required
Currency Code
Order Line SKU
Order Line Item Notes
Order Line Item Description
Order Line Item Serial Number
Order Line Dropshipper
Order Line Tax Free
Order Line Warehouse ID
Order Line Quantity
Order Line Unit Price
Order Line Unit Cost
Order Line Shipping Weight
Order Line Quantity Shipped
Order Line Discount Percent
Order Line Discount Amount
Order Line Cubic
Order Line External System Identifier
Order Line External Order Reference
Order Line External OrderLine Reference
Order Line Kit Components
Order Line Order Rounding
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Payment MethodRequired
Card AuthorisationRequired
Amount PaidRequired
Date PaidRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UsernameRequired
Type
Email AddressRequired
Secondary Email Address
Newsletter Subscriber
Parent Username
Approval Username
Referral Username
Referral Commission
Gender
Date Of Birth
Identification Type
Identification Details
Default Discounts
Default Document Template
Registration Date
Internal Notes
ABN
Website URL
Credit Limit
Default Invoice Terms
Classification 1
Classification 2
Sales Channel
Ship Company
Ship Fax
Ship Street Line 1
Ship Street Line 2
Ship City
Ship State
Ship Country
Ship PostCode
Ship First Name
Ship Last Name
Ship Phone
Bill Company
Bill Fax
Bill Street Line 1
Bill Street Line 2
Bill City
Bill State
Bill Country
Bill PostCode
Bill First Name
Bill Last Name
Bill Phone
Active
On Credit Hold
User Group
Account Balance
Available Credit
Account Manager
Default Order Type
User Custom 1
User Custom 2
User Custom 3
User Custom 4
User Custom 5
User Custom 6
User Custom 7
User Custom 8
User Custom 9
User Custom 10
User Custom 11
User Custom 12
User Custom 13
User Custom 14
User Custom 15
User Custom 16
User Custom 17
User Custom 18
User Custom 19
User Custom 20
User Custom 21
User Custom 22
User Custom 23
User Custom 24
User Custom 25
User Custom 26
User Custom 27
User Custom 28
User Custom 29
User Custom 30
User Custom 31
User Custom 32
User Custom 33
User Custom 34
User Custom 35
User Custom 36
User Custom 37
User Custom 38
User Custom 39
User Custom 40
User Custom 41
User Custom 42
User Custom 43
User Custom 44
User Custom 45
User Custom 46
User Custom 47
User Custom 48
User Custom 49
User Custom 50
Date Added
Date Added Local
Date Added UTC
Date Updated
Date Updated Local
Date Updated UTC
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Content ID
Parent Content ID
Content Name
Active
Content Type
On Site Map
On Menu
Allow Reviews
Require Login
Date Posted From
Date Posted To
Date Updated From
Date Updated To
ActionThis is an event a Zap performs.SearchFind existing data in your appSKU
Accounting Code
Inventory ID
Parent SKU
Brand
Model
Primary Supplier
Approved for Webstore
Approved for POS
Approved for Mobile Store
Is Active
Date Added From
Date Added To
Date Created From
Date Created To
Date Updated From
Date Updated To
Category ID
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder ID
Username
SKU
Supplier
Order Status
Order Type
On Hold Type
Approval Status
Payment Status
Export Status
Warehouse ID
Exported To WMS (Warehouse Management System)
Shipping Method
Sales Channel
Date Paid From
Date Paid To
Date Required To
Date Required From
Date Invoiced From
Date Invoiced To
Date Placed From
Date Placed To
Date Updated From
Date Updated To
Date Completed From
Date Completed To
Split Kit Components
External System Identifier
External Order Reference
External Order Line Reference
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder ID
Username
RMA ID
Invoice Number
RMA Status
Date Issued From
Date Issued To
Date Updated From
Date Updated To
Date Approved From
Date Approved To
Split Kit Components
ActionThis is an event a Zap performs.SearchFind existing data in your appUsername
Type
Active
Email
Company
On Credit Hold
Newsletter Subscriber
User Group
Bill State
Date Added From
Date Added To
Date Updated From
Date Updated To
Email AddressRequired
Secondary Email Address
Parent Username
Approval Username
Referral Username
Referral Commission
Gender
Date Of Birth
Identification Type
Identification Details
Default Discounts
Default Document Template
Registration Date
Internal Notes
ABN
Website URL
Credit Limit
Default Invoice Terms
Classification 1
Classification 2
Sales Channel
Ship Company
Ship Fax
Ship Street Line 1
Ship Street Line 2
Ship City
Ship State
Ship Country
Ship PostCode
Ship First Name
Ship Last Name
Ship Phone
Bill Company
Bill Fax
Bill Street Line 1
Bill Street Line 2
Bill City
Bill Country
Bill PostCode
Bill First Name
Bill Last Name
Bill Phone
Account Balance
Available Credit
Account Manager
Default Order Type
User Custom 1
User Custom 2
User Custom 3
User Custom 4
User Custom 5
User Custom 6
User Custom 7
User Custom 8
User Custom 9
User Custom 10
User Custom 11
User Custom 12
User Custom 13
User Custom 14
User Custom 15
User Custom 16
User Custom 17
User Custom 18
User Custom 19
User Custom 20
User Custom 21
User Custom 22
User Custom 23
User Custom 24
User Custom 25
User Custom 26
User Custom 27
User Custom 28
User Custom 29
User Custom 30
User Custom 31
User Custom 32
User Custom 33
User Custom 34
User Custom 35
User Custom 36
User Custom 37
User Custom 38
User Custom 39
User Custom 40
User Custom 41
User Custom 42
User Custom 43
User Custom 44
User Custom 45
User Custom 46
User Custom 47
User Custom 48
User Custom 49
User Custom 50
Date Added
Date Added Local
Date Added UTC
Date Updated
Date Updated Local
Date Updated UTC
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundOrder IDRequired
UsernameRequired
Order Line SKU
Supplier
Order Status
Order Type
On Hold Type
Approval Status
Payment Status
Export Status
Order Line Warehouse ID
Exported To WMS (Warehouse Management System)
Shipping Method
Sales Channel
Date Paid From
Date Paid To
Date Required To
Date Required From
Date Invoiced From
Date Invoiced To
Date Placed From
Date Placed To
Date Updated From
Date Updated To
Date Completed From
Date Completed To
Split Kit Components
Order Line External System Identifier
Order Line External Order Reference
Order Line External OrderLine Reference
Purchase Order Number
User Group
Document Template
Date Placed UTC
Date Placed
Date Required
Date Required UTC
Date Invoiced
Date Invoiced UTC
Date Due
Date Due UTC
EmailRequired
Bill First Name
Bill Last Name
Bill Company
Bill Street 1
Bill Street 2
Bill City
Bill State
Bill Post Code
Bill Contact Phone
Bill Country
Ship First Name
Ship Last Name
Ship Company
Ship Street 1
Ship Street 2
Ship City
Ship State
Ship PostCode
Ship Contact Phone
Ship Country
Enable Address Validation
Operator
Operator Date Updated
Sales Person
Customer Ref 1
Customer Ref 2
Customer Ref 3
Customer Ref 4
Customer Ref 5
Customer Ref 6
Customer Ref 7
Customer Ref 8
Customer Ref 9
Customer Ref 10
Ship Instructions
Internal Order Notes
Sticky Note Title
Sticky Note
Sticky Notes
Order Approval
Payment Method
Payment Terms
Tax Inclusive
Tax Free Shipping
BPAY CRN
Shipping Cost
Signature Required
Currency Code
Order Line Item Notes
Order Line Item Description
Order Line Item Serial Number
Order Line Dropshipper
Order Line Tax Free
Order Line Quantity
Order Line Unit Price
Order Line Unit Cost
Order Line Shipping Weight
Order Line Quantity Shipped
Order Line Discount Percent
Order Line Discount Amount
Order Line Cubic
Order Line Kit Components
Order Line Order Rounding
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundOrder IDRequired
Username
RMA ID
Invoice NumberRequired
RMA Status
Date Issued From
Date Issued To
Date Updated From
Date Updated To
Date Approved From
Date Approved To
Split Kit Components
Customer UsernameRequired
Staff UsernameRequired
Purchase Order NumberRequired
Internal NotesRequired
Date Issued
Shipping Refund AmountRequired
Shipping Refund Tax CodeRequired
Tax Inclusive
Rma Line Quantity
Rma Line SKU
Rma Line Item Description
Rma Line Refund Subtotal
Rma Line Tax Code
Rma Line Warehouse ID
Rma Line Resolution Outcome
Rma Line Return Reason
Rma Line Item Status Type
Rma Line Item Status
Rma Line Resolution Status
Rma Line Manufacturer Claims
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout Maropost Commerce Cloud
Build an online store, process sales at your bricks-and-mortar store, and showcase your products through eBay and social media, all from one platform.