Cin7 Core Inventory + Google Sheets
Create sales in Cin7 Core Inventory from new Google Sheets rows
Effortlessly track sales in your Cin7 Core Inventory system whenever a new row is added to your Google Sheets spreadsheet with this seamless workflow. It helps transfer data from your spreadsheet to Cin7 Core Inventory, creating a sale record and keeping your inventory management up-to-date. Save time, reduce manual data entry errors, and maintain an organized inventory management process.
Effortlessly track sales in your Cin7 Core Inventory system whenever a new row is added to your Google Sheets spreadsheet with this seamless workflow. It helps transfer data from your spreadsheet to Cin7 Core Inventory, creating a sale record and keeping your inventory management up-to-date. Save time, reduce manual data entry errors, and maintain an organized inventory management process.
- When this happens...
New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create SaleCreates a new sale.
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
Sale Additional Info Added
Triggers when an additional information is added to a sale
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sale Credit Note Authorised
Triggers when a sales credit note authorised.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sale Invoice Authorised
Triggers when a sales invoice authorised.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sale Shipment Tracking Number Changed
Triggers when a sale's shipment tracking number changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Stock Level Update
Triggered when a change is made to product availability.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sale IDRequired
File NameRequired
Is Processed
File Content
File Download URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sale IDRequired
StatusRequired
SKURequired
LocationRequired
Package #
QuantityRequired
Batch Serial Number
Expiry Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SKURequired
NameRequired
CategoryRequired
Brand
TypeRequired
Costing MethodRequired
DropShip Mode
Length
Width
Height
Weight
Unit of MeasureRequired
Weight Unit of Measure
Dimensions Unit of Measure
Barcode
Minimum Before Reorder
Reorder Quantity
Price Tier 1Required
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sale IDRequired
Keep Existing Shipment Lines
StatusRequired
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 DateRequired
Carrier
Package #Required
Tracking Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From LocationRequired
To LocationRequired
Departure DateRequired
Completion DateRequired
Reference
SKURequired
Transfer QuantityRequired
Batch Serial Number
Expiry Date
Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sale IDRequired
CustomerRequired
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
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.Customer Name
Contact Name / Email
ActionThis is an event a Zap performs.SearchFind existing data in your appPage numberRequired
Limit per pageRequired
ID of product
Name of product
Sku of product
Non Zero Products OnlyRequired
Location
Batch #
Category
ActionThis is an event a Zap performs.SearchFind existing data in your appTask IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTask IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch
Status
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 foundSale Attachment Added
Triggers when an attachment is added to a sale
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Sale
Triggers when a new sale is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
CurrencyRequired
Payment TermRequired
Discount
TaxRuleRequired
Carrier
Sales Representative
Location
Comments
Account ReceivableRequired
Revenue AccountRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sale IDRequired
Payment Type
Reference
AmountRequired
Date PaidRequired
AccountRequired
Currency RateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Contact
Phone
Email
Order Date
Sale Account
SKURequired
QuantityRequired
PriceRequired
TaxRequired
TotalRequired
Line Order
Discount
Sale Account
Tax RuleRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Effective DateRequired
Account
Reference
SKURequired
QuantityRequired
Unit CostRequired
LocationRequired
Batch Serial Number
Expiry Date
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
CurrencyRequired
Payment TermRequired
Discount
Tax RuleRequired
Comments
Account PayableRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
SKURequired
NameRequired
CategoryRequired
Brand
TypeRequired
Costing MethodRequired
DropShip Mode
Length
Width
Height
Weight
Unit of MeasureRequired
Weight Unit of Measure
Dimensions Unit of Measure
Barcode
Minimum Before Reorder
Reorder Quantity
Price Tier 1Required
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
NameRequired
CurrencyRequired
PaymentTermRequired
Discount
Tax RuleRequired
Comments
Account PayableRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assembly Status
Search
Sale ID
ActionThis is an event a Zap performs.SearchFind existing data in your appSale ID
Order Number
Invoice Number
Credit Note Number
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct ID
Product Name
Product SKU
ActionThis is an event a Zap performs.SearchFind existing data in your appTask IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSale IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Contact Name / Email
CurrencyRequired
Payment TermRequired
Discount
TaxRuleRequired
Carrier
Sales Representative
Location
Comments
Account ReceivableRequired
Revenue AccountRequired
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
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 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.
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
Smartsheet
SpreadsheetsRelated Zap Templates
- Add new or updated Cin7 Core Inventory products to Google Sheets as rows
- Add new Cin7 Core Inventory payments to Google Sheets as rows
- Manage new or updated suppliers in Cin7 Core Inventory by creating worksheets in Google Sheets
- Create spreadsheet rows in Google Sheets for new or updated purchases in Cin7 Core Inventory
- Create multiple rows in Google Sheets when sales are voided or undone in Cin7 Core Inventory
- Add new Cin7 Core Inventory sales to Google Sheets as spreadsheet rows
- Create new Cin7 Core Inventory products from new or updated rows in Google Sheets
- Add new or updated rows in Google Sheets to create sale shipments in Cin7 Core Inventory
- Create spreadsheets in Google Sheets for new sales in Cin7 Core Inventory