E-commerce new order automation, Zapier to Airtable

Design help Webflow integrations
1

Has anyone built an e-commerce store and used any automation integrations to send new order data to a third-party application?

I am working on a project for a client and I would like to automate the new order data consisting of purchase and delivery details to be transferred to an app like Airtable either using Zapier, something similar, or Webflow’s own logic.

Any help or advice would be greatly appreciated!

2

I haven’t done that with Ecommerce specifically, but I have done a lot of that with the CMS.

I use Webflow Webhooks for this.

I like to use a free Make (Integromat) account versus Zapier.

Airtable also has endpoints that you can send Webhooks too if you want to cut out the middleman (Make).

Here is a tutorial using Airtable with Webhooks. My example uses a form submission but just swap that out with Webflow Webhooks.

I have a free tool , https://webhookcreator.com, that makes setting up Webflow Webhooks a snap as well.

Screen Shot 2023-08-09 at 9.32.00 PM
Screen Shot 2023-08-09 at 9.32.00 PM2744×1880 290 KB

The destination url is your Make or Airtable endpoint.

Screen Shot 2023-08-09 at 9.32.08 PM
Screen Shot 2023-08-09 at 9.32.08 PM2744×1880 318 KB

You can setup any other Webflow Webhook too.

This should get you everything you need. Dig around on my blog for a ton more screencasts and tutorials on all of this stuff.

Good luck!

3

Thanks for all the resources Chris,

I’ll have a look into this and see if I can make it work.

4

Hey Sean! Here’s a general outline to set this up:

  1. Webflow E-commerce Setup
  • Ensure your Webflow e-commerce store is fully set up with products and checkout functionality.
  • Test a transaction to make sure the order data is being recorded.
  1. Airtable Setup
  • Create a base in Airtable with fields that correspond to the data points you want to capture from Webflow. Common fields include Order ID, Customer Name, Product Purchased, Quantity, Price, Total Amount, Address, Email, Phone Number, etc.
  1. Zapier Setup
  • Log into your Zapier account or create one if you don’t have it.
  • Click on Make a Zap.
  • For the Trigger:
    1. Search for Webflow and select it.
    2. Choose the New Order trigger event.
    3. Connect your Webflow account and select the e-commerce site you’re working on. Test the connection to ensure it’s fetching the data.
  • For the Action:
    1. Search for Airtable and select it.
    2. Choose the Create Record action event.
    3. Connect your Airtable account. Then select the base and table where you want to send the order data.
    4. Map the Webflow order data fields to the corresponding Airtable fields. For example, link the ‘Name’ from Webflow to the ‘Customer Name’ in Airtable.
    5. Test the action to ensure the data gets sent to Airtable correctly.
  1. Finish and Turn on the Zap
  • Once you’ve tested and everything looks good, turn on your Zap.
  • Now, every time a new order is placed on your Webflow e-commerce store, the order data will automatically be sent to your Airtable base.
  1. Additional Considerations:
  • Consider adding filters or other actions in Zapier if you want to conditionally process the data or perform additional actions like sending emails, notifications, etc.
  • Make sure to monitor your Zap periodically, especially in the early stages, to ensure that it’s working correctly and that there are no hiccups.

Let me know if this helps!

5

Hi! I work at Relay.app (a flexible alternative to Zapier), and we’ve supported several customers with use cases like this. Feel free to email me at jacob@relay.app and I can help you set it up