Big Cartel + Google Sheets
Add Google Sheets rows for new Big Cartel orders
For every new order in your Big Cartel shop, add a row to a Google Sheets spreadsheet. This can simplify record keeping for a variety of scenarios including accounting, taxes, and customer service.
For every new order in your Big Cartel shop, add a row to a Google Sheets spreadsheet. This can simplify record keeping for a variety of scenarios including accounting, taxes, and customer service.
- When this happens...
New OrderTriggers when a new order is created
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Abandoned Cart
Triggers when a cart is abandoned in your shop
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Discount
Triggers when a new discount 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 planUpdated Product
Triggered when a product is updated
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCodeRequired
DescriptionRequired
Active atRequired
Expires at
Requirement typeRequired
Expiration typeRequired
Reward typeRequired
Application typeRequired
Percent discount
Flat rate discount
Use limit
Minimum cart total
Minimum cart quantity
Category Id
Product Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
Shipment IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.New Category NameRequired
Category IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
Customer First Name
Customer Last Name
Customer Email
Customer Phone Number
Customer Note
Shipping Address 1
Shipping Address 2
Shipping City
Shipping State
Shipping Zip Code or Postal Code
Shipping Country ID
Shipping Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
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.Search term
Shipping Status
Sort By
Sort Direction
Completed At From (YYYY-MM-DD)
Completed At To (YYYY-MM-DD)
Updated At From (YYYY-MM-DD)
Updated At To (YYYY-MM-DD)
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCategory IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDiscount Status
Sort By
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
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 found
New Category
Triggers when a new category 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 planUpdated Order
Triggers when an order is updated
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCategory NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Carrier Name
Tracking Number
Tracking URL
QuantityRequired
Order Line Item IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Discount IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Cart IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Discount IdRequired
DescriptionRequired
CodeRequired
Active at
Expires at
Requirement TypeRequired
Expiration typeRequired
Reward typeRequired
Application typeRequired
Percent discount
Flat rate discount amount
Use Limit
Minimum cart total
Minimum cart quantity
Category type
Category Id
Product type
Product Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IdRequired
Product Name
Product Description
Product Status
On Sale?
Default Price
Permalink
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Created At From
Created At To
Updated At From
Updated At To
ActionThis is an event a Zap performs.SearchFind existing data in your appStatus
Category Id
Quantity From
Quantity To
Search Term
Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your appSort by
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appDiscount IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IdRequired
Shipment IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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 found
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create Google Sheet rows for new orders in Big Cartel
- Create multiple rows in Google Sheets for new Big Cartel orders
- Update Google Sheets rows with new Big Cartel orders
- Create spreadsheets in Google Sheets for new products in Big Cartel
- Add new Big Cartel products to a Google Sheets spreadsheet row automatically