WordPress Forms to Google Sheets & Excel – SheetLink

변경이력

1.15.1

• Changed: Elementor columns now use your field labels. A field you added to an Elementor form arrived under a generated key, so a field labelled “phone” produced a column headed field_d9587fa. Elementor was the last integration needing manual mapping for this reason. What you will see: existing sheets gain new label-named columns, and data already collected stays in the old field_xxx columns – nothing is moved, renamed or deleted. If you would rather keep the old headings, map the fields explicitly on the rule. Only Elementor is affected.
• Fixed: accounts created through the WordPress REST API were never synced. Registration sync checked the new account’s role at the moment it was created, but the REST API assigns the role a fraction of a second later – so the check found no role and skipped the account. Affects headless sites, mobile apps and any API-driven signup; the admin form and WooCommerce checkout were never affected.
• Fixed: MemberPress signups delivered nothing at all – no row, no error, no queue entry. MemberPress completes a signup earlier in the page load than SheetLink starts listening, so the event fired before the plugin was ready and nothing was ever attempted. This affected every transaction on that path, free and paid alike, and the same timing could affect LearnDash and Easy Digital Downloads. SheetLink now starts listening before any of them can run.
• Fixed: Update Mode erased columns your submission did not include. Updating a matched row rewrote the whole row from the submission, so a notes column you added yourself, a column filled by another rule, or a field left empty on that particular submission were all blanked. Updates now only touch the columns the submission actually carried. Submitting a field empty still clears it.
• Fixed: Update Mode added duplicates instead of updating. Matching was case-sensitive, so “John@example.com” and “john@example.com” were treated as different people, and a key column holding dates or numbers never matched at all – producing exactly the duplicate rows the feature exists to prevent.
• Fixed: Duplicate Prevention silently overrode Update Mode. With both switched on and keyed on the same field – the natural way to keep one row per customer up to date – repeat submissions were filed as duplicates and the update never happened. Update Mode now takes precedence when both use the same key.
• Added: the delivery log now shows whether each delivery updated an existing row or added a new one, and warns when the key column is missing from your sheet – previously a rule that never once updated anything looked identical to one working perfectly.
• Added: WooCommerce order rows now carry the net amount and total refunded on every event, not just refunds. Note these are event rows – one order produces several – so totals need the latest row per order, or Update Mode keyed on order_id. The WooCommerce page explains this.
• Added: SheetLink now tells you when your site cannot send email. Most form plugins only show their success message once every action has finished, and their notification email is one of those actions – so on a site with no mail set up, visitors are told the submission failed while the row reaches your sheet perfectly, and they submit again. That is where most duplicate rows come from. Webhook Health now reports it, and says plainly that your SheetLink deliveries are unaffected.
• Fixed: a secondary destination could report a red cross for a delivery that actually arrived. Google Apps Script answers a successful write with a redirect, which the secondary path mistook for an error – so a working destination looked broken, and the row was in the sheet all along.
• Fixed: “Retry Now” on a secondary destination marked it dead instead of retrying it. One click took an item straight to “3/3 max retries” without contacting the destination at all.
• Fixed: “Last Error” showed the destination’s raw HTML error page instead of the error. A Google 404 filled the column with page markup while the retry of the same failure said “HTTP 404” – now both read the same, on primary and secondary deliveries alike.
• Fixed: a failed secondary delivery was never retried. It was recorded and then dropped, so a destination that was briefly unreachable lost the submission outright, with nothing in the retry queue. Secondary failures now queue and retry like primary ones.
• Fixed: Multi-Destination Routing saved nothing and delivered nothing. Adding a second destination to a rule reported success, then vanished when you reopened the rule, and submissions went only to the primary. Three separate faults, now all fixed – the destinations were never saved, the feature was switched off by an internal setting with no control anywhere, and only webhooks had any delivery code. Email and Slack destinations now work too, with Slack messages formatted for Slack.
• Fixed: saving a rule could quietly discard settings configured elsewhere. The rule was rebuilt from scratch on every save, so anything the rule editor did not know about – set by a vertical pack, another page, or a filter – was lost. Renaming a rule was enough to trigger it.
• Fixed: creating a product never produced a “Product created” row. Publishing a product from the WordPress editor was reported as an update instead, so a sheet or filter built on product creation stayed empty while the event was offered in the settings. Creating a product through the API always worked, and still does – it is not reported twice.
• Added: SheetLink checks your Apps Script as soon as the plugin updates, instead of waiting for the next hourly check. Without this, a site that upgrades and takes a submission straight away could lose data before being told the script needs redeploying.
• Added: a LearnDash “student enrolled” source. SheetLink could already sync course completions; enrolments now sync too, so a free course used as a lead magnet puts each new student in your sheet as they join. Covers both admin-side enrolment and front-end self-enrolment, and does not fire when you remove a student’s access.
• Changed: the LearnDash, MemberPress and Easy Digital Downloads sources now say which event they sync. Each listens for exactly one thing – a completed course, a completed transaction, a completed purchase – but the rule editor named only the plugin, so picking “LearnDash LMS” and then enrolling a student looked like a broken integration rather than the wrong event. They now read “LearnDash – course completed” and so on.
• Renamed in the interface: Role-Based Access is now Admin Menu Visibility. The feature hides SheetLink menus from other administrators; it cannot grant access to editors or authors, and the old name suggested otherwise.
• Added: SheetLink now warns you if Update Mode is on while your Google Apps Script is out of date – that combination empties columns your submission does not include, on every update, and nothing in the sheet records it. Webhook Health flags the affected rules and the dashboard shows a notice until it is resolved.
• Note for existing Google Apps Script users: the script has been updated. Webhook Health will tell you if yours is out of date – open your sheet, choose Extensions then Apps Script, replace the code with the current script, and deploy it as a new version of the existing deployment.

