Cin7 Core Inventory + Smartsheet

Cin7 Core Inventory + Smartsheet integrations

Add new or updated purchases in Cin7 Core Inventory to a Smartsheet as rows

Ensure your inventory management is up-to-date and organized with this workflow. When an order is placed or updated in Cin7 Core Inventory, a new row will be added in your Smartsheet to help you maintain track of stock levels. This workflow makes it easy to stay on top of your operations, optimizing efficiency in your warehousing and logistics.

When this happens...
New Purchase / Updated PurchaseTriggered when purchases are created or updated.
TriggerInstant
automatically do this!
Add Row to SheetAdd a row to a sheet.
ActionWrite

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 Cin7 Core Inventory and Smartsheet

Discover other triggers and actions you can use with Cin7 Core Inventory and Smartsheet

- Status
  Required
Trigger
Instant
Try It
- Status
  Required
Trigger
Instant
Try It
Sale Attachment Added
Triggers when an attachment is added to a sale
Trigger
Instant
Try It
New Sale
Triggers when a new sale is created.
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It

- Event Type
  Required
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It

- Status
  Required
Trigger
Instant
Try It
- Name
  Required
- Currency
  Required
- Payment Term
  Required
- Discount
- TaxRule
  Required
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
  Required
- Revenue Account
  Required
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Sale ID
  Required
- Payment Type
- Reference
- Amount
  Required
- Date Paid
  Required
- Account
  Required
- Currency Rate
  Required
Action
Write
- Customer
  Required
- Contact
- Phone
- Email
- Order Date
- Sale Account
- SKU
  Required
- Quantity
  Required
- Price
  Required
- Tax
  Required
- Total
  Required
- Line Order
- Discount
- Sale Account
- Tax Rule
  Required
- Comment
- DropShip
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address State
- Billing Address Postcode
- Billing Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Carrier
- Ship By
- Tax Rule
- Tax Inclusive
- Terms
- Price Tier
- Location
- Note
- Customer Reference
- Invoice Status
- Order Status
- AutoPickPackShip Mode
- Sales Representative
- Invoice Date
- Invoice Due Date
- Currency Rate
- Order Memo
- Invoice Memo
- Reference
- Amount
- DatePaid
- Account
- Currency Rate
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
Action
Write
- Effective Date
  Required
- Account
- Reference
- SKU
  Required
- Quantity
  Required
- Unit Cost
  Required
- Location
  Required
- Batch Serial Number
- Expiry Date
- Comments
Action
Write
- Name
  Required
- Currency
  Required
- Payment Term
  Required
- Discount
- Tax Rule
  Required
- Comments
- Account Payable
  Required
- Tax Number
- Attribute Set
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Line 1 (required when Addresses provided)
- Line 2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Product ID
  Required
- SKU
  Required
- Name
  Required
- Category
  Required
- Brand
- Type
  Required
- Costing Method
  Required
- DropShip Mode
- Length
- Width
- Height
- Weight
- Unit of Measure
  Required
- Weight Unit of Measure
- Dimensions Unit of Measure
- Barcode
- Minimum Before Reorder
- Reorder Quantity
- Price Tier 1
  Required
- Price Tier 2
- Price Tier 3
- Price Tier 4
- Price Tier 5
- Price Tier 6
- Price Tier 7
- Price Tier 8
- Price Tier 9
- Price Tier 10
- Short Description
- Description
- Tags
- Stock Locator
- Pick Zones
Action
Write
- ID
  Required
- Name
  Required
- Currency
  Required
- PaymentTerm
  Required
- Discount
- Tax Rule
  Required
- Comments
- Account Payable
  Required
- Tax Number
- Attribute Set
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Line 1 (required when Addresses provided)
- Line 2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Assembly Status
- Search
- Sale ID
Action
Search
- Sale ID
- Order Number
- Invoice Number
- Credit Note Number
Action
Search
- Product ID
- Product Name
- Product SKU
Action
Search
- Task ID
  Required
Action
Search
- Sale ID
  Required
Action
Search
- Name
  Required
- Contact Name / Email
- Currency
  Required
- Payment Term
  Required
- Discount
- TaxRule
  Required
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
  Required
- Revenue Account
  Required
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Search or write
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet ID
  Required
- Query
  Required
Action
Search

- Status
  Required
Trigger
Instant
Try It
Sale Additional Info Added
Triggers when an additional information is added to a sale
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It
Sale Credit Note Authorised
Triggers when a sales credit note authorised.
Trigger
Instant
Try It
Sale Invoice Authorised
Triggers when a sales invoice authorised.
Trigger
Instant
Try It
Sale Shipment Tracking Number Changed
Triggers when a sale's shipment tracking number changed.
Trigger
Instant
Try It
Stock Level Update
Triggered when a change is made to product availability.
Trigger
Instant
Try It
- Sale ID
  Required
- File Name
  Required
- Is Processed
- File Content
- File Download URL
Action
Write
- Sale ID
  Required
- Status
  Required
- SKU
  Required
- Location
  Required
- Package #
- Quantity
  Required
- Batch Serial Number
- Expiry Date
Action
Write
- SKU
  Required
- Name
  Required
- Category
  Required
- Brand
- Type
  Required
- Costing Method
  Required
- DropShip Mode
- Length
- Width
- Height
- Weight
- Unit of Measure
  Required
- Weight Unit of Measure
- Dimensions Unit of Measure
- Barcode
- Minimum Before Reorder
- Reorder Quantity
- Price Tier 1
  Required
- Price Tier 2
- Price Tier 3
- Price Tier 4
- Price Tier 5
- Price Tier 6
- Price Tier 7
- Price Tier 8
- Price Tier 9
- Price Tier 10
- Short Description
- Description
- Tags
- Stock Locator
- Pick Zones
Action
Write
- Sale ID
  Required
- Keep Existing Shipment Lines
- Status
  Required
- Require By Date
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Shipping Notes
- Shipment Date
  Required
- Carrier
- Package #
  Required
- Tracking Number
Action
Write
- From Location
  Required
- To Location
  Required
- Departure Date
  Required
- Completion Date
  Required
- Reference
- SKU
  Required
- Transfer Quantity
  Required
- Batch Serial Number
- Expiry Date
- Comment
Action
Write
- ID
  Required
- Name
- Currency
- Payment Term
- Discount
- TaxRule
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
- Revenue Account
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Sale ID
  Required
- Customer
  Required
- Contact
- Phone
- Email
- Order Date
- Sale Account
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address State
- Billing Address Postcode
- Billing Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Carrier
- Ship By
- Tax Rule
- Tax Inclusive
- Terms
- Price Tier
- Location
- Note
- Customer Reference
- Sales Representative
- Currency Rate
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Customer Name
- Contact Name / Email
Action
Search
- Page number
  Required
- Limit per page
  Required
- ID of product
- Name of product
- Sku of product
- Non Zero Products Only
  Required
- Location
- Batch #
- Category
Action
Search
- Task ID
  Required
Action
Search
- Task ID
  Required
Action
Search
- Search
- Status
Action
Search
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Workspace
- Source Folder
  Required
- Destination Workspace
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search

About Cin7 Core Inventory

Cin7 Core Inventory is an all in one holistic solution for Inventory Management, POS & B2B eCommerce. Easily manage all your inventory, purchases, sales, suppliers and customers in one easy to use system.

Learn moreLearn moreHelpHelp

Related categories

Accounting

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Related Zap Templates

Add rows to Smartsheet for updated sales status changes in Cin7 Core Inventory

Related Zap Templates

Add rows to Smartsheet for updated sales status changes in Cin7 Core Inventory