I am working on lead tracking, using a GHL form to pass the data to Make via a webhook, and then adding it to Airtable. I’m using free subscription Airtable.
What is the problem?
I’m using two scenarios: one is getting data from GHL, and the other is passing that data to Airtable. My modules are working, but the data in Airtable shows up as blank or empty columns. I’m a beginner in automation and don’t understand much. Thanks for all the help!
You’re querying Airtable with the phone number to check if the record already exists, right? If it doesn’t, you insert the new values.
However, it looks like you’re mapping the values from the wrong module to Create a record. You’re using 12.Airtable. If the record does NOT exist, they’ll be empty. You should map the Webhook’s results.
The (new) data you need is inside the payload of your webhook: {"name":"FMR", "email"...}. Just ad a Parse JSON module and map that string to it and you’ll have access to the individual values.
Actually I didn’t understand why you need 2 scenarios for this.
What is your goal?
What is the problem?
What have you tried so far?
Screenshots: scenario setup, module configuration, errors
