Append every new SharePoint list item to an Excel register, so finance can pivot and chart requests without opening SharePoint.
Sign in with your Edesy account; the setup wizard opens on this template.
Category
Type
App automation
Steps
1
Apps
SharePoint, Microsoft Excel
Level
Beginner, about 9 min to set up
Pick the SharePoint site and list (for example a contract or purchase request list) and the Excel workbook to write to. Each new item adds a row with its title, owner, status, amount and a link back to the item. If you only want approved items in the register, filter on Status before writing.
SharePoint: new list item
Starts the workflow · SharePoint
Excel: add register row
App action · Microsoft Excel
You sign in to Edesy Flow with your Edesy account and the template wizard opens: map each role to a person, pick the app connections it needs, and Flow creates the forms and the workflow for you to edit.
Yes. The workflow opens in the visual builder, where you can add, remove or reorder steps, change who approves, edit the e-mails and add branches.
Save a note file to Dropbox for every new Airtable record, giving each client or project a document folder from day one.
1 step · 0 rolesAirtable Records to ExcelSend each new Airtable record to an Excel table, keeping an offline-friendly copy of leads or bookings for the finance team.
1 step · 0 rolesAirtable Records to Google SheetsCopy new Airtable records into a Google Sheet so partners or clients without an Airtable seat can follow the pipeline.
1 step · 0 rolesAsana Tasks to Excel WorkbookAdd new Asana tasks to an Excel table, so project costs, hours or client billing can be worked out next to the task list.
1 step · 0 rolesAsana Tasks to Google Sheets LogBuild a spreadsheet of every new Asana task with owner and due date, ready for workload charts or a weekly status review.
1 step · 0 rolesExcel Rows to Dropbox FilesDrop a summary file into Dropbox for each new Excel row, so an outside accountant sees invoices as they are raised.
1 step · 0 roles