Automation library · Alerts and monitoring

Get Gmail alerts for dropped top 10 keyword rankings

Started by a clock, and works across Gmail and Google Sheets. 43 steps, 2 branches, 3 loops or waits: large, and worth reading before you trust it with anything live.

Large

Download free
43 stepsLarge: read it before trusting it with anything live
2Branches: places the flow splits
3Loops or waits
2Services it connects to

The flow

Starts it 1Logic 34Service 8

The steps in the order they run, from what starts it.

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2Get previous keywordsGoogle SheetsService
  3. 3AggregateAggregateLogic
  4. 4Clear sheet (previous keywords)Google SheetsService
  5. 5Initialize "items" fieldSetLogic
  6. 6Set "items" fieldSetLogic
  7. 7Get ranked keywordsData For Seo Labs ApiService
  8. 8Merge "items" with DFS responseSetLogic
  9. 9Has more pages?IfLogic
  10. 10Merge "items" with last responseSetLogic
  11. 11Split out (items)Split OutLogic
  12. 12Filter items with rank > 10FilterLogic
  13. 13Append row in sheetGoogle SheetsService
  14. 14Set Top 1, Top 3, Top 10SetLogic
  15. 15Aggregate1AggregateLogic
  16. 16Filter (data for comparing is not empty)FilterLogic
  17. 17Filter Top 1, Top 2, Top 3SetLogic
  18. 18Split out (previous keywords)Split OutLogic
  19. 19SwitchSwitchLogic
  20. 20Filter (dropped from Top 1)FilterLogic
  21. 21Filter (dropped from Top 3)FilterLogic
  22. 22Filter (dropped from Top 10)FilterLogic
  23. 23Loop Over Top 1 ItemsSplit In BatchesLogic
  24. 24Loop Over Top 2 ItemsSplit In BatchesLogic
  25. 25Loop Over Top 3 ItemsSplit In BatchesLogic
  26. 26MergeMergeLogic
  27. 27Get live google organic SERP regularData For Seo Serp ApiService
  28. 28Get live google organic SERP regular1Data For Seo Serp ApiService
  29. 29Get live google organic SERP regular2Data For Seo Serp ApiService
  30. 30Aggregate5AggregateLogic
  31. 31Split out (SERP results)Split OutLogic
  32. 32Split out (SERP results)1Split OutLogic
  33. 33Split out (SERP results)2Split OutLogic
  34. 34Send a messageGmailService
  35. 35Prepare email contentSetLogic
  36. 36Prepare email content2SetLogic
  37. 37Prepare email content4SetLogic
  38. 38Aggregate2AggregateLogic
  39. 39Aggregate3AggregateLogic
  40. 40Aggregate4AggregateLogic
  41. 41Prepare email content1SetLogic
  42. 42Prepare email content3SetLogic
  43. 43Prepare email content5SetLogic

How it's built

Starts on
A clock
Steps
43, with 2 branches, 3 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Gmail and Google Sheets accounts. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

No. Every step is fixed logic or a call to a service, so it does the same thing every time.

How long does it take to set up?

Take your time. At 43 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 43 steps before you point it at anything that matters.