Store New Webflow E-Commerce Customers in Airtable

This app lets you store customer information in Airtable when your Webflow E-Commerce website gets new orders. That way you'll be able to take a closer look at your customers, and apply different filters or group/sort your customers under different criterias within Airtable.

To go along with this app, we've setup an Airtable base with fields matching Webflow customers. You can clone the Airtable base by clicking here

How It Works

This app listens to the ecomm_new_order event coming from your linked Webflow e-commerce site. When that event occurs it triggers the functions/events/webflow/ecomm_new_order.js endpoint. That endpoint then calls the airtable.query.insert endpoint to send the customer's information that was recieved with the order to Airtable and store it in a new Record:

await lib.airtable.query['@0.5.4'].insert({
  table: `Customers`,
  fieldsets: [
    {
      'Email': event.customerInfo.email,
      'Full Name': event.customerInfo.fullName,
      'Order ID': event.orderId,
      'Order Accepted On': event.acceptedOn,
      'Customer Paid': (parseFloat((event.customerPaid.value/100).toFixed(2))) || 0,
      'Billing Address': formatAddress(event.billingAddress),
      'Shipping Address': formatAddress(event.shippingAddress),
      'Stripe Customer ID': event.stripeDetails.customerId,
      'Paypal Payer ID': event.paypalDetails.payerId
    }
  ],
  typecast: false
});

Installing the App

Getting started is simple! First, clone the Airtable base by clicking here. Then click on the Open in Autocode button below, change the name of the project if you'd like, then click on Fork Source to get your very own version of this app.

Link your Webflow and Airtable Accounts

After forking the app, you'll be brought to the Autocode Editor. You'll notice a bouncing red button on the bottom right corner, click on it and a modal will pop up.

Link the Webflow site you want to listen to new orders coming in from. Next, link the Airtable base you just cloned. For each account, click on the Link button, then Link New Resource and it will walk you though the steps to link each account.

Deploy your App

Once you've linked your accounts, click on the Deploy button in the bottom left corner of the editor and you're all set! You should start seeing customer information in your Airtable base when new orders are created.

That's It!

Autocode will automatically handle all authentication and event parsing for you. All you need to do is install this app and you're good to go! You can even customize it further from the Autocode editor.

For support, please visit the Autocode Community Slack channel by clicking Community > Slack in the top nav or by following @AutocodeHQ on Twitter.