Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I want to create an integration between Zapier, RD Station Marketing, and a Google Sheets spreadsheet.

Basically, the spreadsheet is automatically populated with data from customers who log into the community every day.

By integrating Zapier with RD Station, I want Zapier to check if that login (email) is appearing in the spreadsheet for the first time — which would mean it's that person's first login.

 

As soon as Zapier identifies the email for the first time, I want it to send this information to RD Station Marketing so I can trigger an automation based on it.

I know how to set things up in RD Station, but I’m not sure how to configure this in Zapier.

 

Who can help me with that?

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!

Reply


Terms & Conditions