=== Workbook Connector for Microsoft 365 ===
Contributors: westerndeal, abdullah17, gsheetconnector
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.0
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.
