Google Sheets + Code by Zapier + Maropost Commerce Cloud Integrations
How to connect Google Sheets + Code by Zapier + Maropost Commerce Cloud
Zapier lets you send info between Google Sheets and Code by Zapier and Maropost Commerce Cloud automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Code by Zapier + Maropost Commerce Cloud
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Sheets, Code by Zapier, and Maropost Commerce Cloud. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
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
Search from last row
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
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundInput Data
CodeRequired
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
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 found
No 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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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
Search from last row
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 existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundInput Data
CodeRequired
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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.
TriggerThis is the start of your Zap