Google Sheets + SellerCloud
Create Sellercloud orders from new Google Sheets rows
Automatically create sales orders in Sellercloud from your own Google Sheets account. Each time a row is added in Google Sheets, an order in Sellercloud will be created with all of the given information. If you're manually creating orders in Sellercloud from a spreadsheet, this is a Zap for you.
Automatically create sales orders in Sellercloud from your own Google Sheets account. Each time a row is added in Google Sheets, an order in Sellercloud will be created with all of the given information. If you're manually creating orders in Sellercloud from a spreadsheet, this is a Zap for you.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this...Lookup Spreadsheet Row
Find a specific spreadsheet row based on a column and value. If found, it returns the entire row.
ActionSearchFind existing data in your app - then do this!
Create OrderCreates a sales order.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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 Inventory
Triggers when an inventory is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planStatus
Shipping Status
Received Status
Payment Status
Company
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCompany
Product
Rma Status
Order Sources
Item Received Status
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPurchase Order Status
Shipping Status
Received Status
Payment Status
Company
Approved
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planFirst NameRequired
Last NameRequired
EmailRequired
CompanyRequired
Customer TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Product NameRequired
Product SKURequired
Product TypeRequired
Purchaser ID
Site Cost
Default Price
Manufacturer ID
Auto Assign UPC?
Product UPC
Product Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InventoryRequired
Condition
Master SKU
Product Dimensions (Width)
Product Dimensions (Height)
Product Dimensions (Length)
Product Weights (Pounds)
Product Weights (Ounces)
Shipping Dimensions (Width)
Shipping Dimensions (Height)
Shipping Dimensions (Length)
Shipping Weights (Pounds)
Shipping Weights (Ounces)
Shipping Package Type ID
Location Notes
Quantity Per Case
Quantity Per Pallet
Replenishable
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WarehouseRequired
InventoryRequired
Adjustment TypeRequired
Adjustment QuantityRequired
Adjustment ReasonRequired
Inventory Cost
Site Cost
Pin Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer Id
Email
First Name
Last Name
ActionThis is an event a Zap performs.SearchFind existing data in your appInventoryRequired
Warehouse
ActionThis is an event a Zap performs.SearchFind existing data in your appPurchase Order KeywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appQueued Job IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder ID
SKU
Company
Order Source Order IDs
Customer
First Name
Last Name
Email
Business
Wholesale
ChannelRequired
Product
Quantity
Unit Price
Tax Exempt
Gift Order
Business Name
First Name
Middle Name
Last Name
Address
Address 2
City
State
Zip Code
Country
Phone
Fax
Use shipping address for billing address?
Carrier Name
Shipping Method
Pounds
Ounces
Handling Fee
Shipping Fee
Insurance Fee
Lock Shipping Method
Rush Order
Require Pin to Ship
Add a payment method?
Category
Note
Order Item Discount Allowed
Discount Total
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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 Status
Payment Status
Shipping Status
Warehouse
Company
Product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planOrder Status
Payment Status
Shipping Status
Warehouse
Company
Product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCompany
Product
Rma Status
Order Sources
Item Received Status
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCustomer
First Name
Last Name
Email
Company
Business
Wholesale
ChannelRequired
Product
Quantity
Unit Price
Tax Exempt
Gift Order
Business Name
First Name
Middle Name
Last Name
Address
Address 2
City
State
Zip Code
Country
Phone
Fax
Use shipping address for billing address?
Carrier Name
Shipping Method
Pounds
Ounces
Handling Fee
Shipping Fee
Insurance Fee
Lock Shipping Method
Rush Order
Require Pin to Ship
Add a payment method?
Category
Note
Order Item Discount Allowed
Discount Total
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Scheduled Task IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Shipping ServiceRequired
Shipping DateRequired
Shipping CarrierRequired
Shipping Status
Warehouse
Tracking Number
Shipping Cost
Currency Code
Package ID
Width
Height
Length
Weight
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Inventory IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder ID
SKU
Company ID
Order Source Order IDs
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct KeywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Id
Email
First Name
Last Name
First NameRequired
Last NameRequired
EmailRequired
CompanyRequired
Customer TypeRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProduct KeywordRequired
CompanyRequired
Product NameRequired
Product SKURequired
Product TypeRequired
Purchaser ID
Site Cost
Default Price
Manufacturer ID
Auto Assign UPC?
Product UPC
Product Notes
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
Related categories
About SellerCloud
Related categories
Related Zap Templates
- Add new SellerCloud orders to Google Sheets as rows
- Create Google Sheet rows for new inventory in SellerCloud
- Update SellerCloud order shipping statuses from a new Google Sheet row
- Create multiple rows in Google Sheets when new inventories are added in SellerCloud
- Update Google Sheets rows when new orders are triggered in SellerCloud