79% wp-gravity-forms-spreadsheets

Code Review | Connector for Gravity Forms and Google Sheets

WordPress plugin Connector for Gravity Forms and Google Sheets scored79%from 54 tests.

About plugin

  • Plugin page: wp-gravity-forms-...
  • Plugin version: 1.2.0
  • PHP compatiblity: 5.3+
  • PHP version: 7.4.16
  • WordPress compatibility: 3.8-6.3
  • WordPress version: 6.3.1
  • First release: Aug 19, 2019
  • Latest release: Aug 9, 2023
  • Number of updates: 32
  • Update frequency: every 45.5 days
  • Top authors: CRMPerks (100%)

Code review

54 tests

User reviews

40 reviews

Install metrics

3,000+ active /36,128 total downloads

Benchmarks

Plugin footprint 65% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Verifying that this plugin installs correctly without errors
Install script ran successfully

Server metrics [RAM: ▲0.05MB] [CPU: ▼6.23ms] Passed 4 tests

A check of server-side resources used by Connector for Gravity Forms and Google Sheets
Normal server usage
PageMemory (MB)CPU Time (ms)
Home /3.52 ▲0.0538.74 ▼5.53
Dashboard /wp-admin3.36 ▲0.0548.89 ▼4.26
Posts /wp-admin/edit.php3.47 ▲0.1147.04 ▼4.90
Add New Post /wp-admin/post-new.php5.94 ▲0.0586.30 ▼10.21
Media Library /wp-admin/upload.php3.27 ▲0.0439.08 ▲1.92

Server storage [IO: ▲0.37MB] [DB: ▲0.00MB] Passed 3 tests

Input-output and database impact of this plugin
This plugin was installed successfully
Filesystem: 32 new files
Database: 3 new tables, 7 new options
New tables
wp_vxg_googlesheets_accounts
wp_vxg_googlesheets_log
wp_vxg_googlesheets
New WordPress options
db_upgraded
widget_recent-posts
vxg_googlesheets_pro_version
can_compress_scripts
widget_recent-comments
widget_theysaidso_widget
theysaidso_admin_options

Browser metrics Passed 4 tests

Connector for Gravity Forms and Google Sheets: an overview of browser usage
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,814 ▲5314.15 ▼0.471.63 ▲0.0639.17 ▼2.20
Dashboard /wp-admin2,223 ▲515.60 ▼0.1484.21 ▼17.1542.10 ▲5.41
Posts /wp-admin/edit.php2,126 ▲261.99 ▼0.1236.20 ▲1.2735.30 ▼1.99
Add New Post /wp-admin/post-new.php1,554 ▲2823.36 ▲0.33671.36 ▼1.1153.49 ▼7.81
Media Library /wp-admin/upload.php1,425 ▲254.15 ▼0.0295.94 ▼17.3745.61 ▼2.30

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

🔸 Tests weight: 35 | Verifying that this plugin uninstalls completely without leaving any traces
It is recommended to fix the following
  • Zombie tables were found after uninstall: 3 tables
    • wp_vxg_googlesheets
    • wp_vxg_googlesheets_log
    • wp_vxg_googlesheets_accounts
  • Zombie WordPress options were found after uninstall: 7 options
    • theysaidso_admin_options
    • vxg_googlesheets_pro_version
    • can_compress_scripts
    • db_upgraded
    • widget_recent-posts
    • widget_recent-comments
    • widget_theysaidso_widget

Smoke tests Passed 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | Just a short smoke test targeting errors on the server (in the Apache logs)
Even though everything seems fine, this is not an exhaustive test

SRP Passed 2 tests

🔹 Tests weight: 20 | SRP (Single-Responsibility Principle) - PHP files must act as libraries and never output text or perform any action when accessed directly in a browser
Looking good! No server-side errors or output on direct access of PHP files

User-side errors Passed 1 test

🔹 Test weight: 20 | Just a short smoke test targeting errors on the browser (console and network errors and warnings)
No browser errors were detected

Optimizations

Plugin configuration 96% from 29 tests

readme.txt Passed 16 tests

You should put a lot of thought into formatting readme.txt as it is used by WordPress.org to prepare the public listing of your plugin
5 plugin tags: gravity forms google drive, gravity forms, gravity forms to google sheet, gravity forms google sheets, gravity forms to google docs

wp-gravity-forms-spreadsheets/wp-gravity-forms-spreadsheets.php 92% from 13 tests

"Connector for Gravity Forms and Google Sheets" version 1.2.0's main PHP file describes plugin functionality and also serves as the entry point to any WordPress functionality
Please take the time to fix the following:
  • Text Domain: The text domain must be the same as the plugin slug, although 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
There were no executable files found in this plugin6,249 lines of code in 22 files:
LanguageFilesBlank linesComment linesLines of code
PHP196498656,243
JavaScript2105
CSS1001

PHP code 50% from 2 tests

An short overview of logical lines of code, cyclomatic complexity, and other code metrics
Please tend to the following items
  • Cyclomatic complexity of methods should be reduced to less than 100 (currently 126)
Cyclomatic complexity
Average complexity per logical line of code0.50
Average class complexity119.43
▷ Minimum class complexity6.00
▷ Maximum class complexity378.00
Average method complexity6.31
▷ Minimum method complexity1.00
▷ Maximum method complexity126.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes7
▷ Abstract classes00.00%
▷ Concrete classes7100.00%
▷ Final classes00.00%
Methods156
▷ Static methods31.92%
▷ Public methods15096.15%
▷ Protected methods00.00%
▷ Private methods63.85%
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

Using a strong compression for your PNG files is a great way to speed-up your plugin
8 PNG files occupy 0.01MB with 0.01MB in potential savings
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
images/active0.png0.22KB0.18KB▼ 16.67%
images/failed.png1.54KB0.48KB▼ 68.88%
images/filtered.png1.47KB0.48KB▼ 67.40%
images/created.png1.52KB0.50KB▼ 67.24%
images/deleted.png0.48KB0.33KB▼ 31.03%