Email by Zapier + Google Sheets + Maropost Commerce Cloud Integrations
How to connect Email by Zapier + Google Sheets + Maropost Commerce Cloud
Zapier lets you send info between Email by Zapier and Google Sheets and Maropost Commerce Cloud automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Email by Zapier + Google Sheets + 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 Email by Zapier, Google Sheets, and Maropost Commerce Cloud. And don’t forget that you can add more apps and actions to create complex workflows.
Email AddressRequired
Customize the private email address associated with your mailbox. Be sure to use lowercase and numbers only. Just forward emails to this address to trigger this Zap. Want to receive to your own email address? Try Mailgun, IMAP, Mandrill, or Gmail instead.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ToRequired
Can be a comma separated list of emails. Limited to 5.
SubjectRequired
Body (HTML or Plain)Required
You can place HTML in here and we will send it as is. If this is plain text, we will try to convert it to some very basic HTML for greater client compatibility.
Attachment
A file object to be attached to the email. Plain text content will converted into a txt file and attached. Please note, if the file is over ~10mb or so, you should explore using other email sending techniques (like Gmail or SMTP).
From Name
This will be your "display name" when sending. Want to send from your own email address? Try Mailgun, IMAP, Mandrill or Gmail apps instead.
Reply To
Specify a reply address other than your own.
Cc
Can be a comma separated list of emails. Limited to 5.
Bcc
Can be a comma separated list of emails. Limited to 5.
Force Linebreaks?
Set this to "yes" if your emails are received without line breaks or spacing.
Enable read receipts?
Want to be notified when this email is opened? Set this to to
Trueand set up a Zap using theNew Read Receipttrigger.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.No Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Background Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Bold
True if the text is bold.
Text Italic
True if the text is italicized.
Text Strikethrough
True if the text is strikethrough.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet?
Row Count
Number of rows to return. Max is 500.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
ColumnsRequired
Let us know which columns to return. e.g. A:Z
Row CountRequired
Number of rows to return. Max is 500.
First Row
Number of the first row to return (1 is the header)
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
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 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
metres
Item Length
metres
Item Width
metres
Shipping Height
metres
Shipping Length
metres
Shipping Width
metres
Shipping Weight
metres
Cubic Weight
cubic metres
Handling Time
days
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
metres
Item Length
metres
Item Width
metres
Shipping Height
metres
Shipping Length
metres
Shipping Width
metres
Shipping Weight
metres
Cubic Weight
cubic metres
Handling Time
days
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
metres
Item Length
metres
Item Width
metres
Shipping Height
metres
Shipping Length
metres
Shipping Width
metres
Shipping Weight
metres
Cubic Weight
cubic metres
Handling Time
days
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 found
Setup Directions
In order to trigger when emails are opened, this must be paired with a separate Zap using the Send Outbound Email action, with the Enable Read Receipts? field set to
True.To test with a live email, send an email to yourself using your Send Outbound Email action (with read receipts enabled) and open it, then test this trigger immediately for samples. If you don't need to test with live data, click Skip Test to use static test data.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
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
Create a duplicate of an existing spreadsheet.
Headers
These Headers are ignored if a "Spreadsheet to Copy" is selected.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
Use a search step before this to get the row to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew 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 app