Automate collecting, logging, and notifying conference feedback in a single end-to-end AI agent.
The AI agent captures conference feedback from a web form, normalizes the data, and appends it to a OneDrive-backed Excel workbook. It then triggers an Outlook notification to the support team and surfaces centralized insights for post-event follow-up. This enables real-time visibility into attendee sentiment and topics while keeping a persistent log for analysis.
Performs end-to-end data intake, storage, and alerting for conference feedback.
Capture form submissions from the web form in real time.
Normalize fields to snake_case for consistent data handling.
Search OneDrive for the target workbook and validate its existence.
Append structured feedback as a new row in Sheet1 with mapped headers.
Notify the support team via Outlook with key feedback details.
Handle errors and ensure the workflow ends gracefully.
before → 5 real pain points. after → 5 clear outcomes.
A simple 3-step flow that non-technical users can follow.
Triggered on web form submission; collects all defined fields.
Search OneDrive for the Excel file and prepare row data mapped to headers.
Append the new row to Sheet1 and send an Outlook notification with key details.
A realistic, end-to-end use case.
Scenario: After a 2-day conference, 120 attendees submit feedback via the web form. The AI agent triggers immediately, normalizes data, locates test-n8n-feedback-form-data.xlsx in OneDrive, appends a new row to Sheet1, and sends an Outlook alert to the support mailbox within 2 minutes. Result: a complete, timestamped log with actionable details and a live notification for follow-up.
Roles that rely on structured conference feedback.
needs a real-time, centralized log of attendee feedback to adjust post-event actions.
wants to track sentiment and topics for campaign messaging after the event.
requires timely escalation of high-priority feedback or issues.
benefits from feedback on sessions to refine future talks.
gathers sponsor feedback to measure engagement and impact.
receives clean, structured data ready for analysis.
Connects your form, storage, and notification channels.
Searches for and locates the Excel workbook used as the log.
Appends a new row to Sheet1 with the mapped feedback data.
Sends an email notification with key feedback details.
Captures form submissions and passes data to the agent.
Orchestrates the flow and data transformations end-to-end.
Concrete scenarios where the agent shines.
Practical questions and detailed answers.
The agent captures all configured fields as submitted, including name, email, company, role, source, rating, preferences, and consent. Data is renamed to snake_case for consistent handling and downstream mapping. If a field is omitted, the agent records its absence and continues processing. You can customize the mapped headers to match your Excel schema. The flow stores the raw values alongside transformed ones for traceability.
The agent searches OneDrive for the specified Excel file. If the file isn't found, the workflow can raise an alert and halt appending to prevent data loss. You can configure an alternative path, such as creating a new workbook or notifying an operator to restore the file. This ensures you don't lose submissions or write to the wrong file. This results in a controlled failure with actionable next steps.
Yes. You can reuse the same AI agent for different events by parameterizing the workbook name or path. You can also point the search to a specific folder per event. The mapping logic remains consistent across workbooks, ensuring uniform data structure. Consider versioning or separate sheets for different events to maintain clarity.
The agent operates within your existing Microsoft 365 environment, leveraging OneDrive, Excel, and Outlook. Data access follows your organization's permissions, and you can implement standard security practices. No data leaves your environment unless you configure external destinations. Logging and error handling can be audited to support compliance reviews.
The agent builds a data row by aligning each field to the corresponding Excel header. The mapping is defined in the Build Sheet Data step and is updated if form labels change. This ensures a consistent, column-aligned dataset. Any mismatch triggers a clear error path so you can fix the source form or headers.
Yes. The notification email can be customized to include key fields such as full_name, email, company, rating, and any critical comments. You can adjust subject lines and body content to fit internal workflows. Dynamic fields are pulled from the parsed submission data at runtime. This ensures alerts contain exactly what your team needs.
The architecture supports replacing or supplementing Outlook notifications with other channels such as Slack or SMS. You can add additional triggers or modify the existing one to route to multiple endpoints. Each channel will carry the same key data fields for consistency. Your security and governance considerations guide which channels you enable.
Automate collecting, logging, and notifying conference feedback in a single end-to-end AI agent.
