List Worksheet Rows doesn’t detect new rows added to Excel 365 (non-table structure)

Questions
,
1

Hello amazing community :waving_hand:

I’ve built a scenario in Make.com with the objective of detecting new rows added manually to an Excel 365 spreadsheet and notifying a Microsoft Teams chat when a new entry appears.

:white_check_mark: Main Goal:

Trigger a notification in Microsoft Teams every time a new row is manually added to the Excel file stored in OneDrive.
The workflow also tracks which row was processed last via a Data Store, and only sends alerts for new additions.

:repeat_button: Scenario Overview (Real Flow):

image
image1780×358 57 KB

Module # Name / Type Purpose
25 Data Store – Get a Record Gets the last_row_id previously stored
29 Microsoft 365 Excel – List Worksheet Rows Retrieves the next row of data
Filter 1 “es nuevo?” Compares row ID (or Row A) with last_row_id
14 Data Store – Check existence Prevents reprocessing already-handled rows
Filter 2 “Solo nuevos” Ensures only valid new rows pass
6 Microsoft Teams – Send Message Sends alert to Teams if a new row is found
16 Data Store – Add/Replace Stores current row data with a key (e.g., “Estado”)
27 Data Store – Update Record Updates the last_row_id to the newly processed one

:receipt: Excel File Setup:

  • Excel file stored in OneDrive

  • Using Excel 365 connector

  • Sheet name: "Muestreos y solicitudes"

  • Headers are in Row 8

  • Data starts at Row 9

  • New rows are added manually, usually only one at a time

  • Columns A–E are populated

image
image1900×425 58.2 KB

:gear: Module 29 Configuration:

Field Value
Select a Method legacy
Skip All Rows After Blank :white_check_mark: (Enabled by default)
Limit 1
Worksheet "Muestreos y solicitudes"
Table format :cross_mark: Not used (not a table)

image
image442×786 38.4 KB

:cross_mark: Problem:

  • The module List Worksheet Rows (29) does not return any bundles when a new row is added to the sheet.

  • Output from module 29 shows:

    Total number of bundles: 0

  • This blocks the flow entirely. The rest of the scenario (filter, Teams message, update) never runs.

  • :white_check_mark: The new row contains values in Columns A to D.

  • :white_check_mark: File is synced and saved

  • :white_check_mark: No empty rows between existing and new rows

  • :cross_mark: The Excel sheet is not formatted as a table

:white_check_mark: What has been tested already:

  • Manually inserting a row → scenario does not detect it

  • Added values in columns A to D, even full row → no detection

  • Adjusted filter logic

  • Tried switching to Watch Table Rows (ACID) → it always increments Row ID even if the row is incomplete

  • Saved Excel multiple times before running scenario

  • Disabled/Enabled “Skip All Rows After Blank Row” → still not detecting

  • Tried Start from Row and Row Range (but options limited in legacy)

:red_question_mark: What we need:

  1. Is there a reliable way to track new rows added manually to an Excel sheet that is not formatted as a Table?

  2. Is there a better combination of:

    • Module method (legacy vs modern)

    • Filter structure

    • Excel formatting

  3. Has anyone successfully handled this without converting Excel into a table?

  4. Is the community aware of alternatives (looping, start row, filters) that work with Excel 365 + OneDrive + non-table sheets?

:paperclip: Attachments (as support):

If this is not the best solution please tell me which one works, as I think it should be very simple to make.

Thanks so much to the amazing Make community! :folded_hands:

3

Hey Pablo,

Watch Worksheet Rows module will return new worksheet rows, no need for this complicated usage of data stores.

4

Please support and guide me. I haven’t been in the Make world very long, and maybe I’m overcomplicating things.

–-
I ran the module (Watch Worksheet Rows) twice, and I paid attention to this, which is the main problem I’m having.
When I ran the module twice, Row ID 21 moved forward two positions (there is data beyond line 19), which are empty (20 and 21). The problem is that if I now enter a new row in row 20 (which is the next row in the list), when I run the module again, it won’t take it into account because the Row ID pointer is already in a different position.
The matrix’s goal is to notify me every time a new row is entered into the spreadsheet in Excel 365 via MS Teams.

What am I doing wrong?

Thank you very much, and I appreciate your response.