Filter problem between dataset items and Google sheets

[Eastern_Ranges_Bowls]

What is your goal?

I want to collect information (posts scraped with Apify from Facebook) from bundles within a date range of 28 days

What is the problem?

I’ve used parse , now etc to no avail. I can use the exact timeline 1786320000000 for Aug 10 which works fine. I want the preset of 28 days

What have you tried so far?

I’ve tried using format Date
15.timestamp
≥
parseNumber(formatDate(addDays(now;-28);“x”))

Create public scenario page

https://eu1.make.com/2280997/scenarios/6841865/logs/df7fdf498757488190d6911c5e015c92?showCheckRuns=true&showChangeLog=true

Screenshots: scenario setup, module configuration, errors

[Stoyan_Vatov]

Hey there,

that’s not how you share a scenario. We don’t have access to your workspace so we can’t see it.

Can you share some screenshots of what that filter looks like and are you using the time or datetime options in it?

[Eastern_Ranges_Bowls]

What is your goal?

I want to collect information (posts scraped with Apify from Facebook) from bundles within a date range of 28 days

What is the problem?

I’ve used parse , now etc to no avail. I can use the exact timeline 1786320000000 for Aug 10 which works fine. I want the preset of 28 days

What have you tried so far?

I’ve tried using format Date
15.timestamp
≥
parseNumber(formatDate(addDays(now;-28);“x”))

Create public scenario page

Screenshots: scenario setup, module configuration, errors

[Eastern_Ranges_Bowls]

[Eastern_Ranges_Bowls]

Integration Google Sheets - Make.com Automation Scenario

[Stoyan_Vatov]

Yeah that’s never going to work.

Everything inside is just text strings you copied from somewhere and not the actual pills you need. Open the menus and select the corresponding items instead.

Also, from the same menu, hover over timestamp to see if its date type variable, number type variable or a string. If it’s text, you need to use parseNumber on it as well. If it’s date, then you need to loose the parseNumber at the bottom and change the operator to datetime and not numeric.

[Eastern_Ranges_Bowls]

time stamp is text, have changed as screenshot

[Stoyan_Vatov]

You need to map the actual timestamp value as well.

[Eastern_Ranges_Bowls]

searched timestamp , a green variable. How do I map 2419200000000

[samliew]

searched timestamp , a green variable. How do I map 2419200000000

Click on the “green variable” to insert it into the field. That’s all.

I recommend going through the Make Academy if you haven’t yet.

• Help Centre | Tutorials – Make’s “manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth
• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

How-Tos

• Error Handlers in Make - YouTube playlist
• Aggregate an array for mapping complex fields
• Getting started with OpenAI - How to setup and use OpenAI in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy - tutorial on how to use Webhooks