Not every form submission needs to land in the same place, or even sync at all. Maybe you only want spam-free leads recorded, or you want submissions routed to different sheets depending on where they came from. That’s exactly what Conditional Logic is for.

With Conditional Logic, you can control exactly when a submission gets synced to Google Sheets — and, if you’re using Multi Sheet Connection, which specific sheet it should go to — all based on the values entered in your Contact Form 7 form.

Conditional Logic for Single Sheet Connection

If your form uses a Single Sheet Connection, Conditional Logic lets you decide whether a submission should be synced at all, based on the criteria you define.

Step 1: Enable Conditional Logic

Locate the Conditional Logic setting inside your feed configuration and toggle on Enable Conditional Logic.

Step 2: Set Your Conditions

Define your criteria using comparison operators such as equals, not equals, greater than, or less than. For more advanced scenarios, you can also use Starts With or Ends With logic.

Step 3: Save Your Changes

Click the Save button to apply your conditions.

Examples

• Only sync the entry if your-name is David.
• Only sync the entry if your-email is david@gmail.com.

You can add as many additional conditions as your requirements call for.

Conditional Logic for Multi Sheet Connection

If you’re using Multi Sheet Connection, Conditional Logic becomes even more powerful — you can route the same form’s submissions to different Google Sheets based on different rules for each feed.

Add Two Feeds

To route submissions conditionally, start by creating two separate feeds under Multi Sheet Connection — one for each destination sheet.

Feed 1 – Conditional Logic

To enable Conditional Logic for Feed 1:

1. Navigate to the Conditional Logic section in Feed 1’s settings.
2. Toggle on Enable Conditional Logic.
3. Define your condition. For example:
   • Field: “Reference”
   • Condition: is
   • Value: “Google”
4. Save your settings to apply the logic. This ensures Feed 1 only syncs entries when the specified condition is met.

Feed 1 Configuration

Configure your first feed to connect to your first Google Sheet.

Feed 1 – Conditional Logic

To enable Conditional Logic for Feed 1:

1. Navigate to the Conditional Logic section in Feed 1’s settings.
2. Toggle on Enable Conditional Logic.
3. Define your condition. For example:
   • Field: “Reference”
   • Condition: is
   • Value: “Google”
4. Save your settings to apply the logic. This ensures Feed 1 only syncs entries when the specified condition is met.

Feed 2 Configuration

Configure your second feed to connect to your second Google Sheet.

Feed 2 – Conditional Logic

To enable Conditional Logic for Feed 2:

1. Navigate to the Conditional Logic section in Feed 2’s settings.
2. Toggle on Enable Conditional Logic.
3. Define your condition. For example:
   • Field: “Reference”
   • Condition: is
   • Value: “Direct”
4. Save your settings to apply the logic. This ensures Feed 2 only syncs entries when the specified condition is met.

With this setup, a form submission is automatically routed to Sheet 1 when “Reference” equals “Google,” and to Sheet 2 when “Reference” equals “Direct.” Each entry is logged in the correct sheet based purely on the condition it matches.

What’s Next?

Want to fine-tune which fields, headers, and styles sync alongside your conditional feeds? Check out the Plugin Settings – PRO Version guide. Need to route custom or third-party data as well? See the Hooks to Use Custom Mail Tags guide.