How to Automatically Export Sent and Received Emails to Excel

Open Excel online or via OneDrive, create a new workbook, and type column headers (e.g., Sender, Recipient, Subject, Date). Select these headers, press Ctrl+T, and check 'My table has headers' to format them as a Table.

Log in to Microsoft Power Automate, click 'Create' on the left sidebar, and select 'Automated cloud flow'.

Name your flow and search for the trigger 'When a new email arrives' (to track incoming) or 'When an email is sent' (to track outgoing). Select the appropriate Outlook connector and click Create.

Click 'New step', search for 'Excel Online (Business)', and select the action 'Add a row into a table'.

Select the location, document library, and specific Excel file and table you prepared earlier. Click into the new fields that appear and map them using Dynamic Content from the email (e.g., map 'From' to your Sender column, 'Subject' to Subject). Save and turn on the flow.

Navigate to your SharePoint site, click 'New' > 'List', and set up columns for the email details you want to capture (Sender, Date, Subject, Time).

In Power Automate, use the same Outlook email trigger as above, but add the SharePoint 'Create item' action as your next step instead of Excel.

Open the populated SharePoint list at the end of the week, click the 'Export' button in the top ribbon, and choose 'Export to Excel' to download your weekly timesheet for analysis.