This is driving me nuts for weeks. I need some help with make.com and Shopify and Airtable

Shopify Discussion

Topic summary

A user struggled for weeks to build a workflow connecting Shopify, Make.com, and Airtable for back-in-stock notifications. They moved away from Klaviyo due to cost and functionality limitations.

The Problem:

  • Capturing customer emails via webhook when products are out of stock
  • Storing data in Airtable including visitor URLs
  • Fetching product variant information to notify customers when items restock
  • Cloudflare CDN blocking data extraction attempts through Make.com and Zapier
  • Make.com missing record IDs when syncing between Shopify and Airtable

The Solution:

  • Working with a developer (Mohammed from debesis.nl), they resolved the issue by manually adding the missing record ID once
  • This allowed Make.com to “learn” and use the value in subsequent workflow steps

Alternative Approach:

  • Another participant suggested using Syncbase to sync Shopify and Airtable without custom Make.com triggers or ID workarounds

One user asked for clarification on the record ID solution, but received no response. The discussion appears resolved for the original poster.

Summarized with AI on October 24. AI used: claude-sonnet-4-5-20250929.
1

Hey everybody,

I’ve recorded a video as it’s easier to explain what I like to achieve.

https://app.screencast.com/kocOzlTSoQ5zH

Our Shopify website gives our clients the option to leave their email addresses behind when a product isn’t in stock. We used the integration with Klaviyo in the past, but that was too expensive and did not exactly do what we needed to achieve in a later phase with the data.

We store via a webhook the data of the client in an airtable so we can check if the person is a client or not etc, etc. I have read on the forum that when you create a new product and assign a productID to it, this is different from the ProductID on the front end of the website.

In my airtable, I capture the URL the client is visiting, and all this information is kept in one overview.
I like to create an mechanism, where I can fetch the variant of the product in such way, I can inform the client, when it’s ready again.

I’ve tested all the templates, and even run a python script to extract all the information, but it seems that the Cloudflare CDN is blocking to search the information via Make.com or Zapier.

Your help is more than welcome, as it’s driving me nuts.

2

Hi @SuperBra

First for this you just need custom code which will give you option to fill form when product is out of stock.

Now your issue if the form is Shopify contact form or klaviyo allow to add fields.

Then I can modify the code a bit where you will get the selected variant id.

Let me know your thoughts…

3

Thanks to Mohammed of https://www.debesis.nl, we cracked this solution. And, as always, the solution is hidden in front of you. :S

The issue that this flow needed to be fixed is that when fetching information via Make to shopify and Airtable, Make is missing an ID of the record. By adding this once manually, you can “learn” to use the value, which results in the next step of the flow.

4

How do you solve id of the record?

5

just in case it helps, we plugged our shop to airtable using Syncbase, so you don’t need to build any make triggers or record id retrieval hacks. all our orders, customers etc are in sync on both platform now