Connect Cin7 Core Inventory and Google Sheets to unlock the power of automation

No credit card required
Free forever for core features
14-day trial for premium features and apps

Choose a Trigger

Choose an Action

Start with Google for free

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

Set up your first integration

Quickly connect Cin7 Core Inventory to Google Sheets with a Zapier template.

Our most popular template

Add new or updated Cin7 Core Inventory products to Google Sheets as rows
Details
Try it
Cin7 Core Inventory + Google Sheets
Create sales in Cin7 Core Inventory from new Google Sheets rows
Details
Try it
Google Sheets + Cin7 Core Inventory
Add new Cin7 Core Inventory payments to Google Sheets as rows
Details
Try it
Cin7 Core Inventory + Google Sheets
Manage new or updated suppliers in Cin7 Core Inventory by creating worksheets in Google Sheets
Details
Try it
Cin7 Core Inventory + Google Sheets
Create spreadsheet rows in Google Sheets for new or updated purchases in Cin7 Core Inventory
Details
Try it
Cin7 Core Inventory + Google Sheets
Create multiple rows in Google Sheets when sales are voided or undone in Cin7 Core Inventory
Details
Try it
Cin7 Core Inventory + Google Sheets

Add new or updated Cin7 Core Inventory products to Google Sheets as rows

Details

Try it

Cin7 Core Inventory + Google Sheets

Create sales in Cin7 Core Inventory from new Google Sheets rows

Details

Try it

Google Sheets + Cin7 Core Inventory

Add new Cin7 Core Inventory payments to Google Sheets as rows

Details

Try it

Cin7 Core Inventory + Google Sheets

Manage new or updated suppliers in Cin7 Core Inventory by creating worksheets in Google Sheets

Details

Try it

Cin7 Core Inventory + Google Sheets

Create spreadsheet rows in Google Sheets for new or updated purchases in Cin7 Core Inventory

Details

Try it

Cin7 Core Inventory + Google Sheets

Create multiple rows in Google Sheets when sales are voided or undone in Cin7 Core Inventory

Details

Try it

Cin7 Core Inventory + Google Sheets

Add new Cin7 Core Inventory sales to Google Sheets as spreadsheet rows
Details
Try it
Cin7 Core Inventory + Google Sheets
Create new Cin7 Core Inventory products from new or updated rows in Google Sheets
Details
Try it
Google Sheets + Cin7 Core Inventory

How Zapier works

Zapier makes it easy to integrate Cin7 Core Inventory with Google Sheets - no code necessary. See how you can get setup in minutes.

Select a trigger from Cin7 Core Inventory

A trigger is an event that starts your Zap and runs the workflow. For example, with Cin7 Core Inventory, a trigger could be "New Customer / Updated Customer."

A trigger is the event that kicks off your automated workflow.

Setup an action from Google Sheets

An action is what takes place after the automation is triggered. For example, with Google Sheets, the action could be "Create Spreadsheet Column."

An action is the event that your automated workflow performs when triggered.

That’s it! You just connected Cin7 Core Inventory to Google Sheets

With Zapier, it’s never been easier to connect your apps together and automate your most tedious work. Save hours every month.

Triggers and actions are the main components of every automated workflow.

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Most Implementable - Winter 2024

G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Make work flow with AI

Level up your Cin7 Core Inventory to Google Sheets integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.

Learn about AI automation

Illustration of AI enhancing Zapier workflows with automation and app integrations.

Frequently Asked Questions about Cin7 Core Inventory + Google Sheets integrations

New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Cin7 Core Inventory and Google Sheets

What are the prerequisites for integrating Cin7 Core Inventory with Google Sheets?

To integrate Cin7 Core Inventory with Google Sheets, you need active accounts on both platforms. Ensure you have access to API keys and permissions required to connect these applications through our integration interface.

How often will the data sync between Cin7 Core and Google Sheets?

The sync frequency depends on how you configure triggers and actions in our system. You can set it up to update in real-time or at specified intervals such as hourly or daily depending on your needs.

Can I import specific inventory data from Cin7 Core into Google Sheets?

Yes, you can use specific triggers like 'New Product' or 'Inventory Level Below Threshold' to import only selected data into Google Sheets based on your criteria.

Is it possible to update inventory levels in Cin7 Core using Google Sheets?

Absolutely, by using actions we provide, such as 'Update Inventory,' you can modify inventory levels directly from Google Sheets which then sync back into Cin7 Core automatically.

What happens if there is a mismatch of data during integration?

Our integration system ensures that any mismatches trigger alerts which allow you to review discrepancies. You can set rules for handling these errors automatically or choose manual oversight depending on your preference.

Are there any limitations on the type of data I can transfer between Cin7 Core and Google Sheets?

While most inventory related data can be transferred seamlessly, there might be certain fields restricted due to API limitations. We recommend reviewing our documentation for specifics or contacting support for assistance.

Do I need technical expertise to set up the integration between Cin7 Core and Google Sheets?

