Collect WordPress Form Leads Into Microsoft 365
Your business runs on Microsoft 365. Your website runs on WordPress. SheetLink connects the two: every form submission lands as a row in an Excel Online workbook in your own OneDrive - where the policies your organization already relies on apply.
TL;DR
SheetLinkWP delivers WordPress form submissions in real time to a live Excel Online workbook in your own Microsoft account via Microsoft Graph. Submission payloads travel from your WordPress server to Microsoft Graph - they are not parked in a third-party form silo. Mirroring into Excel alongside Google Sheets is included free; using Excel as your only destination requires the AI Pack (which includes Primary Destinations) at $29/month. No Power Automate flows, no per-submission task fees, no CSV exports.
Most guides for getting website leads into Excel assume one of three things: you will export CSVs by hand, you will build and babysit a Power Automate flow, or you will pay Zapier per submission. For a business that standardized on Microsoft 365 - which is most regulated and mid-sized businesses - none of those is satisfying, because the actual requirement is simple: a lead submitted on the website should appear in a workbook the team already uses, inside the environment IT already governs. That is exactly what SheetLinkWP does. This guide covers the setup, what the architecture means for data governance, and how it compares to the usual alternatives.
Why Microsoft-Shop Businesses Want Leads in Their Own Tenant
Law firms, financial advisories, insurance brokers, clinics, and contractors overwhelmingly run Microsoft 365, often specifically because of its governance stack: data loss prevention, retention policies, sensitivity labels, and audit visibility. The irony is that the website lead form - frequently the least governed data path in the company - collects names, emails, phone numbers, and case details, then leaves them in a form plugin's database table or a third-party form service where none of those controls apply. Delivering submissions into an Excel Online workbook in your own OneDrive changes that: the workbook is ordinary tenant content, so whatever retention, DLP, and access policies your organization applies to files apply to your leads automatically. SheetLink does not add governance features of its own - it simply puts the data where your existing ones already operate.
The Architecture: WordPress Straight to Microsoft Graph
SheetLinkWP is a WordPress plugin, not a hosted form service, and that distinction matters for where your data travels:
- Capture on your server: SheetLink hooks into your form plugin's submission event server-side - all 12 supported form builders, from Contact Form 7 to WS Form. The submission never needs a third-party form endpoint.
- Delivery via Microsoft Graph: Your WordPress server writes the row directly to the Microsoft Graph API, which appends it to a live Excel Online workbook in your OneDrive. This is not a CSV export or a file upload - it is the same API Microsoft's own applications use, and the row is visible in Excel on the web or desktop within seconds.
- The OAuth broker's narrow role: SheetLink's hosted broker maintains the Microsoft OAuth connection so you do not have to register an Azure app. Refresh tokens are encrypted at rest. Submission payloads do not route through the broker - they travel from your WordPress server to Microsoft Graph.
- Retry protection: If Microsoft Graph is briefly unreachable, the submission queues locally on your site and retries automatically - 3 attempts at 15-minute intervals, plus manual replay from the Retry Queue page. A transient outage does not silently cost you a lead.
What You Need
- A WordPress site with any of the 12 supported form plugins (Contact Form 7, WPForms, Gravity Forms, Elementor Forms, Fluent Forms, Formidable, Ninja Forms, Forminator, Everest Forms, Beaver Builder, Divi, or WS Form)
- The free SheetLinkWP core plugin
- A Microsoft 365 work or school account (personal Outlook.com accounts are not supported by Microsoft's Excel API)
- The AI Pack ($29/month or $290/year), which includes Primary Destinations, only if Excel will be your sole destination with no Google Sheet involved
Step-by-Step Setup
- 1
Install SheetLinkWP
Install the plugin from WordPress.org or sheetlinkwp.com and activate it. Your form plugin is detected automatically.
- 2
Connect your Microsoft account
In SheetLink's settings, choose Excel Online as a destination and click Connect Microsoft. Approve the OAuth consent screen with the Microsoft 365 account that owns the workbook. Use a role account (for example leads@yourfirm.com) rather than a personal login if the workbook should outlive any one employee.
- 3
Pick the workbook
Choose the OneDrive workbook that should receive submissions. Keeping lead data in a dedicated workbook makes it easy to scope sharing and retention precisely.
- 4
Map your form fields
Under SheetLink -> Sync Rules, pick your form as the source and map each field to a column. Attribution fields - utm_source, utm_campaign, gclid, fbclid, msclkid - can be mapped like any other column and are captured automatically.
- 5
Send a test submission
Submit the form on your site and watch the row appear in Excel Online within seconds. Check the delivery log in SheetLink's admin to see the delivery recorded.
- 6
Decide on mirroring vs Excel-only
If your team also uses Google Sheets, mirroring the same submission to both destinations is included with the core license. If Excel is your only destination, enable the Primary Destinations add-on - no Google account is ever involved.
Real-World Use Cases
A clinic collecting patient inquiry forms
A dental or medical practice on Microsoft 365 wants website inquiries in a spreadsheet the front desk works from - without introducing a new vendor that touches patient-adjacent data. With SheetLink, submissions flow from the practice's own WordPress server into a workbook in the practice's own OneDrive. Microsoft offers HIPAA/HITECH business associate commitments for Microsoft 365 commercial plans (per Microsoft's own documentation), which is a conversation for your compliance advisor - but architecturally, the lead path adds no new data silo.
A financial advisory firm with quote-request forms
Firms subject to records-retention and supervision rules often chose Microsoft 365 precisely for retention policies and audit visibility. Delivering quote requests into a tenant workbook means the leads inherit the same retention schedule as every other business record - instead of living indefinitely in a form plugin's database table nobody audits.
A contractor running bid-request forms
Construction and trades businesses live in Excel. Bid requests land as rows the estimator can sort, filter, and price the same morning - and a Power BI report pointed at the workbook turns the same table into a live pipeline dashboard for the owner.
Advanced Tips
Point Power BI at the workbook
Power BI reads Excel tables in OneDrive natively. Once SheetLink is appending rows, a report built on that table gives you leads-by-source and leads-by-week visuals that refresh without anyone exporting anything.
Map the attribution columns on day one
utm_source, utm_campaign, gclid, fbclid, and msclkid are captured automatically - but only appear in Excel if you map columns for them. Mapping them from the start means the ad-spend conversation is a pivot table away.
Share the workbook, not copies of it
The point of delivering into the tenant is that access is governed. Resist the habit of emailing lead-list copies around - share the OneDrive workbook with exactly the people who work leads, and let versioning and access policy do their jobs.
Use a dedicated workbook per site or campaign
SheetLink sync rules can route different forms to different workbooks. Keeping the contact form, careers form, and campaign landing pages in separate workbooks keeps sharing scopes clean.
Troubleshooting
Rows stopped appearing and the log shows authentication errors
The Microsoft connection can be revoked by an admin or a password/security change. Reconnect from SheetLink's destination settings - the broker refreshes tokens automatically in normal operation, so a hard failure usually means the grant itself was revoked.
A submission is missing from the workbook
Check the Retry Queue page first. If Microsoft Graph was briefly unreachable, the submission is queued and will retry automatically; you can also replay it manually. Nothing is dropped silently.
Rows land in the wrong workbook or sheet
Each sync rule pins a specific workbook. Edit the rule and re-pick the destination - and if you renamed or moved the workbook in OneDrive, re-select it so the rule points at the right file.
The Microsoft login works but the workbook picker is empty
Confirm you signed in with the account that owns the OneDrive where the workbook lives. If you signed in with a personal Outlook.com account, that is the cause: Microsoft's Excel API only supports workbooks stored in OneDrive for Business, SharePoint or Group drives, so a personal account can connect and still show nothing.
Getting WordPress Leads Into Microsoft 365: the Options
| Feature | Microsoft Forms | Power Automate | SheetLinkWP |
|---|---|---|---|
| Works with your own website's forms | No - forms.office.com or iframe embed only | Yes, via premium HTTP trigger or custom connector | Yes - native for 12 WordPress form plugins |
| Cost for this job | Free with M365 | Effectively $15/user/month (premium connector required) | Free plugin; Excel mirroring included, Excel-only via the AI Pack at $29/month |
| Branding and design control | Minimal | N/A (depends on your form) | Full - it is your form plugin |
| Delivery model | Native aggregation | Flow you build and maintain | Direct Microsoft Graph write with retry queue |
| Failure behavior | N/A | Flows can fail silently until noticed (per Microsoft community threads) | Retry queue + delivery log + manual replay |
| Ad attribution capture | No | Manual per-flow work | utm, gclid, fbclid, msclkid automatic |
Frequently Asked Questions
Do I need Power Automate or Zapier for this?
No. SheetLinkWP writes to Microsoft Graph directly from your WordPress server. There is no flow to build, no premium connector to license, and no per-submission task fee. See the full comparison at /compare/wordpress-excel-vs-power-automate.
Where is my form data stored?
In your WordPress database (as with any form plugin) and in the Excel Online workbook in your own OneDrive. Submission payloads are delivered from your WordPress server to Microsoft Graph. SheetLink's hosted broker exists only to maintain the Microsoft OAuth connection - it stores an encrypted refresh token, not your submissions.
Is this HIPAA compliant?
No plugin can make you HIPAA compliant by itself, and we will not pretend otherwise. What we can say: Microsoft offers HIPAA/HITECH business associate commitments for Microsoft 365 commercial plans (see Microsoft's documentation), and SheetLink's architecture delivers submissions from your own server into your own tenant without adding a third-party data silo for the payloads. Whether your overall setup meets HIPAA obligations is a determination for your compliance advisor.
Is this a CSV export?
No. Rows are written to a live Excel Online workbook through the Microsoft Graph API in real time. Nobody downloads, converts, or re-uploads anything.
Does it work with Microsoft 365 Business plans?
It works with Microsoft 365 work or school accounts. Personal Outlook.com accounts are not supported by Microsoft's Excel API. Connect with the account that owns the OneDrive where your workbook lives.
What exactly does the Primary Destinations add-on cover?
Mirroring submissions into Excel alongside a Google Sheet is included free. The AI Pack ($29/month or $290/year), which includes Primary Destinations, is required only when Excel Online is your sole destination and no Google Sheet is involved.
Which form plugins are supported?
All 12 core integrations: Contact Form 7, WPForms, Gravity Forms, Elementor Forms, Fluent Forms, Formidable, Ninja Forms, Forminator, Everest Forms, Beaver Builder, Divi, and WS Form - each with its own setup guide, for example /integrations/contact-form-7-to-excel and /integrations/gravity-forms-to-excel.
Can leads land in both Google Sheets and Excel?
Yes - that is the included mirroring mode. Teams in transition, or agencies with clients on both platforms, deliver every submission to both destinations from one sync rule.
Related How-To Guides
Put Your Website Leads Where Your Business Already Lives
One plugin, 12 form builders, direct Microsoft Graph delivery into your own tenant. Free core plugin.