Introduction

By default, GSheetConnector for WPForms Pro sends every form submission to your Google Sheet. But in many real situations, you may not want to send all entries. For example, you may want to send only entries with a company email address, or skip entries that are empty or incomplete.

The Conditional Logic option helps you control this. Before sending an entry, the plugin checks the conditions you have set. If the entry matches your conditions, it is sent to Google Sheets. If not, it is skipped.

When Should You Use Conditional Logic?

• You want to send only the entries from a specific email domain (for example, only company emails).
• You want to stop test or unwanted entries from going to your Google Sheet.
• You want to send entries only when a particular field is filled in.
• You want to send entries only when a message contains a specific word.

How to Enable Conditional Logic

Follow the steps below to enable Conditional Logic for your form:

1. Go to WPForms → All Forms and click Edit on the form you want to configure.
2. In the form builder, click on Settings from the left sidebar.
3. Select GSheetConnector Pro from the settings menu.
4. Scroll down to the Conditional Logic section.
5. Turn on the Enable Conditional Logic toggle. The condition options will appear below it.
6. Set your conditions (explained in the next section).
7. Click on the Save button at the top right corner of the builder.

Understanding the Condition Options

After enabling Conditional Logic, you will see a sentence like this:

[Send / Don’t send] to google sheet if [Field] [Operator] [Value]

Let us understand each part one by one.

1. Send / Don’t send

This option decides what happens when your conditions are matched.

• Send: The entry is sent to Google Sheets only when the conditions are matched.
• Don’t send: The entry is not sent to Google Sheets when the conditions are matched. All other entries are sent.

2. Select Field

This dropdown shows the form fields you can use in your condition. Choose the field you want to check, for example Email or Comment or Message.

3. Operator

The operator decides how the field value is compared with the value you enter.

• is: The field value is exactly the same as the value you enter.
• is not: The field value is different from the value you enter.
• empty: The field has been left blank. You do not need to enter any value.
• not empty: The field has been filled in. You do not need to enter any value.
• contains: The field value includes the text you enter anywhere inside it.
• does not contain: The field value does not include the text you enter.
• starts with: The field value begins with the text you enter.
• ends with: The field value ends with the text you enter.
• greater than: The field value is greater than the number you enter.
• less than: The field value is smaller than the number you enter.

4. Value

Type the text or number you want to compare with in the value box. For the operators empty and not empty, no value is needed.

5. And, Or and Add New Group

You can add more than one condition to make your rule more specific.

• And: Click the And button to add another condition in the same group. The entry is sent only when all the conditions in that group are matched.
• Add New Group: Click this button to add a new group of conditions. Groups are separated by or, so the entry is sent when any one of the groups is matched.
• Delete (trash icon): Click the red trash icon to remove a condition you no longer need.

Examples

Example 1: Send Only Gmail Entries to Google Sheets

Suppose you want only the entries with a Gmail address to be added to your sheet.

1. Turn on Enable Conditional Logic.
2. Select Send in the first dropdown.
3. In the field dropdown, select Email.
4. In the operator dropdown, select ends with.
5. In the value box, enter @gmail.com.
6. Click Save.

Result:

• john@gmail.com is added to the Google Sheet.
• john@yahoo.com is not added to the Google Sheet.

Example 2: Don’t Send Test Entries

If your team often submits test entries with a test email, you can block them.

1. Turn on Enable Conditional Logic.
2. Select Don’t send in the first dropdown.
3. In the field dropdown, select Email.
4. In the operator dropdown, select contains.
5. In the value box, enter test.
6. Click Save.

Result: Any entry where the email contains “test” is skipped. All other entries are sent to the sheet.

Example 3: Send Only When the Message Is Filled In

1. Turn on Enable Conditional Logic.
2. Select Send in the first dropdown.
3. In the field dropdown, select Comment or Message.
4. In the operator dropdown, select not empty.
5. Click Save.

Result: Only the entries where the visitor has written a message are added to the sheet.

Example 4: Use Multiple Conditions with “And”

Suppose you want to send an entry only when the email ends with your company domain and the message contains the word “quote”.

1. Turn on Enable Conditional Logic and select Send.
2. Condition 1: Email → ends with → @yourcompany.com
3. Click the And button to add a new condition.
4. Condition 2: Comment or Message → contains → quote
5. Click Save.

Result: The entry is sent to Google Sheets only when both conditions are true.

Example 5: Use Multiple Groups with “Or”

Suppose you want to send an entry if the email ends with either Gmail or Outlook.

1. Turn on Enable Conditional Logic and select Send.
2. In the first group, set Email → ends with → @gmail.com.
3. Click on Add New Group.
4. In the new group, set Email → ends with → @outlook.com.
5. Click Save.

Result: The entry is sent to Google Sheets if it matches at least one of the two groups.

Test Your Conditional Logic

1. Open the page where your WPForms form is published.
2. Submit one entry that matches your condition.
3. Submit another entry that does not match your condition.
4. Open your connected Google Sheet.