Google Sheets + Google Forms + DEAR Inventory Integrations
How to connect Google Sheets + Google Forms + DEAR Inventory
Zapier lets you send info between Google Sheets, Google Forms, and DEAR Inventory automatically—no code required.
Top companies trust Zapier to automate work and free up time
Do even more with Google Sheets + Google Forms + DEAR Inventory
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 Google Sheets, Google Forms, and DEAR Inventory. And don’t forget that you can add more apps and actions to create complex workflows.
New Spreadsheet Row (Team Drive)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.Trigger- New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.Trigger
- New SpreadsheetTriggered when you create a new spreadsheet.Trigger
- New or Updated Spreadsheet Row (Team Drive)Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.Trigger
- New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.Trigger
- New WorksheetTriggered when you create a new worksheet in a spreadsheet.Trigger
- Create Spreadsheet ColumnCreate a new column in a specific spreadsheet.Action
- Create Spreadsheet RowCreate a new row in a specific spreadsheet.Action
- Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
- Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
- Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
- Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
- Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
- Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
- Google Forms
Triggers when a new form response is received.
Instant
Trigger
- Google Forms
Triggers when a form response is added or modified.
Instant
Trigger
- DEAR Inventory
Triggered when customers are created or updated.
Instant
Trigger
- DEAR Inventory
Triggered when products are created or updated.
Instant
Trigger
- DEAR Inventory
Triggered when purchases are created or updated.
Instant
Trigger
- DEAR Inventory
Triggers when an additional information is added to a sale
Instant
Trigger
- DEAR Inventory
Triggers when an attachment is added to a sale
Instant
Trigger
- DEAR Inventory
Triggers when a sale is voided or undone.
Instant
Trigger
- DEAR Inventory
Triggers when a sales credit note authorised.
Instant
Trigger
- DEAR Inventory
Triggers when a sale's fulfilment status is updated.
Instant
Trigger
- DEAR Inventory
Triggers when a sales invoice authorised.
Instant
Trigger
- DEAR Inventory
Triggers when a payment is added to a sale.
Instant
Trigger
- DEAR Inventory
Triggers when a sale's shipment tracking number changed.
Instant
Trigger
- DEAR Inventory
Triggers when a sales status is changed.
Instant
Trigger
- DEAR Inventory
Triggered when a change is made to product availability.
Instant
Trigger
- DEAR Inventory
Triggered when suppliers are created or updated.
Instant
Trigger
- DEAR Inventory
Adds attachment to sale.
Scheduled
Action
- DEAR Inventory
Creates a new customer.
Scheduled
Action
- DEAR Inventory
Adds pack to sale.
Scheduled
Action
- DEAR Inventory
Adds payment to sale.
Scheduled
Action
- DEAR Inventory
Creates a new product.
Scheduled
Action
- DEAR Inventory
Creates a new sale.
Scheduled
Action
- DEAR Inventory
Adds shipment to sale.
Scheduled
Action
- DEAR Inventory
Creates a stock adjustment.
Scheduled
Action
- DEAR Inventory
Creates a stock transfer.
Scheduled
Action
- DEAR Inventory
Creates a new supplier.
Scheduled
Action
- DEAR Inventory
Updates a customer.
Scheduled
Action
- DEAR Inventory
Updates the product.
Scheduled
Action
- DEAR Inventory
Updates a sale.
Scheduled
Action
- DEAR Inventory
Updates a supplier.
Scheduled
Action
- DEAR Inventory
Search for assembly by status, sale id or other fields.
Scheduled
Action
- DEAR Inventory
Search for customer by name.
Scheduled
Action
- DEAR Inventory
Search for sale payments by sale id, order number, invoice number, credit note number.
Scheduled
Action
- DEAR Inventory
Search for products availability.
Scheduled
Action
- DEAR Inventory
Search for product by name or sku.
Scheduled
Action
- DEAR Inventory
Search for sale credit note by id.
Scheduled
Action
- DEAR Inventory
Search for sale fulfilment by id.
Scheduled
Action
- DEAR Inventory
Search for sale invoice by id.
Scheduled
Action
- DEAR Inventory
Search for sale by id.
Scheduled
Action
- DEAR Inventory
Search for sale by order number, status, customer, invoice number, customer reference, credit note number.
Scheduled
Action
- DEAR Inventory
Create DEAR customer if it doesn't exist yet?
Scheduled
Action
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How Google Sheets + Google Forms + DEAR Inventory Integrations Work
- Step 1: Authenticate Google Sheets, Google Forms, and DEAR Inventory.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.
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.