SheetLink Forms for Google Sheets and Excel
| 开发者 | sheetlink |
|---|---|
| 更新时间 | 2026年9月1日 23:35 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.1 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
标签
下载
详情介绍:
安装:
- In your WordPress admin, go to Plugins → Add New.
- Search for "SheetLink Forms".
- Click Install Now, then Activate.
- The setup wizard opens automatically and walks you through connecting your first form to Google Sheets in about three minutes.
- Download the
sheetlink-forms.zipfile. - In WordPress, go to Plugins → Add New → Upload Plugin and upload the zip, or extract it into
/wp-content/plugins/sheetlink-forms/. - Activate the plugin from the Plugins menu.
- The setup wizard opens automatically. If you dismissed it, visit SheetLink in the admin menu and click + Add Rule to configure your first sync rule manually.
- A WordPress form plugin (Elementor Pro, Contact Form 7, Gravity Forms, WPForms, Fluent Forms, Formidable, Ninja Forms, Forminator, Everest Forms, Beaver Builder, Divi, or WS Form)
- A Google account with access to Google Sheets
- About three minutes
屏幕截图:
常见问题:
How do I send Contact Form 7 submissions to Google Sheets?
Install SheetLink Forms, create a sync rule, choose your Contact Form 7 form, connect Google, and map the form fields to spreadsheet columns. New submissions are added as rows automatically. Step-by-step guide: Connect Contact Form 7 to Google Sheets.
Can I connect WPForms Lite to Google Sheets for free?
Yes. Both WPForms Lite and WPForms Pro are supported, and the free SheetLink plugin sends unlimited WPForms submissions to Google Sheets. Step-by-step guide: Connect WPForms to Google Sheets.
How do I connect Elementor Forms to Google Sheets?
Create a sync rule, select your Elementor Pro form, connect or pick a Google Sheet, and map each Elementor field to a column. Step-by-step guide: Connect Elementor Forms to Google Sheets.
Does SheetLink support Gravity Forms to Google Sheets?
Yes. Gravity Forms entries go to Google Sheets in real time, with custom field mapping, delivery logs, and automatic retries. Step-by-step guide: Connect Gravity Forms to Google Sheets.
Can WordPress forms send entries to Excel Online?
Yes. SheetLink mirrors submissions into an Excel Online workbook on Microsoft 365 or OneDrive for free, alongside your Google Sheet. Making Excel a rule's only destination is a feature of the separate SheetLink Pro plugin. Note that Microsoft's Excel API supports business accounts only - personal Outlook.com OneDrive is not supported by Microsoft for this. Step-by-step guide: WordPress forms to Microsoft 365.
Do I need to create an account or register?
No. SheetLink Forms works immediately after installation. No account, no registration, no license key required.
Do I have to paste an Apps Script into my sheet?
Not anymore. Connect your Google account in one click and SheetLink writes rows through Google's official Sheets API - it can create the sheet for you, or you pick an existing one with Google's own file picker. The classic Apps Script method remains fully supported for users who prefer a zero-account, script-only setup; both are free.
Do I need a Zapier account?
No. SheetLink Forms sends data directly from WordPress to Google Sheets - through your one-click connected Google account or via a free Google Apps Script. No third-party services needed.
Does the plugin call home or track anything?
No telemetry, no analytics beacons, no activation pings. On a default install, form submissions go only to the Google destination you configured - never through SheetLink's servers. If you use the one-click Google or Microsoft connection, the sign-in handshake and periodic token renewal go through SheetLink's OAuth broker at sheetlinkwp.com; your form data never does. Several optional features, each off until you configure it, do send submission data elsewhere: the Excel Online, Airtable and Notion destinations send it to Microsoft, Airtable and Notion respectively; SMS Alerts sends your alert text to Twilio; Meta Conversions API sends a hashed conversion event to Meta; and three optional hosted features route data through SheetLink's own servers - AI Lead Scoring, AI Analytics extras, and the Lead Inbox client portal. See the "External services" section below, which documents every one of them individually.
What does AI Lead Scoring remove from a lead before sending it?
Names and phone numbers are replaced with the placeholder "provided", email addresses are reduced to their domain, and any email address or phone number typed into a free-text answer is redacted in place. Free-text answers are otherwise sent as written, since that is what the rating is based on. The form identifier, the source form plugin name, the site URL and WordPress user account data are never sent.
How are my Google and Microsoft tokens stored?
Refresh tokens are encrypted with AES-256-GCM (key derived from your site's wp_salt( 'auth' ) via HKDF) before being written to your own database, and are cleared the moment you disconnect. Access tokens are short-lived (about an hour). Nothing is stored on SheetLink's servers beyond what the OAuth broker needs to complete the handshake.
Do I need to update my privacy notice when I enable these features?
If your forms collect personal data: with the one-click Google or Excel connection, list googleapis.com or graph.microsoft.com (and sheetlinkwp.com for the sign-in broker) as processors. With AI Lead Scoring, AI Analytics extras or the Lead Inbox portal, list sheetlinkwp.com as a processor - the portal transfers lead contact details in plain text, so satisfy yourself that you have a lawful basis first. Meta Conversions API shares an IP address and hashed contact details with Meta for ad measurement, which in the EU/UK and similar jurisdictions normally requires disclosure and consent - list Meta as a recipient and obtain consent where your local law requires it before enabling it.
Which form plugins are supported?
Elementor Pro Forms, Contact Form 7, Gravity Forms, WPForms, Fluent Forms, Formidable Forms, Ninja Forms, Forminator, Everest Forms, Beaver Builder, Divi, and WS Form.
How do I set up the Google Sheet?
SheetLink Forms generates the Google Apps Script for you. Click "Get Script" on any rule, copy the code, and paste it into your Google Sheet's Apps Script editor (Extensions > Apps Script). Then deploy it as a web app.
Can I send different forms to different sheets?
Yes. Create multiple sync rules, each pointing to a different Google Sheet (a different connected sheet, or a different Apps Script URL with the classic method).
Is my data secure?
Form submission data is sent directly from your WordPress server to Google over HTTPS: to sheets.googleapis.com (Google's official Sheets API) when you use the one-click connection, or to the Google Apps Script URL you configure with the classic method (only script.google.com and script.googleusercontent.com URLs are allowed as receivers). It never passes through SheetLink's servers. If - and only if - you enable the optional Lead Scoring add-on on the Analytics page, a copy of each submission is also sent over HTTPS to https://sheetlinkwp.com/api/sheetlinkwp/lead-score. Every other feature of the plugin runs locally on your WordPress server.
What happens if the Google Sheet is unavailable?
The submission is logged as failed and automatically retried up to 3 times (every 15 minutes). You can also retry manually from the Retry Queue page.
Is SheetLink a free Zapier alternative?
Yes. Zapier's base plan starts around $20/month and charges per task. SheetLink delivers unlimited form submissions from your WordPress site directly to Google Sheets at no cost - no per-task fees, no subscription, no registration. You own the entire pipeline.
Does SheetLink work with WPForms?
Yes. WPForms is fully supported in the free core, both Pro and Lite. Every submission is mapped to your chosen Google Sheet with the fields you select.
Does SheetLink work with Elementor Pro forms?
Yes. Elementor Pro Forms are fully supported in the free core. Create a sync rule, map fields, connect Google in one click (or paste the generated Apps Script) - done.
Does SheetLink work with Fluent Forms?
Yes. Fluent Forms is fully supported in the free core, along with 11 other form plugins (Contact Form 7, WPForms, Gravity Forms, Elementor Pro, Formidable, Ninja Forms, Forminator, Everest Forms, Beaver Builder, Divi, WS Form).
Can I send WooCommerce orders to Google Sheets?
Yes, with the WooCommerce Sync add-on. It pushes orders (created, completed, refunded), customers, and product catalogue changes (price, SKU, stock, status) to Google Sheets in real time. This is a premium feature; the free core covers form submissions.
How is SheetLink different from GSheetConnector and other single-form plugins?
Most CF7-to-Sheets or form-to-Sheets plugins handle one form type. SheetLink supports 12 form plugins from a single admin interface, includes an automatic retry queue that recovers failed deliveries, captures UTM and click-ID parameters for marketing attribution, runs local analytics on your own WordPress database, and ships a guided setup wizard that takes new installs from zero to a working Google Sheet in about three minutes.
Does SheetLink work with WordPress Multisite?
Yes. The free core includes a network-admin overview of all subsites. Multisite-wide central management and the Agency Dashboard are available in the Agency Plus tier.
更新日志:
- Fixed: on the one-click Google (OAuth) destination - the default connection method - Duplicate Prevention's reroute tab and conditional routing's resolved tab were ignored, so rows always landed on the rule's main tab. Both are now honoured, matching the classic Apps Script path.
- Fixed: Duplicate Prevention's suppress mode never suppressed duplicates on the one-click Google destination.
- Fixed: routing conditions, Duplicate Prevention keys and Update Mode keys now match field names the way your form plugin actually emits them (exact key, normalized key, or field label). Previously a key typed the way the form displays it could silently match nothing - and Update Mode quietly appended new rows instead of updating.
- Fixed: saving a rule whose id no longer exists now reports an error instead of reporting success and silently discarding what you typed.
- Fixed: duplicate submissions suppressed by Duplicate Prevention are now labelled distinctly in the Sync Log instead of appearing as ordinary successful deliveries.
- Changed: the Retry Queue page no longer claims every submission was delivered when the queue is empty - it reports only what the queue can vouch for, and links to recent non-retryable failures in the Sync Log.
- Changed: every paid feature has moved into SheetLink Pro, a separate plugin downloaded from sheetlinkwp.com. This plugin now contains no locked or licence-gated functionality, in line with the WordPress.org plugin guidelines. Advanced Routing, White-Label, Branded Reports, Agency Dashboard, Role Access, WooCommerce Sync, Extra Integrations, Multi-CRM Routing, Two-Way Sync and Bulk Site Management all live in SheetLink Pro now. If you have a licence and used any of these, install SheetLink Pro and everything comes back exactly as it was - same settings, same licence key, nothing to reconfigure. A notice with a download link appears in your admin after updating.
- Changed: choosing Excel Online, Airtable or Notion as a rule's ONLY destination is now offered by SheetLink Pro. The free mirrors to all three destinations are unchanged, and any existing rule already set up that way keeps delivering.
- Changed: the Features page now lists this plugin's own (all free) features; SheetLink Pro adds its cards to the same page when installed.
- Changed: readme rewritten - every external service the plugin can contact is now documented individually under "External services", with what is sent, when, and links to each provider's terms and privacy policy.
- Fixed: a number of request values (credentials, field mappings, phone numbers, template and recipient fields) are now sanitized at the moment they are read, not only when used. Partial form-abandonment payloads and network templates are sanitized recursively after decoding.
- Changed: changelog entries older than 1.16.0 moved to changelog.txt, bundled with the plugin.
- Tested up to WordPress 7.1.
- Changed: the plugin's display name is now "SheetLink Forms for Google Sheets and Excel" in both the readme and the plugin header, so the two match and the name leads with the plugin's own brand rather than a trademark.
- Changed: the readme description has been shortened. It was long enough to be trimmed when the directory parsed it, which meant part of it was never displayed.
- Changed: changelog entries older than 1.14.8 moved to changelog.txt, bundled with the plugin. No functional change.
- Fixed: five places where a value was printed into admin HTML or a digest email without escaping, including the white-label name and accent colour.
- Fixed: failed deliveries to Meta CAPI, Twilio SMS and Excel wrote the provider's error message or response body to the PHP error log on every failure, in production. Those can carry the request URL and its credentials, or the submitted lead's own details. Now logged only under WP_DEBUG, and only the status - matching what the Airtable and Notion destinations already did.
- Added: the Lead Inbox now actually fills up. The Leads, Lead Settings and Lead Reports screens arrived in 1.15.0, and nothing ever appeared in them, because SheetLink never announced a submission for them to record. Every submission now becomes a lead - including submissions that match no sync rule at all, and ones whose delivery fails, which are exactly the enquiries that used to vanish without trace. Existing leads are unaffected; capture starts from this update.
- Added: AI Lead Scoring, working end to end. Each new lead is rated 0-100 with a hot / warm / cold band and a one-line explanation of the rating, shown in the Leads list, on the lead itself, and in the CSV export. You can sort the list by score. Off until you switch it on in Lead Settings, and it only ever scores leads captured after you do - it will not work through your back catalogue or spend your monthly allowance on old enquiries.
- Added: contact details are removed before anything is sent for scoring. Names and phone numbers are replaced with a placeholder, email addresses are reduced to their domain (so "works at a company" survives but the person does not), and an email address or phone number typed into a message is redacted in place. The rating quality is unaffected - scoring reads intent, not identity.
- Added: a Setup item in the SheetLink menu, so the setup guide is always one click away. Activating the plugin already takes you straight into it, but that only happens once - and it is skipped entirely if you activate several plugins together, install over WP-CLI, or switch SheetLink off and back on. Anyone who missed that first-run screen previously had no way back to it.
- Added: delivery outcomes now attach to the lead, including recovery. A delivery that failed and then succeeded on a later retry used to read as "failed" on that lead forever, even though the row was sitting in your sheet. The lead now shows it recovered, and its history says when.
- Changed: AI scoring is switched on in Lead Settings. It was previously only offered on the Analytics page, which does not exist unless you have separately enabled the free Local Analytics feature - so a customer whose plan included scoring had no way to reach the switch. The Analytics page now shows whether AI consent is on and links to it.
- Changed: scoring and the AI extras use your existing licence, not a second token. The "API Token" field on the Analytics page is gone. It asked you to paste in a value SheetLink already had, and leaving it blank silently disabled features you were paying for.
- Fixed: uninstalling left settings behind in your database. Sixteen options survived a full uninstall, including a stored Google Sheets two-way state, every Lead Inbox setting, and cached diagnostics. Deleting the plugin now removes them. Your captured leads are still kept on purpose - removing a plugin should not delete the enquiries you collected, so the three lead tables are only dropped if you explicitly ask for that.
- Fixed: hidden
_sheetlink_idcolumn groundwork for linking a spreadsheet row back to its lead. It is only sent to sheets whose Apps Script is current, so nothing appears in your existing sheets and no redeploy is required; if you do update your script it arrives hidden.