Hello, I want to know if Zapier can gather our Amazon store customer information and integrations with Hubspot. Which means can Zapier have our customer information or not? We want to make them all together in HubSpot CRM for marketing, so we need to know if Zapier can get their information, thank you so much.
Will I have the customer information in Google Sheets?
Hi
Below you can toggle the Show Content link and see a representative sample of data (I removed the actual values) from the New Order trigger of Amazon Seller Central. In your real-world usage, you may see more than this or even less. The only way to see for sure whether you’ll get what you need is to test it out in a Zap :)
{
"AmazonOrderId": "114-0251368-2259476",
"BuyerEmail": "8hh31v74hhk3vrv@marketplace.amazon.com",
"DefaultShipFromLocationAddress": {
"AddressLine1": "1500 N 7th Ave",
"City": "Bozerman",
"CountryCode": "US",
"Name": "Maryna Shults",
"Phone": "+1 415-419-8616 ext. 40005",
"PostalCode": "59715",
"StateOrRegion": "MT",
"isAddressSharingConfidential": "false"
},
"EarliestDeliveryDate": "2021-01-12T08:00:00Z",
"EarliestShipDate": "2021-01-08T08:00:00Z",
"FulfillmentChannel": "MFN",
"IsBusinessOrder": "false",
"IsGlobalExpressEnabled": "false",
"IsISPU": "false",
"IsPremiumOrder": "false",
"IsPrime": "false",
"IsReplacementOrder": "false",
"IsSoldByAB": "false",
"LastUpdateDate": "2021-01-07T23:27:37.770Z",
"LatestDeliveryDate": "2021-01-15T07:59:59Z",
"LatestShipDate": "2021-01-12T07:59:59Z",
"MarketplaceId": "ATVPDKIKX0DER",
"NumberOfItemsShipped": "0",
"NumberOfItemsUnshipped": "1",
"OrderItems": [
{
"OrderItem": {
"ASIN": "B00BQZZSUA",
"ConditionId": "New",
"ConditionSubtypeId": "New",
"IsGift": "false",
"IsTransparency": "false",
"ItemPrice": {
"Amount": "71.93",
"CurrencyCode": "USD"
},
"ItemTax": {
"Amount": "0.00",
"CurrencyCode": "USD"
},
"OrderItemId": "13848476466122",
"ProductInfo": {
"NumberOfItems": "1"
},
"PromotionDiscount": {
"Amount": "0.00",
"CurrencyCode": "USD"
},
"PromotionDiscountTax": {
"Amount": "0.00",
"CurrencyCode": "USD"
},
"QuantityOrdered": "1",
"QuantityShipped": "0",
"SellerSKU": "7P-70PS-Z2AK",
"Title": "White Manual Pull Down Projection Screen 100\" Diagonal 16:9 Wide View Wall Ceiling Mount Steel Case for Home Movie Theater Office Video Presentation Projector"
}
}
],
"OrderStatus": "Unshipped",
"OrderTotal": {
"Amount": "71.93",
"CurrencyCode": "USD"
},
"OrderType": "StandardOrder",
"PaymentMethod": "Other",
"PaymentMethodDetails": {
"PaymentMethodDetail": "Standard"
},
"PurchaseDate": "2021-01-07T23:02:01.638Z",
"SalesChannel": "Amazon.com",
"ShipServiceLevel": "Std US D2D Dom",
"ShipmentServiceLevelCategory": "Standard",
"ShippedByAmazonTFM": "false",
"ShippingAddress": {
"City": "HUGOTON",
"CountryCode": "US",
"PostalCode": "67951-3063",
"StateOrRegion": "KS",
"isAddressSharingConfidential": "false"
},
"id": "114-0251368-2259476"
}
As for Google Sheets, you can definitely use one the available actions in order to store data there:

Hi
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.