How to sync Google Sheets data with a Notion table using Zapier

Hi ​@adamblackmortgage 

Try these Zap steps:

1. Trigger: GSheets - New or Updated Row
2. Action: Filter
   1. Conditions
      1. Check Column D = Preapproved
         AND
      2. Check Column XXX does not exist
   2. Help: https://zapier.com/apps/filter/integrations#help
3. Action: Notion - Create Database Item
4. Action: GSheets - Update Row
   1. Add a Column XXX to indicate you’ve already processed this row by logging the created Notion Item ID

​@Troy Tessalone 

1. Thanks for the help on the Zap. I'm still not having any luck and I'm sure it's user error. I follow you until I get to Filter in Step 2. I get the first Only Continue if but when you say  “Check Column XXX does not exist” I’m not sure how to proceed. This is a snipit of where I am

​@adamblackmortgage 

Check the Filter step warning.

You have the same variable checking against itself.

Thus, the condition will always evaluate to true.

For the bottom field of the condition, enter a static value.

Thanks again for trying to help but you’re talking over my head. i don’t know what you mean “For the bottom field of the condition, enter a static value.”

​@adamblackmortgage 

In the screenshot below there are 3 fields that make up a Filter condition...

Left/Top: leave this as the dynamic variable for “Status”

Middle: operator (e.g. contains)

Bottom/Right: set this as a static value that you manually type in (e.g. Pre-Approved)

Hey ​@adamblackmortgage, just checking in! 👋 Did Troy’s latest reply help you to get the filter setup sorted?

Let us know how it went - happy to lend a hand if you’re still stuck at all! 🙂