Connect Contact Form 7, WooCommerce To Google Sheets & Other Platforms – Advanced Form Integration

by nasirahmed

Overview


Connect Contact Form 7 & WooCommerce to 30+ other platforms. It works like when a form is submitted to your website, the plugin will automatically create a new row in Google Sheets, subscribe to a mailing list in Sendinblue, Mailchimp, Klaviyo, etc. Similarly, it allows to send WooCommerce order data.

  • Easy to use: The plugin was created, keeping not-tech people in mind. New integrations can be set up in a few minutes. No coding skill is required, almost no learning curve.

  • Flexible: Integrations can be created from any sender platform to any receiver platform. You can create as many connections as you wantsingle sender to multiple receivers, multiple senders to a single receiver, multiple senders to multiple receivers. Just keep in mind that all PHP server has a maximum execution time allowed.

  • Conditional Logic: You can create single or multiple conditional logic to filter the data flow. Submitted data will only be sent if the conditions match. For example, when you want to send contact data only if the user has agreed and filed the checkbox “I agree” (Contact Form 7 acceptance field) or if the city is only New York or the subject contacts the word “Lead,” etc. You can set up the conditions as you like.

  • Special Tags: We have introduced several special tags that can be passed to receiver platforms. These are helpful when you want some more information that the user submitted, like IP address, user agent, etc. Example: {{_date}} same format and timezone that is saved in WordPress settings, {{_time}} same format and timezone that is saved in WordPress settings, {{_weekday}} weekday like Monday, Tuesday, etc., {{_user_ip}}, {{_user_agent}}, {{_site_title}}, {{_site_description}}, {{_site_url}}, {{_site_admin_email}}, {{_post_id}}, {{_post_name}}, {{_post_title}}, {{_post_url}}, {{_user_id}}, {{_user_first_name}}, {{_user_last_name}}, {{_user_last_name}}, {{_user_email}}.

  • Multisite: Multisite supported.

[Website] [Documentation] [Tutorial Videos] [Comparison]

SENDER PLATFORMS (TRIGGER)

The following plugins work as a sender platform.

  • Contact Form 7: Any contact form created using Contact Form 7 can be integrated. So when a user submits the form, data will be sent to connected platforms.

  • WooCommerce: When a new order is placed or order status is processing/on-hold/completed/failed/pending/refunded/canceled in a WooCommerce shop, the order data can be sent to connected platforms. The following are the regular fields that the plugin allows to send by default: Order ID, Parent ID, User ID, Billing First Name, Billing Last Name, Formatted Billing Full Name, Billing Company, Billing Address 1, Billing Address 2, Billing City, Billing State, Billing Postcode, Billing Country, Billing Email, Billing Phone, Formatted Billing Address, Shipping First Name, Shipping Last Name, Shipping Full Name, Shipping Company, Shipping Address 1, Shipping Address 2, Shipping City, Shipping State, Shipping Postcode, Shipping Country, Shipping Email, Shipping Phone, Formatted Shipping Address, Shipping Address Map URL, Payment Method, Payment Method Title, Transaction ID, Order Created Via, Date Completed, Date Created, Date Modified, Date Paid, Cart Hash, Currency, Customer ID, Customer IP Address, Customer User Agent, Customer Note, Total, Formatted Order Total, Order Item Total, Prices Include Tax, Discount Total, Discount Tax, Shipping Total, Shipping Tax, Cart Tax, Total Tax, Total Discount, Subtotal, Tax Totals, Items Full JSON, Line Item(s) ID, Line Item(s) Name, Line Item(s) SKU, Line Item(s) Variation ID, Line Item(s) Quantity, Line Item(s) Total, Line Item(s) Price, Line Item(s) Sale Price, Line Item(s) Regular Price, Line Item(s) Subtotal, Line Item(s) Subtotal Tax, Line Item(s) Subtotal With Tax, Line Item(s) Total Tax, Line Item(s) Total With Tax, Line Item(s) Number In Cart, Line Item(s) Attributes, Taxes, Shipping Methods, Shipping Method, Coupons Applied and Coupons Amount Total.

    In addition to regular fields, you can also use WooCommerce custom order fields. For example, to send fields created by the Checkout Field Editor plugin, you have to add the input field name value manually as a tag. For example, in the checkout page, youve added an extra field for Interests and its name value is interests, then add a tag {{interests}} while creating the integration. The plugin should parse the value from user input and send it to the connected platform field.