1.15.0

• Fixed: partial refunds never reached your sheet, leaving the total overstated. WooCommerce only marks an order “refunded” when it is refunded in full, so a partial refund changed nothing SheetLink was listening for – the row kept the original amount and nothing indicated it was wrong. Because full refunds do change the status, the gap only ever swallowed partial ones. Refund rows now arrive for both, and carry the refunded amount, the running total refunded, the net amount kept, and whether the refund was partial.
• Fixed: the Airtable field-mapping help said the opposite of what happens. It stated that unmapped form fields “pass through”, which is only true when the mapping is empty or you have ticked the option below it. With a mapping set, unmapped fields are not sent – so people saw columns arrive blank in Airtable while the same submission was complete in their Google Sheet, and read it as data loss. Both the Airtable and Notion pages now say how many fields are mapped and state plainly that the rest are left out.
• Fixed: White-Label left the SheetLink name in the page headings. The menu was renamed but the Dashboard and Sync Rules headings still read “SheetLink Forms”, so a client handed a rebranded site saw the real product name at the top of the first page they opened.
• Fixed: the Post Type / ACF sync source was hard to find and its setup link went to the wrong page. “Configure rule” opened the dashboard rather than the rule editor, and the source was labelled “ACF: …” even on sites without ACF, so people looking for a post-type source concluded there wasn’t one. It now reads “Post Type: …” when ACF is not installed, and the button opens the rule editor.
• Fixed: the Retry Queue counted deliveries that had used all their attempts as still “pending retry”. They are now reported separately as failed permanently, since nothing further will be attempted for them.
• Fixed: retrying a failed delivery used the old receiver URL, even after you corrected it. The retry queue stored the address at the moment of failure and never re-read the rule, so the fix Webhook Health tells you to make had no effect – you corrected the URL, pressed Retry, and watched the same deliveries fail until they hit the retry limit. Retries now use the rule’s current receiver.
• Fixed: saving a rule with a non-Google Receiver URL looked like nothing happened. The error was displayed at the top of the page, above the fold on a long rule editor, so the Save button appeared dead. The message now also appears beside the button and highlights the field.
• Fixed: the Features screen and upgrade prompts still quoted the old add-on prices. Individual monthly prices and an “Agency Growth” tier that no longer exists were shown in the plugin – including on the message you see when a delivery is refused for lacking an add-on, which is the worst possible place to quote a price nobody can pay. Everything now names the plan that includes the feature, matching sheetlinkwp.com/pricing.
• Renamed in the interface: CRM Fan-Out is now Multi-CRM Routing, and Advanced Routing is now Multi-Destination Routing, matching the names used on the website and in your licence. Nothing to reconfigure – settings, licences and rules are unaffected.
• Added: the Features screen now shows Form Abandonment’s live state – how many partial submissions are held and when they will be sent – because they are deliberately held until a visitor has been inactive for 30 minutes, and a feature you cannot see working is indistinguishable from one that is broken.
• Added: Analytics now says it starts counting from the moment you switch it on, instead of showing a page of zeros on a site that has been taking submissions all day.
• Fixed: Two-Way Sync was sending SheetLink’s own bookkeeping columns back into WordPress. If your sheet had ever been written to by an out-of-date Apps Script, that script added _sheetlink_ping, rule_id and ping_at columns to it – and every later edit sent those columns back as though you had typed them. Updating the script stops new junk rows but cannot remove columns already created, so this kept happening after the apparent fix. Those three are now filtered out on the way in. Your attribution columns and the WooCommerce event marker still come through, since they describe the row rather than SheetLink’s plumbing.
• Fixed: an out-of-date Google Apps Script could add a junk row to your sheet every hour, and the health check called it healthy. Older versions of the script do not recognise SheetLink’s hourly health check and treat it as a form submission, so they append a row to your sheet roughly 720 times a month. Webhook Health only looked at whether the script replied, not what it said, so it reported the rule as reachable throughout. It now identifies which version of the script your sheet is running and tells you plainly when the script is writing those rows, with the exact steps to replace it. If you copied our template sheet, you are likely affected – check SheetLink Forms -> Webhook Health.
• Changed: a visitor’s campaign is now credited for 30 days instead of 90. When someone arrives from an ad, SheetLink remembers the campaign so a form filled in later still credits the click that earned it. Ninety days meant a single click could be credited for every lead from that browser for three months, including ones that later arrived from search or typed your address in directly – which quietly overstates what your ads produced. Thirty days matches Google Ads’ own default. Sites with long sales cycles can raise it (up to Google’s 90-day limit) with the sheetlink_attribution_ttl_days filter.
• Changed: on opt-in sites, click IDs and campaign data are now only recorded for visitors who accept marketing cookies. If your consent plugin is set to opt-in (the default in the EU and UK), a visitor who declines – or who has not answered the banner yet – now has their submission saved without attribution. Their click ID would otherwise have been written to your sheet and uploaded to Google as an offline conversion for advertising measurement they did not agree to. Expect fewer attributed conversions than leads on these sites: this is the change causing it, not a fault. Sites set to opt-out are unaffected except that an explicit refusal is now honoured, and sites with no consent plugin are unaffected entirely. Both behaviours are available via the sheetlink_attribution_consent filter, and the Conversions screen states which rule is in force on your site.
• Note for sites using a page cache: consent is now checked in the visitor’s own browser rather than trusted from the page HTML. This matters because caches share one stored copy across visitors, and often across query strings too – with W3TC’s “Cache URI with query string variables” enabled, a request for one campaign URL is served the copy generated for a different one. Without this, a page first generated for a visitor who had accepted could have caused the next visitor to be treated as having accepted as well.
• Added: campaign tracking now respects your cookie consent banner. If your site runs a consent plugin that supports the WordPress Consent API, the campaign cookie is only stored for visitors who accept marketing cookies, and it waits if they answer after the page loads. Sites with no consent plugin are unaffected and keep working exactly as before. Tracking parameters on the link a visitor actually clicked are still recorded either way – the consent step covers storing their campaign for later, not the link they arrived on. The Dashboard says which of these applies to your site.
• Fixed: UTM and click-ID attribution now reaches your sheet on the one-click Google connection. Visitor source was always captured and sent, but this connection method never created columns for it, so it was written nowhere – while the classic Apps Script method had always recorded it. A submission that arrives with utm_source, gclid and the rest now gets those columns, added only when a visit actually carries them, so a sheet never fills with empty attribution headers. If your sheet’s header was already fixed before this release, the columns are appended the next time a submission carries them.
• Fixed: choosing a Google Sheet did not stick. Creating or picking a sheet only filled in the form on screen – the choice was not saved until you pressed Save, and the next step in setup (creating a rule) navigated away first. The page then said “No sheet chosen yet” even though the spreadsheet existed in your Drive, and you had to pick it again. Creating or picking a sheet now saves it immediately.
• Fixed: saving the Google Sheets screen can no longer blank the destination sheet.
• Fixed: finishing setup the one-click way now counts as finishing setup. Only the wizard’s own last step marked a site as set up, and the one-click route deliberately ends on the Google Sheets screen instead – so a fully configured site stayed flagged as never-set-up, and the first-run wizard could reappear after an unrelated deactivate and reactivate months later. Creating a rule against a connected sheet now completes setup, whichever route you took to get there.
• Improved: the one-click Google route no longer loses your answers. It finishes on the Google Sheets screen rather than in the wizard, and now carries your form plugin and rule name with it, pre-filled, with a note explaining where you are. Previously both were discarded and you retyped them.
• Improved: the welcome screen described the manual Apps Script route as the only path. It now leads with one-click Google, with Apps Script as the optional alternative it actually is – and the progress step is labelled “Connect Google” rather than “Google Script”.
• Added: the Lead Inbox is now part of SheetLink Forms. Every submission becomes a lead you can own, answer and qualify – including the ones that never reached your sheet – with a response-time clock, notes, assignment and reports. It was previously a separate plugin; it is now built in, like every other add-on, and appears under SheetLink Forms when your licence includes it.
• If you installed the separate “SheetLink Lead Inbox” plugin, nothing breaks: SheetLink Forms leaves it in charge while it is active, and you can deactivate and delete it whenever you like. Your leads, notes and settings live in the same place either way and are not touched.
• Note on removal: deleting SheetLink Forms does not delete your leads. They are your records of real people you have spoken to, so they are kept unless you explicitly opt into deletion.

