Checking data in Google Sheets

Hello ​@andrixxa ,

Try creating this Zap, assuming you already have a Zap automation workflow that records the data. You’ll need to create another workflow that triggers when a New Spreadsheet Row is created—since, as you mentioned, the spreadsheet is automatically populated with data from customers who log into the community each day.

Step 1: Trigger (Google Sheets)

Trigger Event: New Spreadsheet Row

• Connect the spreadsheet where daily login data is added.
• Ensure that the email is one of the columns.

Step 2: Find Existing Email in Sheet (Google Sheets)

Action Event: Lookup Spreadsheet Row

• Use the same spreadsheet.
• Choose the column with the email addresses.
• Use the email from the trigger step as the lookup value.
• Leave the checkbox “Create Google Sheet row if not found” unchecked, we only want to search.

Step 3: Filter - Only Continue If It's the First Login (Filter by Zapier)

Conditions: If Step 2 returned no row, it means the email is appearing for the first time.

• Configure your filter conditions.Only continue if... Row ID (or lookup result field) → (Text) Does not exist.

Step 4: Send Info to RD Station (RD Station)

Action Event: Create or Update Lead

• Map the email field from the trigger.
• Add any custom field/identifiers to flag this as a "first login".
• (Optional) Tag or update a lead stage to trigger your automation in RD Station.

This is just a general overview of the proposed workflow—there may be some adjustments needed depending on your setup. Hope this helps!

Hi there ​@andrixxa 👋

Did ​@Sync9-Solutions’s reply help to point you in the right direction or did you figure out a different solution? 

Happy to lend a hand if you’re still stuck at all, just let us know! 🙂