BigCommerce + Google Sheets
Add new Google Sheets rows to BigCommerce as customer addresses
The more customer information you have stored in BigCommerce, the more powerful the platform becomes. Use this Zap to automatically add new Google Sheets rows to BigCommerce as customer addresses. That way, all your customer information is in one place, so you don't have to go searching around for it.
The more customer information you have stored in BigCommerce, the more powerful the platform becomes. Use this Zap to automatically add new Google Sheets rows to BigCommerce as customer addresses. That way, all your customer information is in one place, so you don't have to go searching around for it.
- When this happens...
New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
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 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.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.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
Bottom-Up
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
Bottom-Up
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
Customer Address Created
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Category ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Updated
Triggers when a customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Channel ID
Filter by Status ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TitleRequired
Url
BodyRequired
Is Published
Meta Description
Meta Keywords
Author
Thumbnail Path
Tags
Published Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Company
Address 1Required
Address 2
CityRequired
State Or ProvinceRequired
Postal CodeRequired
Country CodeRequired
Phone
Address Type
Customer IdRequired
Id
Country
Name
Value
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.Name
Company
Customer ID
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
Company
ID
Customer Group
First NameRequired
Last NameRequired
Phone
Registration IP Address
Notes
Tax Exempt Category
Customer Group ID
Force Password Reset
New Password
Accepts Product Review Abandoned Cart Emails
Store Credit Amounts
Origin Channel ID
Channel IDs
Name
Value
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
SKU
ID
TypeRequired
Description
WeightRequired
Width
Depth
Height
PriceRequired
Cost Price
Retail Price
Sale Price
Map Price
Tax Class Id
Product Tax Code
Categories
Brand Id
Inventory Level
Inventory Warning Level
Inventory Tracking
Fixed Cost Shipping Price
Is Free Shipping
Is Visible
Is Featured
Related Products
Warranty
Bin Picking Number
Layout File
Upc
Search Keywords
Availability Description
Availability
Gift Wrapping Options Type
Gift Wrapping Options List
Sort Order
Condition
Is Condition Shown
Order Quantity Minimum
Order Quantity Maximum
Page Title
Meta Keywords
Meta Description
View Count
Preorder Release Date
Preorder Message
Is Preorder Only
Is Price Hidden
Price Hidden Label
Url
Is Customized
Open Graph Type
Open Graph Title
Open Graph Description
Open Graph Use Meta Description
Open Graph Use Product Name
Open Graph Use Image
Gtin
Mpn
Reviews Rating Sum
Reviews Count
Total Sold
Custom Fields ID
Custom Fields NameRequired
Custom Fields ValueRequired
Bulk Pricing Rules ID
Bulk Pricing Rules Quantity Min
Bulk Pricing Rules Quantity Max
Bulk Pricing Rules Type
Bulk Pricing Rules Amount
Images Image File
Images Is Thumbnail?
Images Sort order
Images Description
Images Image URL
Images ID
Images Product ID
Images URL Zoom
Images URL Standard
Images URL thumbnail
Images URL Tiny
Images Date modified
Videos Title
Videos Description
Videos Sort order
Videos Type
Videos Video ID
Videos ID
Videos Product ID
Videos Length
Variants Cost Price
Variants Price
Variants Sale Price
Variants Retail Price
Variants Weight
Variants Width
Variants Height
Variants Depth
Variants Is free shipping?
Variants Fixed cost shipping price
Variants Purchasing disabled
Variants Purchasing disabled message
Variants UPC
Variants Inventory level
Variants Inventory warning level
Variants BIN Picking number
Variants Product ID
Variants SKU
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 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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Text Bold
Text Italic
Text 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
Bottom-Up
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
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCustomer Created
Triggers when an new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Channel ID
Filter by Status ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Shipment Created
Triggers when a new shipment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Address Updated
Triggers when a customer address is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Status Updated
Triggers when an order status have changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
First NameRequired
Last NameRequired
Company
Phone
Registration IP Address
Notes
Tax Exempt Category
Customer Group ID
ID
Force Password Reset
New Password
Accepts Product Review Abandoned Cart Emails
Store Credit Amounts
Origin Channel ID
Channel IDs
Name
Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
TypeRequired
Sku
Description
WeightRequired
Width
Depth
Height
PriceRequired
Cost Price
Retail Price
Sale Price
Map Price
Tax Class Id
Product Tax Code
Categories
Brand Id
Inventory Level
Inventory Warning Level
Inventory Tracking
Fixed Cost Shipping Price
Is Free Shipping
Is Visible
Is Featured
Related Products
Warranty
Bin Picking Number
Layout File
Upc
Search Keywords
Availability Description
Availability
Gift Wrapping Options Type
Gift Wrapping Options List
Sort Order
Condition
Is Condition Shown
Order Quantity Minimum
Order Quantity Maximum
Page Title
Meta Keywords
Meta Description
View Count
Preorder Release Date
Preorder Message
Is Preorder Only
Is Price Hidden
Price Hidden Label
Url
Is Customized
Open Graph Type
Open Graph Title
Open Graph Description
Open Graph Use Meta Description
Open Graph Use Product Name
Open Graph Use Image
Gtin
Mpn
Reviews Rating Sum
Reviews Count
Total Sold
Custom Fields ID
Custom Fields NameRequired
Custom Fields ValueRequired
Bulk Pricing Rules ID
Bulk Pricing Rules Quantity Min
Bulk Pricing Rules Quantity Max
Bulk Pricing Rules Type
Bulk Pricing Rules Amount
Images Image File
Images Is Thumbnail?
Images Sort order
Images Description
Images Image URL
Images ID
Images Product ID
Images URL Zoom
Images URL Standard
Images URL thumbnail
Images URL Tiny
Images Date modified
Videos Title
Videos Description
Videos Sort order
Videos Type
Videos Video ID
Videos ID
Videos Product ID
Videos Length
Variants Cost Price
Variants Price
Variants Sale Price
Variants Retail Price
Variants Weight
Variants Width
Variants Height
Variants Depth
Variants Is free shipping?
Variants Fixed cost shipping price
Variants Purchasing disabled
Variants Purchasing disabled message
Variants UPC
Variants Inventory level
Variants Inventory warning level
Variants BIN Picking number
Variants Product ID
Variants SKU
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Company
ID
Customer Group
ActionThis is an event a Zap performs.SearchFind existing data in your appName
SKU
ID
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Company
Customer ID
First NameRequired
Last NameRequired
Address 1Required
Address 2
CityRequired
State Or ProvinceRequired
Postal CodeRequired
Country CodeRequired
Phone
Address Type
Customer IdRequired
Id
Country
Name
Value
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 BigCommerce
BigCommerce is an e-commerce platform that provides an all-encompassing solution for a business' online store. If you're trying to sell physical goods online, you'll want to check out Bigcommerce.
Related categories
Similar apps
Shopify
eCommerce
Magento
eCommerce
WooCommerce
eCommerce, WordPress
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsRelated Zap Templates
- Add new Bigcommerce orders to Google Sheets as rows
- Add new BigCommerce customers to a Google Sheets spreadsheet as rows
- Create rows in Google Sheets for new BigCommerce products
- Add new BigCommerce orders to Google Sheets as multiple rows
- Track abandoned carts in BigCommerce by creating new rows in a Google Sheets spreadsheet