Eshopbox + Google Sheets
Create Eshopbox orders from new spreadsheet rows in Google Sheets
Need to keep your order workflows running across platforms, record entries in Google Sheets, and orders are created in Eshopbox.
Need to keep your order workflows running across platforms, record entries in Google Sheets, and orders are created in Eshopbox.
- When this happens...
New Spreadsheet Row (Team Drive)Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create OrderCreates a new fulfillment 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
Get All Brands
Get the list of brands
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planFulfillment centre
StatusRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product
Triggers when new product is configured in your Eshopbox workspace .
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sales Channel
Fulfillment Center
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.PortalRequired
Select Seller Account
Fund Transfer AmountRequired
Bank Reference IdRequired
Fund Transfer DateRequired
Upload the payout reportRequired
Additional Remarks
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Mobile NoRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job TypeRequired
File PathRequired
Channel
Handle URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product TypeRequired
Product(sku)Required
QuantityRequired
Name Of The Product (SKU)Required
Product Group Code
DescriptionRequired
Image
My Product Is
M.R.P(INR)
Unit Price(INR)
HSN Code
Tax Code
Dimensional Length
Dimensional Width
Dimensional Height
Dimensional Unit
Weight
Weight Unit
Label
Internal Name
Value
EAN
UPC
GTIN
OTHERS
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product TypeRequired
Name of the Product (SKU)Required
Product Group Code
DescriptionRequired
Image
Brand
Vertical
M.R.P(INR)
Unit Price(INR)
HSN Code
Tax Code
Dimensional Length
Dimensional Width
Dimensional Height
Dimensional Unit
Weight
Weight Unit
My Product Is
EAN
UPC
OTHERS
GTIN
Label
Internal Name
Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales Channel
Customer Return NumberRequired
Customer Order Number
Pickup TypeRequired
Refund AmountRequired
Return Request DateRequired
Refund ModeRequired
Name
Account Number
IFSC Code
Item Sequence NumberRequired
Item IdRequired
QuantityRequired
Return ReasonRequired
ImageRequired
Pickup AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Consignment NumberRequired
Number of boxes
Document Type
Document Number
Document Url
Scheduled Arival To
Scheduled Arival From
Scheduled Arrival Date
Departure Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name of the Product (SKU)Required
Product TypeRequired
Description
Image
My Product Is
Brand
Vertical
M.R.P(INR)
Unit Price(INR)
HSN Code
Tax Code
Dimensional Length
Dimensional Width
Dimensional Height
Dimensional Unit
Weight
Weight Unit
Label
Custom Field
Value
EAN
UPC
GTIN
OTHERS
Product Group Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BrandRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appConsignment Number
Status
Document Number
Consignment Details
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Order NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appChannel Order Id
Status
Sales Channel
ActionThis is an event a Zap performs.SearchFind existing data in your appName of the Product(sku)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appChannel Order Id
Status
Sales Channel
ActionThis is an event a Zap performs.SearchFind existing data in your appSales Channel
Portal
ActionThis is an event a Zap performs.SearchFind existing data in your appStart DateRequired
End DateRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
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 foundGet Party List
Returns the party list.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Fulfillment Center
Triggers when new Fulfillment Center is created in your Eshopbox workspace.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Payout
Triggers when a new payout is added in your Eshopbox Workspace.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Product
Triggers whenever there is an update in product configuration like MRP, HSN, Dimensions, Weight, Name, Image etc.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Fulfillment Center
StatusRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sales Channel
Fulfillment Center
staus
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sales Channel CodeRequired
Customer Order NumberRequired
ReasonRequired
Cancellation TimeRequired
Item IdRequired
QuantityRequired
Product Name
Remark
line item sequence numberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand NameRequired
Vertical IDRequired
Vertical NameRequired
Brand Logo
Website URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Consignment TypeRequired
Send Inventory FromRequired
Send Inventory toRequired
Upload SheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales Channel CodeRequired
Customer Order NumberRequired
Order DateRequired
Expected ShipDate
Promise Delivery Date
Is CODRequired
Is Gift
Tax AmountRequired
Ship Charge Amount
Sub totalRequired
Order TotalRequired
Balance Due
Line Item Sequence NumberRequired
Item IdRequired
QuantityRequired
Customer PriceRequired
DiscountRequired
Tax RateRequired
Tax AmountRequired
Line Item TotalRequired
shippingAddressRequired
billingAddressRequired
Third party shippingRequired
Suggested Courier Label
Suggested Courier Code
Suggested Tracking Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recall Inventory FromRequired
Recall Inventory ToRequired
Upload SheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product TypeRequired
Product(sku)Required
QuantityRequired
Name Of The Product (SKU)Required
Product Group Code
DescriptionRequired
M.R.P(INR)
HSN Code
Tax Code
Label
Internal Name
Value
EAN
UPC
GTIN
OTHERS
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product TypeRequired
Name Of The Product (SKU)
Product Group Code
Description
Image
My Product Is
M.R.P(INR)
Unit Price(INR)
HSN code
Tax Code
Dimensional Length
Dimensional Width
Dimensional Height
Dimensional Unit
Weight
Weight Unit
Label
Internal Name
Value
Product(sku)Required
QuantityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product TypeRequired
Name Of The Product (SKU)Required
Product Group Code
Description
M.R.P(INR)
HSN Code
Tax Code
Label
Internal Name
Value
EAN
UPC
GTIN
OTHERS
Product(sku)Required
QuantityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fulfillment Center
ActionThis is an event a Zap performs.SearchFind existing data in your appFulfillment CenterRequired
QuantityRequired
Date
ActionThis is an event a Zap performs.SearchFind existing data in your appPartyRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appBank Reference Id
Portal
ActionThis is an event a Zap performs.SearchFind existing data in your appConsignment Number
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Return NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Order NumberRequired
Access TokenRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Eshopbox
Related categories
