Airtable or Google Sheets for A zip code lookup

#BlandAI, google-sheets, airtable

*My goal is to send a lookup request from Bland AI (conversational) to a zip code table (186 zip codes) so I can determine which office services the leads zip code. Can I do this with Bland ->Make-> Google Sheets or do I need to put my zip code table in airtable or something else? I am open to suggestions.

  • I am new to Make so I am looking for guidance. We have tried all sorts of table configuration with in the AI, and have determined that to get a consistent correct response, we need to sent a subprocess out to get the answer and returned while the call is still going on. Ultimately, we will need to do the same thing with a pricing table.

Thanks for any help in advance.

Welcome to the Make community!

You can try the Google Maps “Search For Places” module.

Screenshot_2024-02-29_170206

2 Likes

Hello @Alan_R_Thomas :wave:

I see that you opened a ticket with us and that the support team investigated this and gave you the following advice. I’m sharing it here for the benefit of the community. :arrow_down:

Make Support response:

The Bland AI app was contributed by community users and is developed, supported, and maintained by the community. Here’s the official page for it - https://www.make.com/en/integrations/bland-ai

First, kindly install the Bland AI app via our Partners’ link on the page provided above.

Regarding your inquiry, you may want to use functions like Switch() or If().

1 Like