AmeriCommerce + Google Sheets

Add new AmeriCommerce orders to Google Sheets rows

Need an easy way to manage your data? This integration can help. Once set up, it automatically sends the details of a new AmeriCommerce order to a new row in specified Google Sheets spreadsheet. Skip the layout tasks and cut straight to the analysis.

When this happens...
New Valid Order
Triggers when a new valid order (meaning not declined or cancelled) is created.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

New Customer
Triggers when a customer is created in your AmeriCommerce store.
Trigger
Instant
Try It
New Product
Triggers when a product is added.
Trigger
Instant
Try It
New Valid Order
Triggers when a new valid order (meaning not declined or cancelled) is created.
Trigger
Instant
Try It
Order Updated
Triggers when an order is updated.
Trigger
Instant
Try It
Customer Email Updated
Triggers when a customer's email address is updated.
Trigger
Instant
Try It

- Order Id
- Order Number
- Order Date
- Customer Email
- Order Status
Action
Write
- Customer Email
- Order Status
- Order Date
- Order Number
- Customer First Name
- Customer Last Name
- Customer Phone
- Customer Type
- Subtotal
- Tax Total
- Shipping Total
- Discount Total
- Handling Total
- Additional Fees
- Grand Total
- Cost Total
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postal Code
- Shipping Address Country
- Shipping Address First Name
- Shipping Address Last Name
- Shipping Address Company
- Shipping Address Phone
- Shipping Address Alt Phone
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address State
- Billing Address Postal Code
- Billing Address Country
- Billing Address First Name
- Billing Address Last Name
- Billing Address Company
- Billing Address Phone
- Billing Address Alt Phone
- Adcode
- Referrer
- Coupon Code
- Source
- Source Group
- Search Phrase
- Is Gift?
- Gift Message
- Admin Comments
- Public Comments
- Shipping Method
- Manufacturer Invoice Number
- Manufacturer Invoice Amount
- Manufacturer Invoice Paid?
- Exported To Accounting System?
- Item Number
- Item Name
- Price
- Cost
- Quantity
- Weight
- Weight Units
- Height
- Length
- Width
- Size Unit
- Taxable?
- Tax Code
- Do Not Discount?
- Description
- Non Shipping Item?
- Variant Info
- Personalization Info
- Variant JSON
- Personalization JSON
- Gift Message
- Payment Method Name
- Payment Type
- Approved?
- Declined?
- Card Type
- Card Expiration Month
- Card Expiration Year
- Cardholder Name
- Paid At
- Approved At
- Authorization Code
- Reject Reason
- AVS Code
- CVV Response Code
- Transaction Type
- Amount
- Payment Note
- Captured?
- Transaction ID
- Last Four Of Card
- Void?
- Gateway Response Code
- Payment Ref Number
- Shipment Date
- Tracking Numbers
- Tracking Url
- Shipping Method
- Number Of Packages
- Total Weight
- Email Sent?
- Private Comment
- Shipping Comment
- Shipment Name
- Shipping Method Type
- Custom Field Name
- Custom Field Value
Action
Write

- Order Shipment Id
- Tracking Numbers
- Shipment Name
- Tracking Url
- Shipping Method
- Number Of Packages
- Total Weight
- Email Sent?
- Private Comment
- Shipping Comment
- Order Id
- Order Number
- Customer Email
- Order Date
- Order Status
Action
Write
- Email AddressRequired
- First Name
- Last Name
- Phone Number
- Alternate Phone Number
- Company
- Customer Type
- Taxable
- Tax Exemption Number
- Tax Rate
- Reward Tier
- Source
- Source Group
- Sales Note
- Adcode
- Customer Number
- First Name
- Last Name
- Address Line 1
- Address Line 2
- City
- State
- Postal Code
- Country
- Phone
- Alternate Phone
- Company
- Fax
- Comments
- Default Shipping Address
- Default Billing Address
- Name
- Value
Action
Write
- Item NumberRequired
- Item Name
- Primary Category Name
- Product Status
- GTIN
- Manufacturer Name
- Manufacturer Part Number
- Description
- Height
- Length
- Width
- Size Units
- Weight
- Weight Units
- Cost
- Price
- Retail Price
- Quantity On Hand
- Taxable
- Hidden
- Warehouse Name
- Non Shipping Item
- Custom Url
- Non Inventory
- Do Not Discount
- Handling Fee
- Category Name
- Primary
- Group Name
- Description
- Price Adjustment
- Price Adjustment Type
- Item Number Extension
- Default Selection
- Sort Order
- Hidden
- ID
- Store Name
- Customer Type
- Start Date
- End Date
- Starting Quantity
- Price
- Cost
- Attribute Group Name
- Attribute Name
- Attribute Value
- Image File Path
- Alt Text
- Description
- Primary Picture
- Hidden
- Thumbnail FIle
- Name
- Value
Action
Write
- Order Id
- Order Number
- Customer Email
- Order Date
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write

