Gravity Forms vs Connector for Gravity Forms and Google Sheets

The Email Blacklist Add-on for Gravity Forms was built to help block submissions from users with generic or competitors email addresses. Prevent the user from processing the form and stop non-qualified leads from being collected. This plugin allows site admins to create a list of domains that if used in an email field on a Gravity Form it will cause a validation error and block the submission. A default email blacklist and validation message can be created to use across all email fields. These default settings can be overridden on a per email field basis. Global settings can be added on ‘Forms’ > ‘Settings’ > ‘Email Blacklist’. To add settings to an individual email field, select the field and navigate to the ‘Advanced Settings’ tab. This plugin works by blocking either individual email addresses (ex. [email protected]), email address domains (ex. gmail.com), and/or email address top-level domains (ex. *.com). Feel free to contribute on github. Instructions Global Blacklist Settings Once set up, these settings will be used on all email input fields across all the Gravity Forms used on the site. They can be overridden by the individual email blacklist settings below. Once Logged into your site navigate to ‘Forms’ > ‘Settings’ > ‘Email Blacklist’ In the ‘Global Blacklisted Emails’ input enter a comma separated list of blacklisted domains (ie. hotmail.com), email addresses (ie. [email protected]), and/or include the wildcard notation to block top-level domains (ie. *.com). This setting can be overridden on individual email fields in the advanced settings. In the ‘Global Validation Message’ input enter a default error message if a blacklisted email is submitted. This setting can be overridden on individual email fields in the advanced settings. Select the ‘Global Invalid Entry Procedure’ to determine how the blacklisted submissions should be handled, with validation error or collected and marked as spam. Click the ‘Update Settings’ button to save the settings. Individual Email Input Blacklist Settings Once set up these settings will be used on this form only and in place of the global blacklist settings above. Once Logged into your site navigate to the Gravity Form you would like to update. Add or update an existing email input field on the form. Go to the ‘Advanced Settings’ tab for the ‘Blacklisted Emails’ input. In the ‘Blacklisted Emails’ input enter a comma separated list of blacklisted domains (ie. hotmail.com), email addresses (ie. [email protected]), and/or include the wildcard notation to block top-level domains (ie. *.com). This will override the globally defined blacklisted emails setting. Enter ‘none’ to bypass the global setting and allow all email addresses. In the ‘Blacklisted Emails Validation Message’ input enter an error message if a blacklisted email is submitted. This will override the globally defined error message. Select the ‘Invalid Entry Procedure’ to determine how the blacklisted submissions should be handled, with validation error or collected and marked as spam. Click the ‘Save Form’ button to save the settings. Additional Resources Gravity Forms Documentation – Getting Started Gravity Forms Documentation – Email Input Fields Gravity Forms Documentation – Fighting Spam

Gravity Forms Google Sheets Connector sends form submissions from Gravity Forms to Google Sheets when anyone submits a form on your site. Learn more at crmperks.com Gravity Forms Google Sheets Connector Setup Go to Forms -> Settings -> Google Sheets then add new account. Go to Forms -> select any form -> Settings -> Google Sheets then create new feed. Map required Google Sheets fields to Gravity Forms form fields. Send your test entry to Google Sheets by clicking “Send to Google Sheets” button. Go to Forms -> select any form -> Settings -> Google Sheets Logs and verify status of previously sent entries. Connecting Google Sheets account Connect any gravity forms form to Google Sheets by safe and secure Oauth 2.0. Additionally, you can connect multiple Google Sheets to Gravity Forms. Map Google Sheets fields Select any Google Sheet then Map gravity forms form fields to Google Sheet fields. Filter Gravity Forms Google Sheets entries Either send all entries to Google Sheets or send specific entries based on user input. For example , only send those form entries to Google Sheets which contanin work email address. Manually sending entries to Google Sheets You can automatically Send gravity forms submissions to Google Sheets when a user submits a form. Also, you can manually send gravity forms submissions to Google Sheets. Gravity Forms Google Sheets logs View a detailed log of each gravity forms submission Whether sent or not sent to Google Sheets , You can easily resend any entry to Google Sheets. Premium Version Features. Following features are available only in premium version. Gravity Forms Google Sheets Add-on. Map Gravity Forms Phone Number fields to Google Sheets. Send Gravity Forms attachments to Google Sheets. Create Un-Limited Google Sheets feeds. When any user submits a contact form, track gclid, utm parameters and geolocation. Lookup customer’s email or phone number using popular email and phone number lookup services. 20+ premium addons Need Google Sheets Plugin for Contact Form 7 ? We have Google Sheets add-on for Contact Form 7. Integration for Contact Form 7 and Google Sheets