Collect invoice amounts in Excel
Assess Outlook, OneDrive and Excel for invoice collection: table structure, permissions, missing extraction and the risks of repeated writes.
Content updated:
Does this route fit?
The recorded Excel operation appends rows to a table. A workbook containing arbitrary cells is not automatically that table. Choose the destination workbook, table name and column order before setup.
Blocked: required steps are not documented.
5/7 steps backed by API documentation.
Required apps
Setup and a small test
Prepare a test workbook with a named table and defined column order. Read the permission conditions of the specific Graph operation.
Handle classification and amount verification separately. Send only confirmed values with provenance to Excel.
Check existing rows on repeat runs. Do not blindly append after an interrupted request: the same invoice could be recorded twice.
Steps and evidence
Search messages
Outlook
Provider documentation · Workflow not yet practically tested
Details
Provider API:
user-list-messagesGET /me/messagesPermissions
Documented scope alternatives
Mail.Read
Do not request all scopes. Select the least privileged scope that covers the operation and resource.
Costs and limits
Not checked for this account and operation. Free access is not promised.
Source · Last confirmed:
Read a message
Outlook
Provider documentation · Workflow not yet practically tested
Details
Provider API:
message-getGET /me/messages/{id}Permissions
Documented scope alternatives
Mail.Read
Do not request all scopes. Select the least privileged scope that covers the operation and resource.
Costs and limits
Not checked for this account and operation. Free access is not promised.
Source · Last confirmed:
Download an attachment
Outlook
Provider documentation · Workflow not yet practically tested
Details
Provider API:
attachment-getGET /me/messages/{id}/attachments/{id}/$valuePermissions
Documented scope alternatives
Mail.Read
Do not request all scopes. Select the least privileged scope that covers the operation and resource.
Costs and limits
Not checked for this account and operation. Free access is not promised.
Source · Last confirmed:
Classify a document
Not documented
Extract amount and currency
Not documented
Upload a file
OneDrive
Provider documentation · Workflow not yet practically tested
Details
Provider API:
driveitem-put-contentPUT /me/drive/items/{parent-id}:/{filename}:/contentPermissions
Documented scope alternatives
Files.ReadWrite
Do not request all scopes. Select the least privileged scope that covers the operation and resource.
Costs and limits
Not checked for this account and operation. Free access is not promised.
Source · Last confirmed:
Append rows
Excel
Provider documentation · Workflow not yet practically tested
Details
Provider API:
tablerowcollection-addPOST /me/drive/items/{id}/workbook/tables/{id|name}/rows/addPermissions
Documented scope alternatives
Files.ReadWrite
Do not request all scopes. Select the least privileged scope that covers the operation and resource.
Costs and limits
Not checked for this account and operation. Free access is not promised.
Source · Last confirmed:
Tests and limitations
The migration fixture writes a range in a synthetic XLSX file. This does not establish table append, formulas, formatting or macros. Provider testing with a dedicated Microsoft account is outstanding.
Public verification reports · Open the local runner and instructions
Alternatives
A manually maintained table can suit occasional invoices. Google Sheets uses different operations; shared spreadsheet terminology does not guarantee interchangeability.