Microsoft Excel + SurveyAnalytica
Excel Online tables on OneDrive and SharePoint as live workflow targets, sources and triggers.
SurveyAnalytica writes records into Excel Online workbook tables through the Microsoft Graph API — creating the worksheet, table and headers automatically — and watches workbooks for changes to trigger flows. Uploaded .xlsx files are also parsed directly by hot-folder flows, so spreadsheet-based processes can feed automation without anyone re-keying data.
Workflow triggers
Workbook updated
Microsoft Graph driveItem subscriptions detect workbook changes and fire flows (workbook diffs are fetched on change).
Scheduled reads
Excel tables as scheduled data sources.
Uploaded file parsing
Hot-folder flows parse uploaded .xlsx/.xls files as flow input.
Workflow actions
Write table rows
Rows are added to a workbook table via the Graph workbook API; worksheet, table and headers are created automatically.
Read table rows
Paged reads for downstream steps.
Drive browsing
Browse OneDrive and SharePoint sites, drives and files from the designer; live column schemas at design time.
How data flows
Outbound: survey responses and workflow records land as table rows in Excel Online workbooks on OneDrive or SharePoint. Inbound: workbook updates trigger flows; tables read back as data sources; uploaded Excel files parse straight into flows.
Connection: Microsoft OAuth 2.0 with automatic token refresh; OneDrive and SharePoint drives are both browsable.
Worked example: From an uploaded costing sheet to Salesforce
Trigger: an analyst drops an .xlsx into a hot folder.
Step: the file is parsed and rows validated.
Action: qualifying rows create or update Salesforce records; the processed rows append to an audit workbook on SharePoint.
Ready-made flow templates
Install a shipped template and adapt it — no build-from-scratch required.
Setting it up
1.
Connect Microsoft 365 via OAuth from Account → Integrations.
2.
Browse to the OneDrive or SharePoint workbook (or let the action create one).
3.
Map fields against the live column schema.
4.
Optionally subscribe the workbook-update trigger.
Frequently asked questions
Does this work with SharePoint document libraries?
Yes — the designer browses SharePoint sites and drives as well as OneDrive.
Can a workbook edit trigger a flow?
Yes — Graph driveItem subscriptions detect changes; the flow fetches the workbook diff since there is no native cell-level webhook in Graph.
Can I process Excel files people upload?
Yes — hot-folder flows parse uploaded .xlsx/.xls files directly as input rows.
Do I need to pre-build the table?
No — the write action creates the worksheet, table and header row automatically.