Lookup nearest location by zip code through inbound call to cloud VoIP solution
Budget: $30 – $250 USD
I have an existing cloud-based VoIP solution with multiple capabilities. I can share more details about the voip solution later, but the capabilities within this solution include the ability to add JavaScript into call flows and perform HttpCalls with GET, POST, PUT, PATCH, and DELETE methods. I can provide access to the GUI where everything can be configured.
I have an existing inbound voice call flow. I'm looking for someone to program the widgets in the editor tool with the required scripts and HttpCalls to perform (3) primary actions:
1. A caller can enter a 5-digit zip code and be prompted with a list of the closest locations which are entries/rows on a Google Sheet. The locations provided to the caller are based on the proximity from the location in the Google Sheet to the ZIP code provided. The IVR solution should perform a query into a the Google Sheet with location information and make an HttpCall to a Google Maps API. If there is an exact match, the location is provided. If there is no match, the next closest location will be provided. Up to (3) locations will be provided in the voice menu. The caller will confirm their choice of the location in the call flow.
2. After the preferred location is confirmed, the VoIP solution will offer an SMS to the originating caller ID with the street address so the caller can navigate to the location through their preferred mapping app.
3. Lastly, the call flow will offer to transfer the caller directly to the location's phone number also stored in the Google Sheet. The workflow will route to that location and end.
I have (3) 3rd-party integrations.
1) Google Sheets - this can be replaced with something else (e.g. restdb.io)
2) Google Maps API - I'd prefer to stay with Google, but if it can't be accomplished I can use something else (e.g. https://www.zipcodeapi.com)
3) Textbelt.com - this is an outbound SMS service that I have used with my VoIP solution. My current VoIP solution does not have the ability to send outbound SMS
I have an existing inbound voice call flow. I'm looking for someone to program the widgets in the editor tool with the required scripts and HttpCalls to perform (3) primary actions:
1. A caller can enter a 5-digit zip code and be prompted with a list of the closest locations which are entries/rows on a Google Sheet. The locations provided to the caller are based on the proximity from the location in the Google Sheet to the ZIP code provided. The IVR solution should perform a query into a the Google Sheet with location information and make an HttpCall to a Google Maps API. If there is an exact match, the location is provided. If there is no match, the next closest location will be provided. Up to (3) locations will be provided in the voice menu. The caller will confirm their choice of the location in the call flow.
2. After the preferred location is confirmed, the VoIP solution will offer an SMS to the originating caller ID with the street address so the caller can navigate to the location through their preferred mapping app.
3. Lastly, the call flow will offer to transfer the caller directly to the location's phone number also stored in the Google Sheet. The workflow will route to that location and end.
I have (3) 3rd-party integrations.
1) Google Sheets - this can be replaced with something else (e.g. restdb.io)
2) Google Maps API - I'd prefer to stay with Google, but if it can't be accomplished I can use something else (e.g. https://www.zipcodeapi.com)
3) Textbelt.com - this is an outbound SMS service that I have used with my VoIP solution. My current VoIP solution does not have the ability to send outbound SMS