FAIR

Federated and Independent Repositories

SheetPop

Plugin Banner

SheetPop

by Yutaro Ikeda

Download
Description

SheetPop converts Excel (.xlsx) templates to PDF automatically when forms are submitted. Perfect for generating invoices, receipts, quotations, and other documents.

Features:

  • Upload Excel templates with placeholders
  • Automatic PDF generation on Contact Form 7 submission
  • WooCommerce order invoice generation
  • Download link display after form submission
  • Admin email notification with PDF link
  • Monthly usage tracking
  • All features are available with the free API key — no premium-only features or locked functionality

How It Works:

  1. Upload an Excel template with placeholders like {{field_name}}
  2. Connect the template to a Contact Form 7 form
  3. When users submit the form, PDF is generated automatically
  4. Users can download the PDF from the confirmation page

Supported Excel Features:

  • Basic formulas (SUM, IF, VLOOKUP, etc.)
  • Cell formatting and borders
  • Images (PNG, JPEG)
  • Japanese fonts (Noto Sans JP, Noto Serif JP)

Limitations:

  • Macros (VBA) are not supported for security reasons
  • Pivot tables are not supported
  • Conditional formatting has limited support

External services

This plugin relies on two external services to function. No data is sent to any external service without user action (form submission or admin registration).

SheetPop API

This plugin connects to the SheetPop API to convert Excel templates into PDFs.

  • Service URL: https://sheetpop.dev
  • API Endpoint: https://jl46dss506.execute-api.ap-northeast-1.amazonaws.com

The following data is sent to the SheetPop API:

  1. Registration (POST /register) — When the site administrator registers for an API key from the plugin settings page, the admin email address, site URL, and locale are sent. This happens once during initial setup.
  2. Template upload (POST /templates/upload-url) — When the administrator uploads an Excel template from the plugin settings page, a pre-signed upload URL is requested. The template file name and size are sent.
  3. PDF generation (POST /convert) — When a visitor submits a Contact Form 7 form (or a WooCommerce order is completed), the form field values and template key are sent to generate a PDF.
  4. Job polling (GET /jobs/{id}) — After PDF generation is requested, the plugin polls for the job status. Only the job ID is sent.
  5. Usage check (GET /usage) — When the administrator views the plugin settings page, the current month’s usage count is retrieved.

Amazon S3 (Amazon Web Services)

Generated PDF files and uploaded Excel templates are stored in Amazon S3, operated by the SheetPop service. The plugin does not communicate with Amazon S3 directly — all S3 interactions are handled server-side by the SheetPop API. Generated PDFs are automatically deleted after 24 hours.

By using this plugin, you agree to the SheetPop Terms of Service and Privacy Policy.

  1. Upload the sheetpop folder to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. Go to the SheetPop menu in the admin dashboard
  4. Register with your email to get a free API key (10 PDFs/month)
  5. Upload an Excel template
  6. Connect the template to your Contact Form 7 form
  7. Enable PDF generation for the form

Requirements:

  • WordPress 6.0 or higher
  • PHP 8.0 or higher
  • Contact Form 7 (optional, for form integration)
  • WooCommerce (optional, for invoice generation)
  1. SheetPop settings page

    SheetPop settings page

  2. Template management

    Template management

  3. Contact Form 7 integration

    Contact Form 7 integration

  4. PDF download link after form submission

    PDF download link after form submission

Do I need an API key?

Yes, an API key is required to use the PDF generation service. You can register for free directly from the plugin settings page.

Are any features locked or restricted?

No. All plugin features are fully available with the free API key. There are no premium-only features, no paid upgrades, and no locked functionality in this plugin. The external SheetPop API service includes 10 PDFs per month on the free tier. This is a usage quota on the external service, not a limitation of the plugin itself. Even when the quota is exceeded, form submissions continue to work normally — only the PDF attachment is skipped.

What Excel features are supported?

Basic formulas (SUM, AVERAGE, IF, VLOOKUP, etc.), cell formatting, borders, and images are supported. Macros (VBA) and pivot tables are not supported.

How do I create a template?

Create an Excel file (.xlsx) with placeholders in the format {{field_name}}. The field names should match your Contact Form 7 field names. Upload the template through the SheetPop settings page.

Why are macros not supported?

Macros are disabled for security reasons. The PDF generation runs on a secure cloud environment where macro execution could pose security risks.

How long are PDFs stored?

Generated PDFs are automatically deleted after 24 hours. Make sure to download important documents promptly.

Can I use this with WooCommerce?

Yes, SheetPop can automatically generate invoices when WooCommerce orders are completed. Upload a template named template_woo.xlsx with order-related placeholders.

What data is sent to the external service?

When generating a PDF, the form submission data and template file are sent to the SheetPop API. During registration, your email and site URL are sent. Generated PDFs are stored for 24 hours then automatically deleted. See our Privacy Policy for details.

What fonts are available?

The service includes Noto Sans JP and Noto Serif JP fonts for Japanese text. Most standard fonts are also supported with fallback rendering.

0.2.0

  • Added async PDF generation with job polling
  • Improved download UX with completion page
  • Added usage quota display
  • Enhanced error handling

0.1.0

  • Initial release
  • Contact Form 7 integration
  • WooCommerce invoice generation
  • Template upload and management
Back to top