Not necessarily. Our user-friendly interface guides you through setting up triggers and actions without needing extensive programming knowledge. However, some familiarity with both platforms might be beneficial for handling custom configurations.

Connect Cin7 Core Inventory and Google Sheets to integrate crucial parts of your business

With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.

Automate your lead management and improve conversions

With Zapier, you can automate every part of your lead funnel and give yourself the best chance at converting leads. Automate everything from lead capture to outreach to reporting—and close more deals as a result.

An illustration representing how to automate lead management with Zapier.

Create more impactful campaigns with automation

Measuring campaign performance across platforms can get chaotic. Plus, digging up the right metrics costs you precious time and effort. With Zapier, you can create a centralized view of your performance, skillfully manage your lists, and ensure your campaigns drive ROI across the business.

An illustration representing how to measure campaign impact with Zapier.

Provide world-class support with a little help from automation

Support reps can't be productive when they have to track down crucial information for every incident or ticket. With Zapier, you can automatically send your reps the context they need to resolve tickets quickly and create a seamless customer experience.

An illustration representing how to automate customer support with Zapier.

Automate your way to actionable, up-to-date data

The days of manually exporting and importing data are over. With Zapier, you can send data where it needs to go, in the format you need it—so you can centralize your data and unlock more insights.

An illustration representing how to move and manage data with Zapier.

Resolve incidents faster with automation

Your technical support team wants to focus on tech tickets rather than admin work. With Zapier, you can automate everything from ticket creation to routing to inter-team communication—eliminating friction from incident management and increasing speed to resolution.

An illustration of a flow chart representing how to resolve tickets and incidents with Zapier.

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

- 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
- Event Type
  Required
- 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
- TaxRule
  Required
- Tax Inclusive
- Terms
- Price Tier
- Location
- Note
- Customer Reference
- Invoice Status
- Order Status
- AutoPickPackShip Mode
- Sales Representative
- Invoice Date
- Invoice Due Date
- Currency Rate
  Required
- 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
  Required
- 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
- TaxRule
  Required
- Comments
- Account Payable
  Required
- Tax Number
- 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
- 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)
- Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- ID
  Required
- SKU
  Required
- Name (required when Contacts provided)
- Category
  Required
- Brand
- Type (required when Addresses provided)
- 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
- Payment Term
  Required
- Discount
- TaxRule
  Required
- Comments
- Account Payable
  Required
- Tax Number
- 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
- 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
- Status
  Required
- Search
- Sale ID
Action
Search
- Sale ID
- Order Number
- Invoice Number
- Credit Note Number
Action
Search
- ID
  Required
- Name
  Required
- Sku of product
Action
Search
- ID
  Required
Action
Search
- 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
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- Spreadsheet
  Required
Trigger
Scheduled
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Additional Request Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s) to Delete
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Keep Existing Shipment Lines
- URL
  Required
- Query String Parameters
- Additional Request Headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

- 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 when Contacts provided)
- Category
  Required
- Brand
- Type (required when Addresses provided)
- 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 #
- 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
- Comments
Action
Write
- ID
  Required
- 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
- 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
- TaxRule
  Required
- Tax Inclusive
- Terms
- Price Tier
- Location
- Note
- Customer Reference
- Sales Representative
- Currency Rate
  Required
- 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
- Keep Existing Shipment Lines
- URL
  Required
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Name
  Required
- Contact Name / Email
Action
Search
- Page number
  Required
- Limit per page
  Required
- ID
  Required
- Name
  Required
- Sku of product
- Non Zero Products Only
  Required
- Location
- Batch #
- Category
Action
Search
- ID
  Required
Action
Search
- ID
  Required
Action
Search
- Search
- Status
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Title
  Required
- Spreadsheet to Copy
- Additional Request Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row Count
- First Row
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Additional Request Headers
Action
Search or write

Learn how to automate Google Sheets on the Zapier blog

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 more

Related categories

Accounting

About Google Sheets

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

Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Connect Cin7 Core Inventory and Google Sheets to unlock the power of automation

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

Set up your first integration

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 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

How Zapier works

Select a trigger from Cin7 Core Inventory

Setup an action from Google Sheets

That’s it! You just connected Cin7 Core Inventory to Google Sheets

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

Make work flow with AI

Frequently Asked Questions about Cin7 Core Inventory + Google Sheets integrations

Connect Cin7 Core Inventory and Google Sheets to integrate crucial parts of your business

Automate your lead management and improve conversions

Create more impactful campaigns with automation

Provide world-class support with a little help from automation

Automate your way to actionable, up-to-date data

Resolve incidents faster with automation

Supported triggers and actions

Learn how to automate Google Sheets on the Zapier blog

How to track LeadConnector deals in Google Sheets

How to connect ChatGPT with Google Sheets

How to save Ecwid orders in Google Sheets

Connect Cin7 Core Inventory to Google Sheets on the world's largest no-code automation platform