79% integration-for-contact-form-7-and-google-sheets

Code Review | Integration for Google Sheets and Contact Form 7, WPForms, Elementor, Ninja Forms

WordPress plugin Integration for Google Sheets and Contact Form 7, WPForms, Elementor, Ninja Forms scored79%from 54 tests.

About plugin

  • Plugin page: integration-for-c...
  • Plugin version: 1.0.5
  • PHP compatiblity: 5.3+
  • PHP version: 7.4.16
  • WordPress compatibility: 4.7-6.3
  • WordPress version: 6.3.1
  • First release: Dec 13, 2021
  • Latest release: Oct 7, 2023
  • Number of updates: 13
  • Update frequency: every 51.4 days
  • Top authors: CRMPerks (100%)

Code review

54 tests

User reviews

1 review

Install metrics

300+ active /1,887 total downloads

Benchmarks

Plugin footprint 65% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Checking the installer triggered no errors
Installer ran successfully

Server metrics [RAM: ▲0.14MB] [CPU: ▼1.73ms] Passed 4 tests

An overview of server-side resources used by Integration for Google Sheets and Contact Form 7, WPForms, Elementor, Ninja Forms
No issues were detected with server-side resource usage
PageMemory (MB)CPU Time (ms)
Home /3.52 ▲0.0635.89 ▼3.13
Dashboard /wp-admin3.52 ▲0.2250.24 ▲0.13
Posts /wp-admin/edit.php3.57 ▲0.2148.80 ▲0.60
Add New Post /wp-admin/post-new.php6.04 ▲0.1593.59 ▼4.53
Media Library /wp-admin/upload.php3.37 ▲0.1536.75 ▲1.33

Server storage [IO: ▲1.29MB] [DB: ▲0.08MB] Passed 3 tests

Filesystem and database footprint
There were no storage issued detected upon installing this plugin
Filesystem: 71 new files
Database: 3 new tables, 7 new options
New tables
wp_vxcf_googlesheets_accounts
wp_vxcf_googlesheets
wp_vxcf_googlesheets_log
New WordPress options
can_compress_scripts
widget_theysaidso_widget
widget_recent-comments
vxcf_googlesheets_version
db_upgraded
theysaidso_admin_options
widget_recent-posts

Browser metrics Passed 4 tests

A check of browser resources used by Integration for Google Sheets and Contact Form 7, WPForms, Elementor, Ninja Forms
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,805 ▲4414.67 ▲0.391.75 ▲0.0140.78 ▼6.84
Dashboard /wp-admin2,214 ▲365.56 ▼0.1184.19 ▼20.1439.76 ▼5.00
Posts /wp-admin/edit.php2,116 ▲161.97 ▼0.0340.70 ▲2.1535.11 ▼2.64
Add New Post /wp-admin/post-new.php1,548 ▲2218.29 ▼4.93637.87 ▼28.0563.57 ▲17.61
Media Library /wp-admin/upload.php1,416 ▲194.18 ▼0.0398.36 ▼2.4143.31 ▼1.40

Uninstaller [IO: ▲0.00MB] [DB: ▲0.08MB] 50% from 4 tests

🔸 Tests weight: 35 | Checking the uninstaller removed all traces of the plugin
It is recommended to fix the following
  • The plugin did not uninstall successfully, leaving 3 tables in the database
    • wp_vxcf_googlesheets_log
    • wp_vxcf_googlesheets_accounts
    • wp_vxcf_googlesheets
  • The uninstall procedure has failed, leaving 7 options in the database
    • widget_theysaidso_widget
    • can_compress_scripts
    • widget_recent-comments
    • widget_recent-posts
    • vxcf_googlesheets_version
    • db_upgraded
    • theysaidso_admin_options

Smoke tests Passed 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | This is a shallow check for server-side errors
Everything seems fine, however this is by no means an exhaustive test

SRP Passed 2 tests

🔹 Tests weight: 20 | The single-responsibility principle: PHP files have to remain inert when accessed directly, throwing no errors and performing no actions
No output text or server-side errors detected on direct access of PHP files

User-side errors Passed 1 test

🔹 Test weight: 20 | This is just a short smoke test looking for browser issues
No browser issues were found

Optimizations

Plugin configuration 93% from 29 tests

readme.txt Passed 16 tests

The readme.txt file is undoubtedly the most important file in your plugin, preparing it for public listing on WordPress.org
5 plugin tags: ninja forms google sheets, wpforms google sheet integration, contact form 7 google sheets, google sheets, wordpress google sheets

integration-for-contact-form-7-and-google-sheets/integration-for-contact-form-7-and-google-sheets.php 85% from 13 tests

Analyzing the main PHP file in "Integration for Google Sheets and Contact Form 7, WPForms, Elementor, Ninja Forms" version 1.0.5
You should first fix the following items:
  • Description: Keep the plugin description shorter than 140 characters (currently 233 characters long)
  • Text Domain: If you choose to specify the text domain, it must be the same as the plugin slug; optional since WordPress version 4.6

Code Analysis 97% from 3 tests

File types Passed 1 test

🔸 Test weight: 35 | This is a short overview of programming languages used in this plugin, detecting executable files
Success! There were no dangerous files found in this plugin7,869 lines of code in 29 files:
LanguageFilesBlank linesComment linesLines of code
PHP207318396,952
SVG100640
CSS52310271
JavaScript31206

PHP code 50% from 2 tests

Analyzing cyclomatic complexity and code structure
It is recommended to fix the following
  • Method cyclomatic complexity has to be reduced to less than 100 (currently 105)
Cyclomatic complexity
Average complexity per logical line of code0.49
Average class complexity144.86
▷ Minimum class complexity6.00
▷ Maximum class complexity461.00
Average method complexity6.36
▷ Minimum method complexity1.00
▷ Maximum method complexity105.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes7
▷ Abstract classes00.00%
▷ Concrete classes7100.00%
▷ Final classes00.00%
Methods188
▷ Static methods63.19%
▷ Public methods18296.81%
▷ Protected methods00.00%
▷ Private methods63.19%
Functions0
▷ Named functions00.00%
▷ Anonymous functions00.00%
Constants1
▷ Global constants1100.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

Often times overlooked, PNG files can occupy unnecessary space in your plugin
35 PNG files occupy 0.07MB with 0.03MB in potential savings
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
css/images/ui-bg_glass_75_dadada_1x400.png0.26KB0.16KB▼ 38.93%
images/deleted.png0.48KB0.33KB▼ 31.03%
css/images/ui-bg_flat_75_ba9217_40x100.png0.20KB0.08KB▼ 57.77%
images/created.png1.52KB0.50KB▼ 67.24%
css/images/ui-icons_88a206_256x240.png4.44KB4.17KB▼ 6.02%