rival-black•15mo ago
AirTable User Validation
This would seem an easy use case, but all the GPT engines can't solve this. I am having the user enter email in VF chatbot. There is an API call to a user table in an Airtable base. If email is present then they are registered and it goes down one path. If it cannot find an email then it kicks off a registration process. Claude had me write up a custom code block after the API block. But the script can't set an internal variable correctly - ChatGPT, Gemini, and Perplexity couldn't resolve either. Anyone try this before? thanks
5 Replies
To integrate Voiceflow with Airtable, follow these steps:
Step 1: Set Up Airtable
1. Create an Airtable account if you don't have one.
2. Create a table with the necessary columns.
Step 2: Add an API Block in Voiceflow
1. Add an API block to your Voiceflow project.
2. Set the method to GET to retrieve data from Airtable or POST to add data to Airtable.
Step 3: Configure the API Block
1. Get your Airtable API key from your Airtable account.
2. Set the URL in the API block to fetch the data from Airtable.
3. Add headers:
- Key:
Authorization
- Value: Bearer YOUR_API_KEY
Step 4: Capture the Response
1. Map the response to a variable:
- In the API block, under "Capture Response", map the response to a variable, e.g., Task.
Step 5: Add More Blocks to Your Assistant
1. Add more blocks to your assistant to further interact with the data from Airtable.
Troubleshooting
- Ensure your Airtable API key and base ID are correct.
- Verify the URL and headers in the API block.
For more detailed steps, you can refer to our Airtable Integration Documentation.rival-blackOP•15mo ago
just fyi link is broken
I have a similar flow in one of my agents but it’s for login purposes.
Based on your response from your GET API call you can just use a IF logic step to help determine the path
rival-blackOP•15mo ago
thanks for the suggestion. I think the problem is the way VF is handling variable definition. It doesn't seem to like it when i bring something in from Airtable as a new variable. I was hoping to get the attention of some form of tech support but alas...
There's plenty of us that can help ....
What issue are you having when you capture the response? are you able to record a quick loom video to show your problem?
From what you described you just need to use filterByForumla to determine if an email exists, if it does then direct the flow on one path and if the response is empty take a different path.