Make.com Google Sheets Filter: Time Condition Not Returning Results

[CityGames]

Hello Community,
I’m facing an issue with a Google Sheets filter in Make.com and would appreciate your help.

My Setup:

• I extract a time from a booking request via email (using a parser) and store it in JSON format.
• The extracted time is formatted using a formatter to HH:mm:ss.
• In Google Sheets, the relevant columns are formatted as follows:
  • Column D: Start Time (e.g., 10:00:00)
  • Column E: End Time (e.g., 15:30:00)
  • Both columns are set to Time format.
• I set up a filter in Make.com with the following conditions:
  • Column D (Start Time) → “Later than or equal to” my formatted desired time.
  • Column E (End Time) → “Earlier than or equal to” my formatted desired time.

The Issue:

• Even though my desired time is 11:00:00, and the available time range in Google Sheets is 10:00:00 to 15:30:00, the filter returns no bundles.
• If I remove the time filters, I get results, meaning the previous filters are working correctly.
• I have tried multiple settings, but the issue persists.

Questions for the Community:

• Has anyone encountered a similar issue?
• Could this be related to formatting or how Make.com internally compares times?
• Is there a better way to reliably filter times?

Screenshots:

I have attached screenshots to illustrate the setup and the issue.

Thanks for your help!

[kudracha]

Hi @CityGames, So it’s the filter. Can you maybe remove conditions one by one and rule out which one doesn’t work ? multiple AND conditions might be rigid.

[CityGames]

“Thanks for your help, but even if I remove all filters and only keep the start filter (earlier or equal to), the filter doesn’t let anything through. Any other ideas?”

[CityGames]

[kudracha]

@CityGames, Instead of filtering in ‘search rows’ module, if your scenario allows - put a filter just after the ‘search rows’ module. This way you can also parseDate() and formatDate() input from Sheets when comparing in the filter, ensuring that Sheet provides a valid date fromat. I don’t have doubt in your declared variable.

[CityGames]

Hmmm sorry, it is still not working. I removed also any other filters from sheets!

[Msquare_Automation]

Hi @CityGames

Google sheet always return text data and you are using date operators. Did you parse the time to date time???

Regards
Msquare Automation - Platinum partner of Make
@Msquare_Automation

[CityGames]

Yes i did! See the following pictures:

I would even be willing to pay for quick help with this topic. I just can’t get any further with this. I could offer to provide my account so that someone can take a look at it.

[Msquare_Automation]

Hi @CityGames

You should use parseDate() but not formatDate(). Both variables should be date type. However, it seems there are more things to correct. Could you please share the blueprint of the scenario and create a loom explaining what are you trying to do and the problem.

Regards
Msquare Automation - Platinum partner of Make
@Msquare_Automation

[CityGames]

OF Course! Thank you!!!

Here:

Question: How to Compare a Parsed Time from an Email with a Time Range in Google Sheets?

The Workflow:

1. Email Parsing

• Emails are received and processed through a parser.
• The parser extracts only a time value without a date.
• The extracted time is already converted into a proper time format before further processing.

2. Google Sheets Setup

• The sheet contains a Start Time and End Time to define the valid time range.
• The formatting in Sheets is already set to time format to ensure correct processing.
• The screenshots provided confirm that both the parsed time and the sheet settings are correctly formatted as time values.

3. Filtering Logic in Make.com

• The extracted time from the email needs to be checked against the time range in Sheets.
• The filter should verify if the parsed time falls between the Start Time and End Time.

Challenges & My Main Question:

Even though both the parsed time and the Google Sheets settings are already formatted correctly as time values, I’m still facing issues with filtering.

• Do I still need to pre-process the time data in Google Sheets before filtering in Make.com?
• If so, at which step should I apply this conversion to ensure correct filtering?

I have already tested different approaches but haven’t achieved the expected result. The screenshots I provided show the current setup, including the time format settings.

Could someone provide a clear step-by-step workflow for handling this situation correctly?

Thanks in advance for your help!

[CityGames]

This ist the beginning Email

[CityGames]

Unfortunately, I still haven’t been able to solve my problem. Can I give my account to someone here so they can quickly help me? It’s really urgent, and I’ve been stuck on the same issue for four days. I would also have no problem paying for an hour of support!

[CityGames]

Or we can do a video call together?

[Benjamin_from_Make]

Hi @CityGames,

Thanks so much for such detailed and clear explanations!

I think you have multiple issues with the parseDate and with the filter. I did a small test; can you have a look and try to mimic the way I wrote my filter? Hopefully if can help solve your issue.

Note that I used “Time Operators”

Let me know, hopefully it will work for you.

Kind regards,

Benjamin

[CityGames]

Hey Benjamin,

Thank you very very much!!!

Yes, With your help i solved my Problem!

And my Szenario is Running now! Perfect Job!

Your pic‘s were very helpfull for me!

THX!

[Benjamin_from_Make]

@CityGames I’m super happy it worked!

Kind regards

Benjamin