Premium Version Features.

Following sender forms are supported in the premium version.

RECEIVER PLATFORMS (ACTION)

  • ActiveCampaign – ActiveCampaign is a popular email marketing and automation platform. This plugin allows you to integrate it with any sender platform, so when a user submits the form with personal details, it will automatically create a contact in ActiveCampaign. The contact can be added to a list or automation. Additionally, deals and notes can be created, too, for that contact. Requires a pro license to use custom fields.

  • Agile CRM – This plugin allows creating contact, deal and note. Requires a pro license to use tags and custom fields.

  • Asana – Allows to create a new task.

  • Autopilot – This plugin allows creating/updating contact and adding to a list. Requires a pro license to use custom fields.

  • AWeber – Allows to create contact and subscribe to a list. Pro license is required to use custom fields and tags.

  • Benchmark Email – Allows to create contact and subscribe to a list. Pro license is required to use custom fields.

  • Campaign Monitor – Allows to create contact and subscribe to list. Pro license is required to use custom fields.

  • ClinchPad CRM – Simpler than a traditional CRM. This plugin allows creating new contact in Clinchpad when a form is submitted.

  • Close CRM – Close is the inside sales CRM of choice for startups and SMBs. You can add a new lead and contact to Close CRM. The Pro version supports custom fields.

  • ConvertKit – ConvetKit is another popular email marketing software. This plugin allows you to create a new contact and subscribe to a sequence. Pro license is required to use custom fields and tags.

  • Copper CRM – Allows you to create a new company, person and deal in Copper CRM. The Pro version supports custom fields and tags.

  • Curated – Add subscriber.

  • DirectIQ – Allows you to create contact and add to the mailing list.

  • Drip – Drip is a marketing automation platform built for eCommerce – utilizing email, SMS, etc. This plugin allows you to create subscribers.

  • Elastic Email – Elastic Email is a marketing platform built on the most cost-effective delivery engine. You can create a contact and add it to a mailing list. Pro license is required to use custom fields.

  • EmailOctopus – Allows you to add contact and subscribe to a list.

  • EverWebinar – Add registrant to webinar.

  • Freshworks CRM (Freshsales) – Freshworks CRM is a full-fledged Sales CRM software for your business. This plugin allows you to create account, contact and deals with custom fields.

  • GetResponse – GetResponse is a powerful, simplified tool to send emails, create pages, and automate your marketing. This plugin allows you to create a subscriber and add it to the mailing list The Pro version supports custom fields and tags.

  • Google Calendar – Allows you to create a new event on a selected Google Calendar with supplied data.

  • Google Sheets – When a sender form is submitted, or a WooCommerce order is created, this plugin allows you to create a new row on a selected sheet with supplied data. In the Pro version, it is allowed to create separate rows for WooCommerce Order Items. For example, if an order has 5 items so 5 separate rows will be created for each item.

  • Hubspot CRM – Allows you to create new contact in Hubspot CRM with additional custom fields support.

  • Insightly – Insightly CRM is another powerful CRM. Using the Advanced Form Integration plugin, you can create a new contact on it.

  • Jumplead – Jumplead offers a full all-in-one inbound marketing automation platform. This plugin allows adding a contact on it.

  • Klaviyo – Klaviyo is an email marketing platform created for online businesses featuring powerful email and SMS marketing automation. Using Advanced Form Integration, you can add a contact, subscribe to a list. Pro license is required to use custom properties.

  • lemlist – A cold email tool powering sales teams, agencies, and B2B businesses to personalize and automate outreach campaigns. This plugin allows creating contact and adds it to a campaign.

  • LionDesk – LionDesk offers sales and marketing automation for Real Estate Agents and Brokers. Creating a new contact is supported using our plugin.

  • Mailchimp – Mailchimp is the All-In-One integrated marketing platform for small businesses, to grow your business on your terms. This plugin allows you to create contacts, subscribe to a list, and unsubscribe from the list. Requires Pro license to use Custom|Merge fields, tags.

  • MailerLite – MailierLite offers to create advanced email marketing campaigns with features like automation, landing pages, and surveys. Using this plugin, you can add contact and subscribe to a group. Requires a Pro license to use custom fields.

  • Mailify – Mailify is a email marketing solution. This plugin allows you to create contacts and subscribe to lists. Requires a Pro license to use custom fields.

  • Mailjet – Allows you to create a contact and add it to a list. Requires a Pro license to use custom fields.

  • Moosend – Allows you to create a contact and add it to a list. Requires a Pro license to use custom fields.

  • Omnisend – Omnisend is the eCommerce marketing automation platform built for growing eCommerce businesses. Our plugin allows you to create new contacts. Requires pro license to use custom fields.

  • Pabbly Email Marketing – Allows you to create a subscriber and add it to a list. Requires a Pro license to use custom fields.

  • Pipedrive – Pipedrive is the easy-to-use, #1 user-rated CRM tool. This plugin allows you to create organizations, people, deals, notes, activity with custom fields support.

  • Pushover – Allows you to send push messages to Android/iOS/Desktop.

  • Revue – Allows you to create subscriber.

  • SendFox – Allows you to create contact and subscribe to a list.

  • SendPulse – Allows you to create contact and subscribe to a list.

  • Sendinblue – Sendinblue is a complete all-in-one digital marketing toolbox. Our plugin allows you to create subscribers and add to a list. Pro license is required to use custom fields and other languages.

  • Sendy – Allows creating contact and subscribe to a list. Pro license is required to use custom fields.

  • Slack – Allows sending channel message.

  • Smartsheet – Allows creating new row.

  • Trello – This plugin allows you to create new card in Trello.

  • Twilio – This plugin allows you to send customized SMS using Twilio.

  • Webhook – Allows you to send data to any webhook URL. In the Pro version, you can send fully customized headers and body (GET, POST, PUT, DELETE), literally can send data to any API with API token and Basic auth.

  • WebinarJam – Add registrant to webinar.

  • Woodpecker.co – Allows creating subscriber. Requires Pro license to use custom fields.

  • WordPress – Create new post.

  • Zapier – Sends data to Zapier webhook.

