From-To Search with Google Locations To Find the exact route in Google Sheets

[Stefan_Golijanin]

Hi guys,

I’m looking for some opinions and solutions to my problem. I built a webhook that is connected to the Webflow website. I’m working on a search on the website for Airport Transfer. I have a search form “from location” and “to location”, and Google Maps is integrated into those searches.
In Google Sheets, I have exact routes also from-to and prices, with postcodes in column A, for example, SW10, E11, etc. The other column is Airport postcodes or names column B. And inversely, from the airport to home.

So I tried to filter google sheets with contains, to split locations and find exact matches. But for example, if I search SW10 and I have contains method, it will show me W10 as the answer. The latest problem was that I tried to split the location and word by word to see is it matched and to ask if the airport location included the airport from the sheet. But then there was a problem, that it found 4 answers and one was right. The wrong answers were, for example, found an airport like an exact match and the location contains the postcode from the sheet.
So I could try to write every possible way, and I will work nicely but I think that there is easier way and I want to see if anyone could help me.

Thank you.

[samliew]

Welcome to the Make community!

To allow others to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

• Method 1: Type code block manually

  Add three backticks ``` before and after the content/bundle, like this:

  ```
  <sup>content goes here</sup>
  ```

• Method 2. Highlight and click the format button in the editor

  

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

[Stefan_Golijanin]

blueprint.json (47.4 KB)

Here is the blueprint, and I will provide some screenshots, to explain easier.
So from the start to the end, firstly I have a webhook that has the method post, he is posting some data that I need to match with the table and then return the answer.

So then this goes through parse Json and then I set the variable, where I want to split both locations and later in the filter to match them with table data. I don’t have any errors everything is working perfectly just I set a bad filter that is providing more answers and I need one, I will explain later. So after setting the variable, that goes to the table and Google Sheets search rows is getting the data from every row. This is the output of sheets, I provide just one because it has 7000 but you can see the logic of how the sheet looks, just postcode, name of airport, prices, and parking.

Some idea what I was thinking is maybe to search by coordinates, but the postcodes in the sheets are just areas in London, not the exact addresses of houses. And If someone writes in search E11 1NR, which is more precise, I don’t think that the coordinates will match.

So after that data from sheets goes through a filter, I use this filter because the filter in sheets has its limitations. I tried with Search Rows Advanced, but the output of it is nothing. So the filter looks like this:

So my logic was that the filter goes and searches for matches of address words, when I split them, like E11 and E11 in sheets, and to see if the location of the airport contains the name of the airport in sheets. It works well for some examples, but in some, the filter returns me somewhere I’m looking for a match he is returning Airport, and where I look does it contain, it is finding addresses, for example, NW10 postcode he returns me W10. He is doing that because I have the inverse filter from airport to postcode, but I didn’t see it coming. And then I get 4 answers.

So if anyone has experience with those coordinates, or has some good ides, please help. I appreciate every help. Thanks