Google Sheets + YoPrint

Update Google Sheets rows when sales orders/quotes status changes in YoPrint

Stay on top of your sales order or quote status changes in YoPrint by instantly updating a Google Sheets spreadsheet. This workflow swiftly inserts a new row in your specified spreadsheet whenever there is a change in the status of your sales order or quote in YoPrint. Streamline your sales tracking process and ensure important updates never slip through the cracks. This seamless integration simplifies your sales management and helps you maintain accurate and up-to-date records.

When this happens...
Sales Order/Quote Status Changed
This trigger is deprecated and should not be used
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

Contact Created
Triggers when a contact is created.
Trigger
Instant
Try It
Contact Updated
Triggers when a contact is updated.
Trigger
Instant
Try It
Customer Fund Deposited
Triggers when a fund deposited into Customer Wallet.
Trigger
Instant
Try It
Customer Deleted
Triggers when a customer is deleted.
Trigger
Instant
Try It
Customer Message Received
Triggers when customer message received.
Trigger
Instant
Try It

Artwork Approved
Triggers when a artwork is approved.
Trigger
Instant
Try It
Job Marked as Not Rush
Triggers when a Job is marked as not rush.
Trigger
Instant
Try It

Job Status Changed
Triggers when a job status changes.
Trigger
Instant
Try It
Order Approved
Triggers when an order is approved.
Trigger
Instant
Try It
Sales Order Created
Triggers when a sales order is created.
Trigger
Instant
Try It
Sales Order / Quote Marked as Rush
Triggers when a sales order is marked as rushed.
Trigger
Instant
Try It
Payment Received (Any Amount)
Triggers when an order received a payment of any amount.
Trigger
Instant
Try It
Payment Received (Full Amount)
Triggers when an order is fully paid.
Trigger
Instant
Try It
Purchase Order Message Bounced
Triggers when purchase order message bounced.
Trigger
Instant
Try It
Purchase Order Status Changed
Triggers when a purchase order status changes.
Trigger
Instant
Try It
Quote Created
Triggers when a quote is created.
Trigger
Instant
Try It
Sales Order Converted to Quote
Triggers when a sales order is converted to quote.
Trigger
Instant
Try It
Shipment Status Changed
Triggers when a shipment status changes.
Trigger
Instant
Try It
- Job ID
Action
Write
- Task ID
- Pipeline ID (Task Preset ID)
Action
Write
- Order ID
- Shipment ID
Action
Write
- Do you want to perform an upsert?
- Customer IdRequired
- First NameRequired
- Last Name
- Email
- Phone
- Fax
- Can Receive SMS
Action
Write
- Job IDRequired
Action
Write
- Order IDRequired
Action
Write
- Order ID
Action
Write
- Quote IDRequired
- Message to SendRequired
Action
Write
- Task ID
Action
Write
- Customer IdRequired
Action
Search
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

Contact Deleted
Triggers when a contact is deleted.
Trigger
Instant
Try It
Customer Created
Triggers when a customer is created.
Trigger
Instant
Try It
Customer Fund Withdrew
Triggers when a fund withdrew from Customer Wallet.
Trigger
Instant
Try It
Customer Message Bounced
Triggers when customer message bounced.
Trigger
Instant
Try It
Customer Updated
Triggers when a customer is updated.
Trigger
Instant
Try It
Artwork Change Requested
Triggers when a artwork change is requested.
Trigger
Instant
Try It
Job Marked as Rush
Triggers when a Job is marked as rush.
Trigger
Instant
Try It
Message Status Changed
Triggers when either a sales order or purchase order message status changes.
Trigger
Instant
Try It
Order Change Requested
Triggers when an order change is requested.
Trigger
Instant
Try It
Sales Order / Quote Marked as Not Rush
Triggers when a sales order is marked as Not rush.
Trigger
Instant
Try It
Sales Order/Quote Status Changed
This trigger is deprecated and should not be used
Trigger
Instant
Try It
Payment Received (Deposit Amount)
Triggers when an order received a payment of deposit amount.
Trigger
Instant
Try It
Refund Issued
Triggers when a refund is issued.
Trigger
Instant
Try It
Purchase Order Message Received
Triggers when purchase order message received.
Trigger
Instant
Try It
Quote Converted to Sales Order
Triggers when a quote is converted to order.
Trigger
Instant
Try It
Quote Status Changed
Triggers when a quote status changes
Trigger
Instant
Try It
Sales Order Status Changed
Triggers when a sales order status changes
Trigger
Instant
Try It
Task Status Changed
Triggers when a task status changes.
Trigger
Instant
Try It
- Message ID
Action
Write
- Purchase Order ID
Action
Write
- Order IDRequired
Action
Write
- Do you want to perform an upsert?
- NameRequired
- Website
- Resale Number
- Tax Identification Number
- Tax Exempt
- First Name
- Last Name
- Email
- Phone
- Fax
- Can Receive SMS
Action
Write
- Job IDRequired
Action
Write
- Order IDRequired
Action
Write
- Order ID
Action
Write
- Sales Order IDRequired
- Message to SendRequired
Action
Write
- Contact IdRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About Google Sheets

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

Learn more

Related categories

Similar apps

About YoPrint

YoPrint is an all-in-one print shop management software that helps you keep track of your sales, inventory and production.

Related categories

Printing

Related Zap Templates

Create multiple rows in Google Sheets when new sales orders are created in YoPrint

Create Google Sheets rows for new YoPrint quotes

Google Sheets + YoPrint

Update Google Sheets rows when sales orders/quotes status changes in YoPrint

Contact Created

Contact Updated

Customer Fund Deposited

Customer Deleted

Customer Message Received

Artwork Approved

Job Marked as Not Rush

Job Status Changed

Order Approved

Sales Order Created

Sales Order / Quote Marked as Rush

Payment Received (Any Amount)

Payment Received (Full Amount)

Purchase Order Message Bounced

Purchase Order Status Changed

Quote Created

Sales Order Converted to Quote

Shipment Status Changed

Change Job Status

Change Task Status

Change Shipment Status

Create Contact

Mark Job as Not Rush

Mark Sales Order or Quote as Not Rush

Change Quote Status

Send Quote Message

Reassign User to Task

Customer by Id

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create Row

Contact Deleted

Customer Created

Customer Fund Withdrew

Customer Message Bounced

Customer Updated

Artwork Change Requested

Job Marked as Rush

Message Status Changed

Order Change Requested

Sales Order / Quote Marked as Not Rush

Sales Order/Quote Status Changed

Payment Received (Deposit Amount)

Refund Issued

Purchase Order Message Received

Quote Converted to Sales Order

Quote Status Changed

Sales Order Status Changed

Task Status Changed

Change Message Status

Change Purchase Order Status

Convert Quote to Sales Order

Create Customer

Mark Job as Rush

Mark Sales Order or Quote as Rush

Change Sales Order Status

Send Sales Order Message

Contact by Id

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows