SheetLink Forms for Google Sheets and Excel
| 开发者 | sheetlink |
|---|---|
| 更新时间 | 2026年9月29日 22:49 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.1 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
标签
下载
详情介绍:
- 12 form plugins, one screen - one plugin and one set of rules for every form on the site, instead of a separate connector per form builder
- Free and unlimited - no per-task fees, no entry caps, no account to create
- Local-first - rows go from your server to Google; your form data never passes through ours
- Nothing gets lost - a delivery log for every send and a retry queue that recovers failed ones
安装:
- 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.
- One of the 12 supported form plugins (listed under Supported form plugins above)
- 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?
You don't have to. Click "Connect Google" and SheetLink creates the sheet for you, or pick an existing one with Google's file picker; the header row is read from the sheet. If you prefer the classic method instead, click "Get Script" on a rule, paste the generated code into your sheet's Apps Script editor (Extensions > Apps Script) and 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 tick "Score incoming leads with AI" on the Lead Settings page (AI Lead Scoring, a hosted service), a scrubbed 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?
For form-to-spreadsheet delivery, yes. Zapier charges per task on a paid plan. 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 Fluent Forms, Formidable, Ninja Forms and the others?
Yes. All 12 supported form plugins work in the free plugin with the same rule editor, field mapping, delivery log and retry queue. Step-by-step guides for each are at sheetlinkwp.com/how-to.
Can I send WooCommerce orders to Google Sheets?
Yes, with WooCommerce Sync in the separate SheetLink Pro plugin. It pushes orders (created, completed, refunded), customers, and product catalogue changes (price, SKU, stock, status) to Google Sheets in real time. The free plugin covers form submissions.
How is SheetLink different from single-form connectors?
Most form-to-Sheets plugins handle one form builder, so a site with two builders needs two connectors. 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 plugin includes a network-admin overview of all subsites. The Agency Dashboard and bulk site management are part of the separate SheetLink Pro plugin on the Agency plan.
更新日志:
- Added: the one-click Google destination can write many rows in a single request. SheetLink Pro 1.1.2 uses it to import past entries in batches - several hundred entries a minute instead of about 25. New submissions are sent exactly as before, one row each. Rules that use Update Mode or send some rows to another tab keep writing one row at a time, because each row there needs its own decision.
- Fixed: the Lead Inbox's Google Sheet status sync (Lead Settings, "Keep each lead's status and owner in its row") never did anything. A lead was never linked to the row its submission landed on, the code that writes to that row was missing, and rows on different tabs could not be told apart. Now: when a submission is written to your one-click Google Sheet, its lead is linked to that row on that rule's tab; changing the lead's status or owner in the Lead Inbox writes it to the row, adding "Status" and "Assigned To" columns to the tab the first time if it does not have them.
- Changed: the switch for the status sync is no longer greyed out without a licence. Writing lead status to your sheet works on its own; edits made in the sheet come back to the lead with Two-Way Sync in SheetLink Pro 1.1.1.
- Changed: the Lead Inbox database gains one column (the sheet tab a lead's row is on). It is added automatically on update.
- Changed: on the one-click Google destination, a new tab now gets a Timestamp column when the rule has "Include timestamp column" ticked (the default), and every row fills it with the submission time. The box used to do nothing for one-click tabs, so rows carried no date. Tabs that already exist are not changed - their own header row still decides the columns - so to add dates to an existing tab, add a column headed "Timestamp".
- Added: the building blocks SheetLink Pro 1.1.0 uses for Import past entries - a way to deliver an entry your form plugin saved earlier through a rule, with its original date, without the alerts, conversions or Lead Inbox entry a new submission triggers, plus a place on each rule card for companion plugins to add a button. Nothing changes in this plugin on its own.
- Changed: sending a row and recording it in the Sync Log now share one definition of a successful delivery. No change in behaviour.
- Fixed: on the Connect Google page, a field mapping typed as the labels shown on the form ("Name", "Comment/Message") delivered a row of empty cells. WPForms, Gravity Forms and most other builders send fields under a generated key ("name", "comment-message"), and the mapping was looked up by exact key only - so every column came out blank, Google accepted the empty row, and the Sync Log showed a green HTTP 200. Send Test did not show it because its test row is keyed by the column names. A typed mapping is now matched to the submitted fields the same way routing and update mode already are: by key, or by the label as it appears on the form. If a typed entry matches nothing, the automatic name match fills that column instead of blanking it.
- Changed: the mapping boxes on the Connect Google page now say a field label or a field key both work.
- Fixed: the "Google Sheets - one-click" destination label ran into the Route column on the Dashboard, the Sync Log, the Retry Queue and Webhook Health tables. Badges in those tables now wrap inside their own column, the "(recommended)" hint is shown only in the destination dropdown where it belongs, and "one-click" no longer breaks across two lines.
- Changed: the plugin listing screenshots now show the current setup flow - the five-step guide, Connect Google, the three-field rule editor, the delivery log and the dashboard.
- Fixed: connecting a Microsoft 365 account for the Excel Online destination failed with "Could not verify the Microsoft connection bundle" on every site except our own test installs. The connection was signed with a shared secret that no customer site ever received. It is now signed with a key the plugin can verify on its own, the same way the one-click Google connection already works. No settings change is needed - open SheetLink -> Excel Online and click Connect Excel again.
- Fixed: on the Connect Google page, saving a rule's field mapping now pins the rule to the tab whose headings you mapped against. Before, a rule that had never delivered could be handed a brand-new tab seeded from the form's field keys on its first delivery, so the mapping form suddenly showed field keys instead of your headings and the rows never reached the tab shown as connected.
- Fixed: deleting a sync rule now clears the tab it had claimed on the one-click Google destination. A deleted rule's leftover entry used to keep the default tab "taken", which pushed its replacement rule onto a new tab.
- Fixed: on the one-click Google destination, the sheet's own header row is now the authority for columns. SheetLink reads row 1 of the tab when a sheet is chosen, when the settings are saved, and on each delivery - so a sheet you brought with your own headings, or one you reordered or renamed afterwards, gets every value under the right heading. Previously it wrote against a column list captured from the first submission and never looked at the sheet again.
- Added: "Re-read columns from the sheet" on the Connect Google page, per rule and for the default tab, for right after you change a header row.
- Fixed: saving a rule's field mapping on the Connect Google page wiped that rule's stored tab and columns, so the next submission could be written against a freshly guessed column list.
- Changed: the rule editor's Field Mapping (under Advanced options) now appears only for the manual Apps Script method. A one-click rule shows where its mapping actually lives instead - it was easy to fill in the wrong one and see no effect.
- Changed: one-click Google is now the default destination for a new rule and is listed first as "Google Sheets - one-click (recommended)". The manual method is still available as "Google Sheets - manual script (advanced)". Existing rules are not changed.
- Changed: the Apps Script fields (Receiver URL, the Get Script button, the re-deploy warning) now only appear on rules that use the manual method. One-click rules show their destination instead.
- Changed: the rule editor opens with just the essentials - name, form plugin, destination. Field mapping overrides, Update Mode, conditional routing and extra destinations sit under "Advanced options", which opens automatically when you edit a rule that uses them.
- Changed: the "Google Sheets (OAuth)" menu item is now "Connect Google", with an introduction written for people rather than developers.
- Added: the setup guide can be reopened - there is a Setup guide button on the Dashboard and in the empty Sync Rules screen. It used to run once after activation and could never be found again.
- Changed: Features page descriptions rewritten in plain language, with the technical detail folded under "How it works" on each card.
- Added: a sheetlink_rule_editor_after_source action under the Form plugin dropdown so companion plugins can explain a short list (SheetLink Pro 1.0.4 uses it).
- 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.