WHY I CREATED THIS PLUGIN

I was using a popular form plugin on my website for new registrations. I built several integrations with CRM, email marketing soft, Google Sheets, etc. The form had add-ons for those. Then I found another form with more features but less expensive, so I decided to migrate. Here comes the challenge. The new form didn’t have native add-ons to integrate all the platforms I was using. So I created a few of my own and thought it could help others If I can create a universal plugin that connects all popular forms and 3rd party platforms. This plugin is built to add new sender and receiver platforms, so the opportunity has no bound. I’m adding new platforms regularly. Currently, Contact Form 7 and WooCommerce are supported free and need a pro license for others.

SOME VIDEOS ON HOW TO USE THE PLUGIN

Create Google API project

Connect Contact Form 7 to google sheets

Connect woocommerce new order to google sheets

Connect Contact Form 7 to Agile CRM

Connect Contact Form 7 to ActiveCampaign

Connect Contact Form 7 to Campaign Monitor

Connect Contact Form 7 to ConvertKit

Connect Contact Form 7 to Elastic Email

Connect Contact Form 7 to EmailOctopus

Connect Contact Form 7 to GetResponse

Connect Contact Form 7 to Klaviyo

Connect Contact Form 7 to Mailify

Connect Contact Form 7 to Sendinblue

Connect Contact Form 7 to lemlist

Connect Contact Form 7 to SendFox

Connect Contact Form 7 to Mailchimp

Connect Contact Form 7 to LionDesk CRM

Connect Contact Form 7 to Omnisend

Discuss


Summary
Version:
1.42.3
Last updated:
Active installations:
WordPress Version:
3.0.1 or higher
Tested up to:
5.8.1
PHP Version:
5.4 or higher
Ratings