How to connect Cin7 Core Inventory + Google Sheets + Webhooks by Zapier
Zapier lets you send info between Cin7 Core Inventory and Google Sheets and Webhooks by Zapier automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Cin7 Core Inventory + Google Sheets + Webhooks by Zapier
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Cin7 Core Inventory, Google Sheets, and Webhooks by Zapier. And don’t forget that you can add more apps and actions to create complex workflows.
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 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 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 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
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
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
ColumnsRequired
Row CountRequired
First Row
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 foundURLRequired
Key
Deduplication Key
Xpath
Basic Auth
Headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planURLRequired
Query String Params
Send As JSON
JSON key
Unflatten
Basic Auth
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Payload Type
Data
Wrap Request In Array
File
Unflatten
Basic Auth
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
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 appDrive
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.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
Search from last row
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCatch Raw Hook
Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.MethodRequired
URLRequired
Data Pass-Through?
Data
Unflatten
Basic Auth
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Payload Type
Data
Wrap Request In Array
File
Unflatten
Basic Auth
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Cin7 Core Inventory + Google Sheets + Webhooks by Zapier Integrations Work
- Step 1: Authenticate Cin7 Core Inventory, Google Sheets, and Webhooks by Zapier.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.