Skip to content

DeftShip + Google Sheets

DeftShip + Google Sheets

DeftShip + Google Sheets integrations

Create DeftShip parcel orders from new Google Sheets rows

Effortlessly manage your shipping orders with this seamless workflow between Google Sheets and DeftShip. When a new row is added to your Google Sheets spreadsheet, a parcel order is created in the DeftShip app. This automation saves time, reduces manual data entry, and ensures accurate order information for efficient shipping management.

When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create Parcel OrderCreate Parcel Order
ActionWrite

Start free with email

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google Sheets and DeftShip

Discover other triggers and actions you can use with Google Sheets and DeftShip

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
New Freight Order Created
Triggers when a new freight order is created.
Trigger
Instant
Try It
New Parcel Order Created
Triggers when a new parcel order is created.
Trigger
Instant
Try It
- Shipment Date
  Required
- Shipment Type
  Required
- Carrier
  Required
- Service Code
  Required
- Origin Address - Name
  Required
- Origin Address - Attention
  Required
- Origin Address - Email
- Origin Address - Telephone
  Required
- Origin Address - Street 1
  Required
- Origin Address - Street 2
- Origin Address - Street 3
- Origin Address - City
  Required
- Origin Address - State
  Required
- Origin Address - Country
  Required
- Origin Address - ZIP
  Required
- Destination Address - Name
  Required
- Destination Address - Attention
  Required
- Destination Address - Telephone
  Required
- Destination Address - Email
- Destination Address - Street 1
  Required
- Destination Address - Street 2
- Destination Address - Street 3
- Destination Address - City
  Required
- Destination Address - State
  Required
- Destination Address - ZIP
  Required
- Destination Address - Country
  Required
- Tracking Number
  Required
- Item Quantity
  Required
- Item Price
  Required
- Item Description
  Required
Action
Write
- Origin Address - Name
  Required
- Origin Address - Attention
- Origin Address - Email
- Origin Address - Telephone
  Required
- Origin Address - Street 1
  Required
- Origin Address - Street 2
- Origin Address - Street 3
- Origin Address - City
  Required
- Origin Address - State
  Required
- Origin Address - Country
  Required
- Origin Address - ZIP
  Required
- Destination Address - Name
  Required
- Destination Address - Attention
- Destination Address - Email
- Destination Address - Telephone
  Required
- Destination Address - Street 1
  Required
- Destination Address - Street 2
- Destination Address - Street 3
- Destination Address - City
  Required
- Destination Address - State
  Required
- Destination Address - ZIP
  Required
- Destination Address - Country
  Required
- Count
  Required
- Weight (LBS)
  Required
- Length (IN)
  Required
- Width (IN)
  Required
- Height (IN)
  Required
- Signature
  Required
- Insurance
  Required
- HazMat
  Required
- Reference
- Item Description
- Item Price/Unit ($)
- Item Quantity
- Item SKU
- Content Type
- Country Of Manufacture
Action
Write

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
New Freight Shipment Created
Triggers when a new freight shipment is created.
Trigger
Instant
Try It
New Parcel Shipment Created
Triggers when a new parcel shipment is created.
Trigger
Instant
Try It
- Pickup Date
  Required
- Origin Address - Name
  Required
- Origin Address - Attention
- Origin Address - Email
- Origin Address - Telephone
  Required
- Origin Address - Street 1
  Required
- Origin Address - Street 2
- Origin Address - Street 3
- Origin Address - City
  Required
- Origin Address - State
  Required
- Origin Address - ZIP
  Required
- Origin Address - Country
  Required
- Origin Address - Opening Time
  Required
- Origin Address - Closing Time
  Required
- Origin Address - Lift Gate Pickup
  Required
- Origin Address - Pickup Appointment
  Required
- Origin Address - Residential Pickup
  Required
- Origin Address - Inside Pickup
  Required
- Origin Address - Limited Access Pickup
  Required
- Origin Address - Instructions
- Destination Address - Name
  Required
- Destination Address - Attention
- Destination Address - Email
- Destination Address - Telephone
  Required
- Destination Address - Street 1
  Required
- Destination Address - Street 2
- Destination Address - Street 3
- Destination Address - City
  Required
- Destination Address - State
  Required
- Origin Address - ZIP
  Required
- Destination Address - Country
  Required
- Destination Address - Opening Time
  Required
- Destination Address - Closing Time
  Required
- Destination Address - Lift Gate Pickup
  Required
- Destination Address - Delivery Appointment
  Required
- Destination Address - Residential Delivery
  Required
- Destination Address - Inside Delivery
  Required
- Destination Address - Limited Access Delivery
  Required
- Destination Address - Amazon Facility
  Required
- Destination Address - Instructions
- Package Type
  Required
- Total Weight (LBS)
  Required
- Count
  Required
- Length (IN)
  Required
- Width (IN)
  Required
- Height (IN)
  Required
- Hazmat
  Required
- Has Used Items
  Required
- Stackable
  Required
- Insurance
  Required
- Description
  Required
- PO Number
  Required
- Commodity Value ($)
Action
Write

About DeftShip

DeftShip is a custom-built, cloud-based logistics solution designed to save customers time, effort, and money while building your businesses.

Related categories

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

Related Zap Templates

Create Google Sheets rows for new DeftShip parcel orders

Related Zap Templates

Create Google Sheets rows for new DeftShip parcel orders