Airtable is a powerful database and it’s your source of truth. But syncing it to Webflow CMS is not easy.
Many people do it using Zapier or Integromat, but it gets complicated very quickly and you spend hours on tedious tasks that are time-consuming and not fun.
Wouldn’t you rather spend your time designing in Webflow?
@JudoHacker This post sent my hopes flying to the moon when I found it late last night. I’ve been struggling for awhile to find a “no or low-code” website builder to bring in product data from an external API (GraphQL API) so we can create our own shopping experience on the front end. After viewing the video, and successfully pulling my data into Airtable last night, this looks hopeful. But, before I expend too much time down this track was hoping you might give advice from your experience on a few things:
Assuming I can bring the data into the CMS as you do in your video (which I don’t foresee as an issue), my plan is to pay for an Airtable plan that allows the data to update nearly every minute. I assume this shouldn’t present any particular challenge to this setup?
I’m struggling to understand the “shopping” piece of the puzzle here using this solution. The GraphQL API I’ll be using obviously has mutation features to update a cart and checkout (the actual checkout portion itself is handled by our ecommerce provider and doesn’t occur on our front end website) but we’ll need to send a payload to their API somehow with the cart information to do that checkout that occurs on their webpage. That piece is confounding me. Any thoughts or suggestions?
Is this the same challenge that @audiumspeakers ran in to? Any and all threads of thoughts and investigations greatly appreciated
@JudoHacker Thanks for the info. Unfortunately, I’m definitely married to our ecommerce provider because our point of sale system only integrates with certain providers – in an ideal world I think we’d try to build our own integration with our POS’s API so we didn’t have the ecommece provider “middle step” but we’re a small company and don’t have those kind of resources. This GraphQL API seems like the best, most cost effective way for us to gain some sense of being able to build our own shopping experience, even if at the end of the day the actual processing of transactions, etc. is done off our site. Someone else had mentioned Foxy.io so thanks for sharing. It’s unclear to me if they would do “one-off” type consulting help but I’ll check it out.
@JudoHacker Does PowerImporter sync both ways? Changes in Airtable will be reflected on the Webflow site. But if an Editor makes changes directly via the Webflow Editor, will this then sync to Airtable (incl. Image changes)?
