Trying to make a simple make from a webhook to a spreadsheet with date range

Beginner Questions
,
1

:bullseye: What is your goal?

Hi all,

I’m trying to create a flow from a webhook to a spreadsheet with a date range but it keeps failing. Here’s the link: Integration Webhooks, Google Sheets - Make.com Automation Scenario

Basically, I want an Inbound message from Clicksend to get push to the webhook but it needs to be only from 9am to 5pm and then update a row in google sheet. Any advise?

:test_tube: What have you tried so far?

I tried creating the webhook to send the data to the sheet which works. But having issues with the date range. Here’s is how I created the filter:

Condition: {{>=“formatDate(1.timestamp; ““H””)”}}
Text Operators = Equals To: 9
AND
Condition: {{>=“formatDate(1.timestamp; ““H””)”}}
Text Operators = Equals To: 17

Logs are showing:

Cannot initialize the scenario because of the reason ‘Scenario validation failed - 2 problem(s) found.’

  • Invalid IML for filter ‘0-0’ on link ‘Date Range’: Operator on beginning of an expression.
  • Invalid IML for filter ‘0-1’ on link ‘Date Range’: Operator on beginning of an expression.
    Scenario initialization failed with an error.

Shareable link: Integration Webhooks, Google Sheets - Make.com Automation Scenario

Any advise?

3

Hey Mario,

you mean you want to ignore webhooks received outside the 9-5 window and process only the ones between 9 and 5? Or you want to receive webhooks only between 9 and 5 and at 9 you get to process the queue that came between 5 and 9?