Not receiving emails anymore from Google Sheets

Beginner Questions
1

:bullseye: What is your goal?

Hi everyone!

I am trying to create a system that sends me emails everytime someone has filled in a form thats being send to google sheets.

I have “Google sheets Watch new rows” and “Microsoft 365 email (Outlook)”. It worked only 1 time to send the results to my email, after I ran a second test after filling in the form again and a row was added below the other one in Sheets (several times) it didn´t seem to work anymore.

When I save the bubbles and click “Run once”, a “1” with two checkmarks appear above the Sheets bubble. It then says the following:

“The module didn’t return any new data.
You can use the Choose where to start settings to select the first piece of data you want to return and start working with. You can return data starting from a specific point or all past data.”

And (Choose where to start). It gives me 3 options: Select one option to continue

  • Choose manually
  • All
  • Since specific ID

I chose “All”. Click “Run once” again, but nothing happens as if I have never even chosen an option. I do notice that I use credits after running again, but no data is being transfered. That stays on 0.

I hope I explained myself well, because I feel stuck momentarily.

In any case, thanks a lot for taking the time to read this!

3

The issue is with how “Watch new rows” tracks state. It uses a cursor — it remembers the last row it processed and only returns rows after that point. Since it already processed your first submission, it considers everything else “seen.”

Why “All” didn’t work

Choosing “All” sets the cursor back to the beginning, but Make only processes new rows after the next trigger fires — not immediately on “Run once” unless there’s actually a new row added after you reset it.

Fix — step by step

Open the Google Sheets module settings

Click “Choose where to start”

Select “All” — this resets the cursor

Don’t run yet. Go fill in the form again so a brand new row is added to the sheet

Now click “Run once”

That new row should be picked up and the email should fire.

Why this keeps happening

“Watch new rows” is designed for scheduled/webhook polling — not repeated manual testing against the same data. Each time you run it, it moves the cursor forward. Old rows are invisible to it.

For ongoing testing, always add a fresh form submission before running. Don’t reuse existing rows.

If you want it to run automatically (not just on “Run once”), make sure scheduling is turned on — the toggle at the bottom left of the scenario. Without it active, the trigger only fires when you manually run it.

4

Thanks a lot for the advice!

I was excited to try it out to see if this could fix where I´m stuck. I followed the steps you had mentioned above. However, I still didn´t receive an email after doing so.

I did remove a row before earlier on Google Sheets, but I´m not sure if that can be the issue. I believe it kept on adding rows below that after filling them in anyway (So it continued as usual).

Lastly, my scheduling toggle is on. Mine says ´Scheduling every 15 minutes´ if it matters, but I´m still stuck.

I wonder if I have to use a completely new Sheets form instead to make it work? The data transfer still stays 0 after running.

5

Hey Joshua!
Can you try to follow these?

  1. Create a completely new Google Sheet with the same column structure.

  2. Disconnect the form from the old sheet and reconnect it to the new one.

  3. Delete the Google Sheets > Watch New Rows module in Make.

  4. Add it back, pointing to the new sheet.

  5. Configure it, choose Since specific ID and set it to row 1 (or the current last row if you pre-filled headers).

  6. Submit a fresh form entry so a new row appears in the new sheet.

  7. Run once or wait for the 15-minute schedule to fire.

This wipes the corrupted state entirely. A brand-new sheet means Make starts fresh with clean indices.

-John

6

Additionally, I do notice from test 1 to test 10, I had skipped test 6. There might be a chance that that row has been overwritten, aside from the first row that I had removed manually, but I remember it completely ignored that and continued as usual after that one. Now I´m doubting why I had skipped test 6.

7

Hey John!

Thank you for your time and effort!

I will definitely try this when I have the opportunity later today. I will reply here to see if it had worked!

8

Dear John,

Thanks a lot for the help! The scenario has worked, so I can proceed with the project. First I had another error in Outlook because I had Map toggled on. But after I had fixed that, an email got send again.

Thanks again to ApexSystematic as well for the time and effort! You guys really make me feel like I don´t stand alone on this road to starting up my own business. I really appreciate it a lot! I will definitely be asking for more help in the near future.

All the best!

9

Hey Joshua, you’re very welcome :hugs: