DocketManager + Google Sheets
Log new DocketManager orders in Google Sheets by creating spreadsheet rows
Streamline your order processing with this automation that links DocketManager and Google Sheets. Whenever an order is posted in DocketManager, this workflow will instantly add a new row in your chosen Google Sheets spreadsheet. Save time manually entering data and ensure every order is accurately recorded for easy tracking and management.
Streamline your order processing with this automation that links DocketManager and Google Sheets. Whenever an order is posted in DocketManager, this workflow will instantly add a new row in your chosen Google Sheets spreadsheet. Save time manually entering data and ensure every order is accurately recorded for easy tracking and management.
- When this happens...
Order PostedTriggers when an Order is Posted.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Contact Created
Triggers when a new Contact is Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Created
Triggers when a new Customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Placed Online
Triggers when an Online Order is placed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Created
Triggers when a Payment is Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Queue Changed
Triggers when and Order Item moves into a new Queue.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Quote Email
Triggers when a Quote Email is sent
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Supplier Created
Triggers when a new Supplier is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sync Item
Triggers when the "Sync Item" button is clicked on the Item View page.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Completed
Triggers when a Task is marked as completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Vendor Updated
Triggers when a Vendor is modified.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact IdRequired
Text
TypeRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
External ID
Phone
Cell
Email
Billing Address Name
Billing Address
Billing City
Billing Region
Billing Country
Billing Zip/Postal
Shipping Address Name
Shipping Address
Shipping City
Shipping Region
Shipping Country
Shipping Zip/Postal
Tags
Default Order Statuses
Default Item Statuses
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TextRequired
Due Date
Assigned ToRequired
Created ByRequired
Customer IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TextRequired
Due Date
Assigned ToRequired
Created ByRequired
Order Item IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TextRequired
Due Date
Assigned ToRequired
Created ByRequired
Order IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Quote Item IdRequired
Text
TypeRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Quote IdRequired
Text
TypeRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
Tracking Number
Contact Name
Destination Address Name
Destination Address
Destination City
Destination Region
Destination Country
Destination Zip/Postal
Cost
Price
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Queue NameRequired
Order Item IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Update
UpdatesRequired
Billing
Billing Address
Shipping
Shipping Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
Customer IdRequired
NameRequired
Title
Phone
Cell
Email
Tags
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
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
Contact Updated
Triggers when a Contact is modified.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Updated
Triggers when a Customer is modified.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Posted
Triggers when an Order is Posted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Proof Status Updated
Triggers when a Proof Status is Created or Changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Quote Converted
Triggers when a Quote is converted to an Order.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Shipping Email
Triggers when a Shipping Email is sent.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Supplier Updated
Triggers when a Supplier is modified.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sync Order
Triggers when the "Sync Order" button is clicked on the Order View page.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Vendor Created
Triggers when a new Vendor is Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer IdRequired
NameRequired
Title
Phone
Cell
Email
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TextRequired
Due Date
Assigned ToRequired
Created ByRequired
Contact IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IdRequired
Text
TypeRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order Item IdRequired
Text
TypeRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
Text
TypeRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Created By Employee IDRequired
Deposit TypeRequired
Payment TypeRequired
Reference Number
Payment DateRequired
Payment AmountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TextRequired
Due Date
Assigned ToRequired
Created ByRequired
Quote Item IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TextRequired
Due Date
Assigned ToRequired
Created ByRequired
Quote IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TextRequired
Due Date
Assigned ToRequired
Created ByRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Updates Help
UpdatesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
NameRequired
External ID
Phone
Cell
Email
Billing Address Name
Billing Address
Billing City
Billing Region
Billing Country
Billing Zip/Postal
Shipping Address Name
Shipping Address
Shipping City
Shipping Region
Shipping Country
Shipping Zip/Postal
Tags
Default Order Statuses
Default Item Statuses
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo 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 found
About DocketManager
Related categories
