Sync table and pipelines

Hello,

I have a sync table to salesforce, and I have another table called projects.

I've created a pipeline when the trigger is record added to SF table, then it must create a record into projects table.

I tested this in sandbox and it works, but I manually created the record in SF tables (trying to mimic the behavior in live). So, I created another pipeline for "live", but this doesn't trigger. Now I know that sync table doesn't works the same as a normal table, so I need to change the logic of my trigger.

SF table refresh the data once every day. I was thinking in add a "schedule", and search when "Creation Date" is the date of "today", like:

If CreationDate = today AND flag = unchecked
        Create record in projects
        flag = Check
End if

But I don't know how accurate this logic is. I want to create a record in project with the new sync data and not with old values.

Any suggestion will be appreciated :)