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)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
TriggerScheduledZapier 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 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
Get Party List
Returns the party list.
Try ItTriggerThis is the start of your ZapScheduledZapier 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
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 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 foundGet All Brands
Get the list of brands
Try ItTriggerThis is the start of your ZapScheduledZapier 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
About Eshopbox
Eshopbox offers simple, fast, and tech-enabled fulfillment for ambitious e-commerce businesses with its network of fulfillment centers across India.
Related categories
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