New Order
Triggers when a new order (of any status) is created.
Trigger
Instant
Try It
New Quote
Triggers when a new quote is added to your AmeriCommerce Store.
Trigger
Instant
Try It
Order Status Changed
Triggers when an order status changes.
Trigger
Instant
Try It
Updated Customer
Triggers when a customer is updated in your AmeriCommerce store.
Trigger
Instant
Try It
Updated Product
Triggers when a product is updated on your AmeriCommerce store.
Trigger
Instant
Try It
- Email AddressRequired
- First Name
- Last Name
- Phone Number
- Alternate Phone number
- Company
- Customer Number
- Customer Type
- Taxable
- Tax Exemption Number
- Tax Rate
- Reward Tier
- Source
- Source Group
- Sales Note
- Adcode
- Comments
- First Name
- Last Name
- Address Line 1
- Address Line 2
- City
- State
- Postal Code
- Country
- Phone
- Company
- Alternate Phone
- Fax
- Default Shipping Address
- Default Billing Address
- Comments
- Name
- Value
Action
Write
- Order Payment Id
- Payment Ref Number
- Transaction Id
- Payment Method Name
- Payment Type
- Approved?
- Declined?
- Card Type
- Card Expiration Month
- Card Expiration Year
- Cardholder Name
- Payment Date
- Approved At
- Authorization Code
- Reject Reason
- AVS Code
- Transaction Type
- Amount
- Payment Note
- Captured?
- Last Four
- Void?
- Gateway Response Code
- CVV Response Code
- Order Id
- Order Number
- Customer Email
- Order Date
Action
Write
- Item NumberRequired
- Item NameRequired
- Primary CategoryRequired
- Product StatusRequired
- GTIN/UPC
- Manufacturer
- Manufacturer Part Number
- Description
- Height
- Length
- Width
- Size Units
- Weight
- Weight Units
- Price
- Cost
- Retail
- Quantity On Hand
- Taxable
- Hidden
- Sort Order
- Warehouse Name
- Non Shipping Item
- Custom URL
- Non Inventory
- Discontinued
- Do Not Discount
- Handling Fee
- Category Name
- Primary
- Group Name
- Description
- Price Adjustment
- Price Adjustment Type
- Item Number Extension
- Hidden
- Default Selection
- ID
- Store Name
- Customer Type
- Start Date
- End Date
- Starting Quantity
- Price
- Cost
- Attribute Group Name
- Attribute Name
- Attribute Value
- Image FIle
- Alt Text
- Description
- Primary
- Hidden
- Thumbnail File
- Name
- Value
Action
Write
- QuantityRequired
- Item Number
- GTIN
- Item Name
Action
Write
- Email AddressRequired
Action
Search
- Item NumberRequired
Action
Search
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write

About AmeriCommerce

AmeriCommerce is a full-featured eCommerce platform.

Related categories

eCommerce

About Google Sheets

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

Learn more Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

PRODUCTS

CAPABILITIES

By team

AmeriCommerce + Google Sheets

Add new AmeriCommerce orders to Google Sheets rows

New Customer

New Product

New Valid Order

Order Updated

Customer Email Updated

Change Order Status

Order Id

Order Number

Order Date

Customer Email

Order Status

Create or Update Order

Customer Email

Order Status

Order Date

Order Number

Customer First Name

Customer Last Name

Customer Phone

Customer Type

Subtotal

Tax Total

Shipping Total

Discount Total

Handling Total

Additional Fees

Grand Total

Cost Total

Shipping Address Line 1

Shipping Address Line 2

Shipping Address City

Shipping Address State

Shipping Address Postal Code

Shipping Address Country

Shipping Address First Name

Shipping Address Last Name

Shipping Address Company

Shipping Address Phone

Shipping Address Alt Phone

Billing Address Line 1

Billing Address Line 2

Billing Address City

Billing Address State

Billing Address Postal Code

Billing Address Country

Billing Address First Name

Billing Address Last Name

Billing Address Company

Billing Address Phone

Billing Address Alt Phone

Adcode

Referrer

Coupon Code

Source

Source Group

Search Phrase

Is Gift?

Gift Message

Admin Comments

Public Comments

Shipping Method

Manufacturer Invoice Number

Manufacturer Invoice Amount

Manufacturer Invoice Paid?

Exported To Accounting System?

Item Number

Item Name

Price

Cost

Quantity

Weight

Weight Units

Height

Length

Width