Fluent Forms + MailRefine to Google Sheets – WPBot- Automator

Fluent Forms with MailRefine email verification inside WPBot Automator Pro, you can screen out fake or mistyped email addresses instantly and pass only verified data directly to Google Sheets.

Step 1: Set Your Fluent Forms Trigger

1. Inside your WordPress dashboard, navigate to WPBot Automator Pro and click Create New Workflow.

2. Set your workflow Trigger to Fluent Forms.

3. Select the specific form you want to monitor (e.g., “Contact Us” or “Lead Magnet Form”).

4. Save the trigger to capture form variables like {{form.email}} and {{form.name}}.

Step 2: Add MailRefine Verification (Action 1)

Instead of immediately mapping your form to a sheet, we introduce the MailRefine step to act as a bouncer.

1. Add an Action directly underneath your Fluent Forms trigger.

2. Select MailRefine (or choose Webhook/API Request if using MailRefine’s direct API key endpoints).

3. Set the action event to Verify Email.

4. Map your Fluent Forms email field variable ({{form.email}}) into MailRefine’s request box.

Step 3: Insert Conditional Logic (The Filter)

To stop bad emails from proceeding down the timeline, add a conditional block.

1. Click the + icon to add a rule block between your actions.

2. Choose Conditional Logic / Router.

3. Set the condition parameters based on MailRefine’s output data payload:

   • IF: MailRefine Status ➡️ Equals ➡️ valid

Now, if MailRefine flags the address as “disposable,” “spam,” or “invalid,” the automation halts immediately.

Step 4: Map Verified Data to Google Sheets (Action 2)

1. Inside the approved “Valid” path of your conditional logic, add your final Action.

2. Select Google Sheets from the integrations array.

3. Choose your target Spreadsheet and specific Worksheet tab.

4. Map your final column values:

   • Name Column: {{form.name}}

   • Email Column: {{form.email}}

   • Verification Status: {{mailrefine.status}} (Optional: Useful if you want confirmation)

5. Save the configuration and toggle your workflow status to Active.