But still, I WISH we could have some simple things like “date modified”, field/table/base metadata, and filters by related record VALUE (not just related record ID). And to be fair, they’ve owned this from the start (I’m actually rather impressed by the clarity of their vision/roadmap). I totally get it as their business model is clearly focused on monetizing the front-end UI and features (blocks, colors, etc). The biggest gotcha is ensuring that if your request (or requests in the case of batches) returns anything OTHER than a 200 HTTP response code, you cleanly exit rather than syncing an empty response (this has happened to me and it is unfortunate).Īirtable continues to double-down on NOT being a proper backend for data-they are fully invested in their front-end and have let all of us API users nibble on the meager crumbs they throw our way. The only way I’ve managed (sane) syncs is by:įetching all records from a table (usually in batches), creating a hash using specific fields, comparing that hash to a cached value associate with that record ID, and only THEN can my script tell if that record has changed. And if you happen to upgrade to QuickBooks Online, it’s not much better but I suspect some like CherryYang2 might be able to help. Zapier doesn’t have a “trigger” for Airtable updates (just new records) and the API (as you know) doesn’t expose date modified (only date created). The best you can do in this case is to manually copy and paste or craft a Goldbergian-like menagerie of reports emailed to Zapier and uploaded into Airtable. With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Email by Zapier, Mailjet, and Airtable. 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.To the best of my knowledge, NOTHING can track changes/updates to records other than Airtable itself. Do even more with Email by Zapier + Mailjet + Airtable.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.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.With Zapier, you can integrate everything from basic data entry to end-to-end processes. Once you’ve tested and everything looks good, turn on your Zap. Connect Wix and Airtable to integrate crucial parts of your business.Test the action to ensure the data gets sent to Airtable correctly.With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Email by Zapier, Gmail, and Airtable. For example, link the ‘Name’ from Webflow to the ‘Customer Name’ in Airtable. Do even more with Email by Zapier + Gmail + Airtable. Here are some of the business-critical workflows that people automate with Zapier. Connect Airtable and Translate by Zapier to integrate crucial parts of your business. Map the Webflow order data fields to the corresponding Airtable fields. Connect Airtable and Lawmatics to integrate crucial parts of your business.Then select the base and table where you want to send the order data. Test the connection to ensure it’s fetching the data. Connect your Webflow account and select the e-commerce site you’re working on.With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Google Sheets, Schedule by Zapier, and Airtable. Log into your Zapier account or create one if you don’t have it. Do even more with Google Sheets + Schedule by Zapier + Airtable.
Common fields include Order ID, Customer Name, Product Purchased, Quantity, Price, Total Amount, Address, Email, Phone Number, etc.
Test a transaction to make sure the order data is being recorded.
Ensure your Webflow e-commerce store is fully set up with products and checkout functionality.Hey Sean! Here’s a general outline to set this up: