Cin7 Core Inventory + Google Sheets
Create new Cin7 Core Inventory customers from new Google Sheets rows
When a new row is added in Google Sheets, this workflow ensures the information is directly utilized to create a new customer profile in Cin7 Core Inventory. Eliminate duplication efforts while maintaining consistency and accuracy in customer data. This automation brings an efficient process to managing your inventory's client base.
When a new row is added in Google Sheets, this workflow ensures the information is directly utilized to create a new customer profile in Cin7 Core Inventory. Eliminate duplication efforts while maintaining consistency and accuracy in customer data. This automation brings an efficient process to managing your inventory's client base.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create CustomerCreates a new customer.
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 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
Sale 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
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 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 foundSale 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
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.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
About Cin7 Core Inventory
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Add new or updated Cin7 Core Inventory products to Google Sheets as rows
- Create sales in Cin7 Core Inventory from new Google Sheets 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
- Update Google Sheets rows with new Cin7 Core Inventory stock levels
- Create spreadsheet rows in Google Sheets for new or updated products in Cin7 Core Inventory
- Create spreadsheet rows in Google Sheets for new or updated customers in Cin7 Core Inventory
Related Zap Templates
- Add new or updated Cin7 Core Inventory products to Google Sheets as rows
- Manage new or updated suppliers in Cin7 Core Inventory by creating worksheets in Google Sheets
- Add new Cin7 Core Inventory sales to Google Sheets as spreadsheet rows
- Create spreadsheets in Google Sheets for new sales in Cin7 Core Inventory
- Create spreadsheet rows in Google Sheets for new or updated customers in Cin7 Core Inventory
- Create sales in Cin7 Core Inventory from new Google Sheets rows
- Create spreadsheet rows in Google Sheets for new or updated purchases in Cin7 Core Inventory
- Create new Cin7 Core Inventory products from new or updated rows in Google Sheets
- Update Google Sheets rows with new Cin7 Core Inventory stock levels
- Add new Cin7 Core Inventory payments to Google Sheets as rows
- Create multiple rows in Google Sheets when sales are voided or undone in Cin7 Core Inventory
- Add new or updated rows in Google Sheets to create sale shipments in Cin7 Core Inventory
- Create spreadsheet rows in Google Sheets for new or updated products in Cin7 Core Inventory