B2B Wave + Google Sheets
Update product quantities in B2B Wave from new or updated Google Sheets rows
Do you manage your product inventory in Google Sheets? When there is a new or updated Google Sheets row, this integration will search for the product in B2B Wave. If the product doesn't exist, it will be created. Then, the product quantity will be updated.
Do you manage your product inventory in Google Sheets? When there is a new or updated Google Sheets row, this integration will search for the product in B2B Wave. If the product doesn't exist, it will be created. Then, the product quantity will be updated.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Update Product QuantityFinds a product by ID or Code and updates its Quantity
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 foundHours Ago CreatedRequired
Created After Date
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Order Status Update
Triggers when an order status is changed
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEmailRequired
Company NameRequired
NameRequired
Is Active
Phone
Pricelist IDRequired
VAT Group ID
Address
Address Line 2
City
State
Country (2-letter code)
Postal Code
Company Number
Tax ID
Sales Rep ID
Customer Reference Code
Same Address For Billing
Billing Address
Billing Address Line 2
Billing City
Billing State
Billing Country (2-letter code)
Billing Postal Code
Billing Company Name
Billing Name
Billing Tax ID
Billing Tax Office
MSRP Pricelist ID
Disable Ordering
Company Activities
Company Activity Id
Privacy Group Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product Code (SKU)
Product ID
Product Variant ID
Customer IDRequired
PriceRequired
Apply Extra Discounts
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
Integration RefRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
Status Order ID
Status Order Name
Notify
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find by ID
Find by Code
New Quantity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find byRequired
ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFind ByRequired
Search ValueRequired
EmailRequired
Company NameRequired
NameRequired
Is Active
Phone
Pricelist IDRequired
VAT Group ID
Address
Address Line 2
City
State
Country (2-letter code)
Postal Code
Company Number
Tax ID
Sales Rep ID
Customer Reference Code
Same Address For Billing
Billing Address
Billing Address Line 2
Billing City
Billing State
Billing Country (2-letter code)
Billing Postal Code
Billing Company Name
Billing Name
Billing Tax ID
Billing Tax Office
MSRP Pricelist ID
Disable Ordering
Company Activities
Company Activity Id
Privacy Group Name
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 foundNew Addressbook
Triggers when a new addressbook is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Order
Triggers when a new order is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Product
Triggers when a new product is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planProduct Code (SKU)
NameRequired
Category ID
Category Path
Description
Is Active
Quantity
Status ID
VAT Class ID
Minimum Quantity
Quantity Monitor
Image URL
URL
UPC
MPN
Barcode
Manufacturer ID
Reference Code
Cost
Is Private
Estimated Availability Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Email
Company Name
Name
Is Active
Phone
Pricelist ID
VAT Group ID
Address
Address Line 2
City
State
Country (2-letter code)
Postal Code
Company Number
Tax ID
Tax Office
Sales Rep ID
Customer Reference Code
Same Address For Billing
Billing Phone
Billing Address
Billing Address Line 2
Billing City
Billing State
Billing Country (2-letter code)
Billing Postal Code
Billing Company Name
Billing Name
Billing Tax ID
Billing Tax Office
Minimum Order Value
MSRP Pricelist ID
Disable Ordering
Company Activities
Company Activity Id
Privacy Group Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
Shipping Tracking NumberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Product Code (SKU)
Name
Category ID
Description
Is Active
Status ID
VAT Class ID
Quantity
Minimum Quantity
Image URL
URL
UPC
MPN
Barcode
Manufacturer ID
Rerefence Code
Cost
Is Private
Category Path
Estimated Availability Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFind ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFind ByRequired
Search ValueRequired
Product Code (SKU)
NameRequired
Category ID
Category Path
Description
Is Active
Quantity
Status ID
VAT Class ID
Minimum Quantity
Quantity Monitor
Image URL
URL
UPC
MPN
Barcode
Manufacturer ID
Reference Code
Cost
Is Private
Estimated Availability Date
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 B2B Wave
Related categories