1.14.9

• Added: a way past “Approval required” when connecting Excel Online. Many Microsoft 365 organizations require an administrator to approve an app before anyone can connect it, so business users saw an approval wall instead of a sign-in screen with nothing on this end to do about it. The Excel Online page now provides a link you can send to whoever administers your Microsoft 365 tenant: they approve SheetLink Forms once for the whole organization, and everyone connects normally after that. They need no SheetLink licence and no login on your site.
• Improved: if Microsoft blocks the connection for that reason, the page you land on now explains why and carries the same link, instead of only saying sign-in did not complete.

1.14.8

• Renamed: the Multi-Node Routing add-on is now Multi-Destination Routing. Same add-on, same price, same settings – the new name says what it does: route one submission to several destinations with priority order and fallback webhooks. Nothing to reconfigure; existing licences and rules are unaffected.
• Improvement: the license key field no longer names a specific key format. Keys are validated by the licensing service, so paste whatever key your purchase email delivered.
• Documentation: clarified an internal code comment in the Excel destination about where the license gate is enforced.

1.14.7

• Security: the Two-Way Sync page displayed a live credential in plain text. The page printed the sync secret that authorises incoming sheet updates, so anyone who saw the screen – a screenshot, a support ticket, a screen-share – could post fabricated row updates to your site. It is no longer rendered; an administrator can reveal it on demand instead. If you have ever shared a screenshot of that page, contact support to reissue your licence key, which changes the secret.
• Fixed: “Recent incoming updates” said “No updates received yet” forever if you use the Google connection. Only the Apps Script route wrote to that table. Sites using the one-click Google connection were syncing edits correctly the whole time, but the page gave no evidence of it, so a working setup looked broken. Entries now record which mechanism delivered them and the table shows it.
• Improved: the Two-Way Sync page now describes the mechanism your site actually uses. If Google is connected it reports that the sync is active, how often it checks, when it last read the sheet, and when it will check next – and it is honest that WordPress cron only runs when someone visits the site, so a quiet site checks less often than the interval suggests. The Apps Script instructions are demoted to “not needed on this site” rather than presented as the setup path.
• Improved: a site with an active licence but no Two-Way Sync add-on now says so. Previously only a missing licence warned, so an unentitled site looked correctly configured while every incoming edit was rejected.
• Added: a warning against running the Apps Script and the Google connection on the same sheet. Both deliver to the same place, and with both live an edit can be applied twice.

1.14.6

• Improved: the setup wizard no longer walks you through an Apps Script you do not need. If you have already connected Google with one click, the “Google Script” step is gone and the remaining steps renumber – previously the wizard asked you to deploy a script and then told you on the very next screen that there was nothing else to set up.

1.14.5

• Fixed: “Fields: 0” again, this time on Send Test. The 1.14.4 fix only reached the path a real form submission takes; Send Test still reported zero. Since Send Test is how most people confirm a rule works, that was the number most people saw.

1.14.4

• Fixed: the Sync Log said “Fields: 0” on deliveries that wrote several columns. Since 1.14.0 you no longer type column names, so the count had nothing left to count and reported zero. It now reports what was actually written to the row.
• Improved: Send Test now confirms itself next to the button. The confirmation only appeared at the top of the page, so on a long list of rules a successful test could look like nothing happened – and a retried test writes another real row to your spreadsheet.

1.14.3

• Fixed: Send Test never tested the Excel mirror. It ran and reported the Airtable and Notion mirrors but skipped Excel entirely – no notice, no Sync Log row, no row in your workbook – so a working Excel mirror and a broken one looked exactly the same. Excel is now included, and reports like the others.
• Fixed: an Excel mirror that is switched on but not finished being set up now says so. It used to skip in silence, which looked identical to having no Excel mirror at all.
• Fixed: the workbook picker could come up empty on a brand-new Microsoft 365 account. Microsoft’s file search needs time to index a newly created OneDrive and returns an error until it has; SheetLink now falls back to listing the files in your OneDrive so you can pick a workbook straight away.

1.14.2

• Fixed: checkboxes that could not be switched off. Unticking a WooCommerce event, or a conditional routing rule, appeared to save and then came back ticked. The browser sent the right value; it was misread on arrival, so the setting was always stored as enabled. Anything you had tried to switch off has been running all along.
• Fixed: opening the WooCommerce screen and pressing Save switched on all six event types, whether or not you ticked them. Events left enabled with no Receiver URL are switched off automatically on update, since they could never have sent anything. An enabled event that has a URL is left exactly as it is.

1.14.1

• Fixed: the setup wizard could not be opened at all. Every visit to it returned “Sorry, you are not allowed to access this page”, including the automatic redirect a new site is sent through immediately after activating the plugin. The page was registered under the main SheetLink menu and then hidden from the sidebar, which left WordPress unable to resolve it. Present since 1.9.4.
• Fixed: the one-click Google route could not finish the wizard. After connecting a Google account, the last step still demanded an Apps Script “Receiver URL” and refused to save without one, so anyone taking the one-click route left the wizard with no sync rule and nothing was ever delivered. That step now recognises the connection, and the Apps Script field is hidden entirely rather than shown and ignored.
• Fixed: an empty Receiver URL on the classic Apps Script route reported that the address “does not look like” a valid URL, when nothing had been typed. It now says what to do instead, including the one-click option.
• Fixed: the wizard’s own stylesheet, script and documentation link stopped loading when the page moved.

1.14.0

• Fixed: Google Sheets deliveries failed with “No form fields are mapped” for most form plugins. SheetLink matched your sheet’s column headers against each form field’s internal key, and several plugins use generated keys – Formidable emits things like kzn0j, Ninja Forms name_1512... – so a column called “Email” matched nothing and the row was never written. Columns are now matched on the field’s label as well, which is what you actually name your columns after. Gravity Forms and WPForms were unaffected because they happen to key by the label already.
• Added: you no longer type column names. Connect a spreadsheet, point a form at it, and the first submission writes the header row for you, taken from that form’s own fields. Existing setups are untouched – if you have already configured columns, they keep being used.
• Added: each form now gets its own tab. A tab has a single header row, so two forms with different fields could never share one – the second form’s answers landed under the first form’s columns. Your first rule keeps using the tab you picked; any additional form gets its own, named after the rule.
• Added: the Google Sheets screen now tells you when a connected spreadsheet has no form pointed at it, and lets you create that rule right there. Connecting a sheet writes its header row, which looked finished while nothing was actually being sent.
• Improvement: seeded column headers use readable labels (“First Name”) rather than internal names (“names.first_name”, “name-1”) for Formidable, Ninja Forms, Forminator, Everest Forms, Fluent Forms, WPForms, WS Form and Divi.

1.13.1

• Change: the plugin now contacts sheetlinkwp.com for licence activation and entitlement checks, instead of siteanswerai.com – a legacy domain the API happened to be hosted under. Nothing to do on your side, and older installs keep working because the old address forwards to the new one. If you listed siteanswerai.com as a data processor in your privacy notice, update it to sheetlinkwp.com.
• Change: the Primary Destinations add-on (previously “Excel Primary Destination”) now covers Excel Online, Airtable and Notion. One add-on for all three. If you already own Excel Primary, your existing licence unlocks the other two at no extra cost – nothing to do.
• Removed: a long-unreachable legacy Airtable/Notion delivery path inside the Integrations Bundle. It could not be configured from any shipped rule editor, and Airtable and Notion have been free built-in destinations with proper per-rule field mapping since 1.9.4. If a rule from a very old build still references it, an admin notice now points you to the built-in destination instead of the delivery failing quietly.
• Improvement: corrected pricing and add-on descriptions that implied Airtable and Notion were part of the paid Integrations Bundle. They are free core destinations; only using one as your sole destination is paid.

1.13.0

• Security: stored API tokens are no longer written into the settings page’s HTML. The Airtable, Notion, Meta CAPI and SMS (Twilio) screens pre-filled their credential field with the saved token. The browser masked it visually, but it sat in the page source in cleartext – readable by anyone who can view source on that screen, by browser extensions, and by anything that captures the page. The field now renders empty with a masked “Currently set” hint: leave it blank to keep the stored token, or tick Remove the stored value to delete it. If you have entered an API token on any of those screens, consider rotating it.
• New: Airtable and Notion can now be a rule’s primary destination. Previously they could only mirror a successful Google Sheets delivery, which meant you had to set up a Google Sheet you did not want – and if that Sheets delivery ever failed, the Airtable write never happened either. A rule can now deliver straight to Airtable or Notion with no Google Sheets configuration at all. Pick it from the Primary destination dropdown in the rule editor. Requires the Primary Destinations add-on, which covers all three; the free Airtable, Notion and Excel mirror modes are unchanged and stay free.
• New: primary deliveries to Airtable and Notion use the full delivery pipeline – the automatic retry queue (throttling and provider outages retry; a bad token or unknown column does not, because retrying cannot fix those), save-time validation of your credentials, and destination-aware health checks. Mirror deliveries never had retries.
• Fix: failed deliveries to Excel, Airtable and Notion logged a blank error. The Sync Log recorded the correct status and HTTP code but discarded the …