SheetFusion – Sync Google Sheets Into Tables. No Row Limits, No API Keys.

2.1.2 — 2026-04-27

• Bug fix: switched Google Sheets fetch from the gviz/tq Visualization API endpoint to the plain export?format=csv endpoint — resolves two data-import bugs caused by the Visualization API’s type inference and header-merging behaviour:
  • Mixed-type columns: cells whose value didn’t match the column’s inferred type (e.g. “5+” in an otherwise numeric column) were silently dropped from the output and never appeared in the table
  • Header row merging: when row 1 contained column headers and row 2 contained text values, the API merged both rows into a single header row, appending the row-2 value to each header label (e.g. “Company” + “nr” → “Company nr”, “Insider” + “Rose, Mike” → “Insider Rose, Mike”)
• The export endpoint returns raw cell values with no type inference or header manipulation, so all cell values now import correctly regardless of column type

2.1.1 — 2026-04-03

• Feature: native Gutenberg block (sheetfusion/table) — full block editor support with settings sidebar (Sheet Source, Display, Sorting, Export & Buttons, Server-Side Filter, Advanced panels) and live server-side preview in the editor canvas
• Architecture: block and shortcode share a single PHP rendering function (SheetFusion_Shortcode::render()) — no duplication of fetch, parse, HTML build, caching, or DataTables initialisation logic
• Asset loading: DataTables scripts continue to load conditionally; the existing mark_assets_needed() flag is triggered by the block render path in exactly the same way as the shortcode
• Added blocks/sheetfusion-table/block.json, blocks/sheetfusion-table/render.php, assets/js/blocks.js, assets/css/blocks-editor.css
• Updated plugin title to “SheetFusion – Sync Google Sheets Into Tables. No Row Limits, No API Keys.”
• Bumped version to 2.1.1; updated Tested up to: 6.9

2.1.0 — 2025-01-01

• Security: removed style= attribute from wp_kses allowlist in cell output — eliminates a CSS injection vector from sheet data
• Performance: DataTables assets now load conditionally only on pages that contain a [sheetfusion] shortcode (zero overhead on all other pages)
• Standards: replaced raw inline <script> output with wp_add_inline_script() — correct WordPress practice
• Standards: wrapped all raw SQL queries in $wpdb->prepare() (deactivation hook and AJAX cache-clear handler)
• Standards: replaced deprecated current_time(‘timestamp’) with time()
• i18n: moved all user-facing JS strings into wp_localize_script so they are translatable
• i18n: removed deprecated document.execCommand(‘copy’) fallback; Clipboard API used exclusively
• Feature: configurable row cap (default 5,000) with admin notice when limit is reached — prevents memory exhaustion on large sheets
• Feature: link_columns shortcode attribute lets you specify exactly which columns should auto-link bare URLs (previously hard-coded to column 1 only)
• Feature: refresh=”1″ attribute now restricted to administrators to prevent cache-busting by unprivileged users
• Maintenance: bumped version to 2.1.0 and updated Tested up to: 6.7
• Added uninstall.php to clean up all plugin data on deletion

2.0.0 — 2024-06-01

• Complete rewrite — proper multi-file plugin structure
• Admin dashboard to save and manage sheets
• Export buttons: CSV, Excel, PDF, Print (DataTables Buttons extension)
• Column visibility toggle
• Four visual themes: Default, Stripe, Minimal, Dark
• Global settings: cache duration, default page length, default theme
• Improved security: nonce verification on all AJAX requests, wp_kses sanitisation on cell output
• Unique table IDs using wp_generate_uuid4() — supports multiple tables per page
• HTTP status code check with user-friendly error messaging
• Translation-ready (text domain: sheetfusion)

1.0.0 — 2024-01-01

• Initial release