=== Workbook Connector for Microsoft 365 === Contributors: westerndeal, abdullah17 Donate link: https://www.paypal.me/WesternDeal Tags: microsoft excel, microsoft 365, forms to excel, wordpress form integration, onedrive excel sync Requires at least: 5.0 Tested up to: 7.1 Requires PHP: 7.4 Stable tag: 1.0.5 License: GPLv2 or later License URI: https://www.gnu.org/licenses/gpl-2.0.html Connect WordPress forms to Microsoft Excel in Microsoft 365 and automatically send form submissions to Excel tables. == Description == **Workbook Connector for Microsoft 365** allows you to connect your WordPress website with Microsoft Excel files stored in Microsoft 365 / OneDrive. The plugin enables automatic transfer of form submissions into Excel tables — no manual exports, CSV imports, or complicated automation workflows. Built for performance, reliability, and scalability, this plugin uses the official **Microsoft Graph API** for secure communication with Microsoft services. ✔ Automatically send form entries to Excel ✔ Supports Fluent Forms ✔ Supports Contact Form 7 ✔ Supports Gravity Forms ✔ Supports WPForms ✔ Works with Excel files stored in OneDrive ✔ Select workbook, worksheet, and table ✔ Secure OAuth connection with Microsoft ✔ No coding required ✔ Real-time form to Excel sync Perfect for: • Form automation • Customer inquiries • Lead generation • CRM integration • Data logging • Internal reporting • Reporting & analytics • Automation pipelines --- == Key Features == ✅ **Microsoft 365 Integration** Securely connect your WordPress website with Microsoft using OAuth authentication. ✅ **Direct Excel Table Support** Data is inserted directly into Excel tables for structured and reliable storage. ✅ **Multi-Form Plugin Integration** Supports Fluent Forms, Contact Form 7, Gravity Forms, and WPForms. ✅ **Dynamic Workbook Selection** Choose Excel workbooks directly from your OneDrive account. ✅ **Worksheet & Table Detection** Select exact worksheet and table for form data insertion. ✅ **Real-Time Sync** Form entries are pushed instantly after submission. ✅ **Performance Optimized** Uses caching and Microsoft Graph API optimization for better performance. ✅ **Secure & WordPress-Compliant** Nonce verification, sanitization, and capability checks implemented. --- == Future Development == Workbook Connector for Microsoft 365 is built on a modular architecture, allowing rapid expansion without affecting current integrations. Upcoming integrations planned: • Ninja Forms • Formidable Forms • Forminator • JetFormBuilder • Elementor Forms • WooCommerce Orders • Easy Digital Downloads • Divi Forms • Avada Forms Development priorities are guided by user feedback. --- == Requirements == • WordPress 5.8 or higher • PHP 7.4 or higher • Microsoft 365 account • OneDrive storage enabled • At least one supported form plugin installed: * Fluent Forms * Contact Form 7 * Gravity Forms * WPForms --- == Installation == 1. Upload the plugin to the `/wp-content/plugins/` directory OR install via WordPress Plugins screen. 2. Activate the plugin. 3. Go to: **Admin → Workbook Connector** 4. Click **Connect** and authorize Microsoft account access. 5. Create a Feed under **Feeds**. 6. Select: • Excel File • Worksheet • Table 7. Save settings. Done ✅ --- == How It Works == 1. User submits a supported WordPress form 2. Workbook Connector captures the submission 3. Microsoft Graph API sends the request 4. Data is inserted into the selected Excel table Everything works automatically in real-time. --- == Frequently Asked Questions == = Does this plugin require Microsoft API credentials? = No. The plugin securely handles Microsoft OAuth authentication automatically. --- = Where should my Excel file be stored? = Your Excel file must be stored in OneDrive connected to your Microsoft 365 account. --- = Why must I use Excel tables? = Excel tables ensure structured and accurate row insertion while preventing mismatched columns. --- = Can I connect multiple forms? = Yes. You can create multiple feeds for multiple forms and workbooks. --- = Which form plugins are currently supported? = Currently supported: • Fluent Forms • Contact Form 7 • Gravity Forms • WPForms More integrations are planned. --- = Is this plugin affiliated with Microsoft? = No. This plugin is independently developed and not affiliated with Microsoft. --- = What permissions does the plugin request? = The plugin requests only the minimum permissions required for: • Reading Excel files • Reading worksheets and tables • Writing form entries into selected tables --- == Screenshots == 1. Connecting plugin with Microsoft account 2. Creating a new Excel feed 3. Selecting workbook and worksheet 4. Selecting Excel table 5. Mapping form fields with Excel columns 6. Managing multiple form integrations --- == Changelog == = 1.0.5 = [27 June 2026] * Added Contact Form 7 integration * Added Gravity Forms integration * Added WPForms integration * Added language translation support * Improved modular architecture for multi-form support * Fixed redirect issues on live sites * Added form preview support for supported plugins * Improved feed management UI = 1.0.4 = * Updated UI = 1.0.3 = * Added Freemius SDK integration = 1.0.2 = * Improved nonce verification and user capability security = 1.0.1 = * Updated readme according to WordPress.org guidelines = 1.0.0 = * Initial release * Fluent Forms integration * Feed settings for Excel table mapping * Microsoft Graph API integration --- == Security & Privacy == This plugin communicates directly with Microsoft Graph API using secure OAuth authentication. • No form submission data is stored on third-party servers • Data is transmitted only to Microsoft services • No analytics or tracking scripts • No third-party sharing All tokens are securely stored using the WordPress Options API. --- == External Services == This plugin communicates with: 1. Microsoft Graph API Service Provider: Microsoft Corporation Service URL: https://graph.microsoft.com/ Purpose: • Retrieve Excel files • Retrieve worksheets • Retrieve tables • Insert rows • Fetch user account data Data Sent: • OAuth tokens • Workbook identifiers • Worksheet identifiers • Table identifiers Privacy Policy: https://privacy.microsoft.com/ --- 2. OAuth Credential Service Service Provider: GSheetConnector / Western Deal Service URL: https://oauth.gsheetconnector.com/ Purpose: • Retrieve Microsoft API credentials • Facilitate secure OAuth setup Data Sent: • Plugin identifier • Site request metadata No personal form submission data is transmitted. --- == Disclaimer == Microsoft, Excel, OneDrive, and Microsoft 365 are trademarks of Microsoft Corporation. This plugin is not affiliated with or endorsed by Microsoft. --- == License == This plugin is licensed under GPLv2 or later.