Automation library · Alerts and monitoring

Monitor warehouse receiving performance with Google Sheets

Started by a clock, and works across Gmail and Google Sheets. It hands the judgement calls to Gemini. 19 steps, 3 branches: a working afternoon to understand properly.

MediumCalls a model: Gemini

Download free
19 stepsMedium: a working afternoon
3Branches: places the flow splits
0Loops or waits
2Services it connects to

The flow

Starts it 1Model 1Logic 12Service 5

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

  1. 1Schedule: Run Every HourSchedule triggerStarts it
  2. 2Get Receiving DataGoogle SheetsService
  3. 3Clean & Normalize Input DataSetLogic
  4. 4Group Data by UserItem ListsLogic
  5. 5Analyze User PerformanceCodeLogic
  6. 6Fetch Department DetailsGoogle SheetsService
  7. 7Attach Department InfoSetLogic
  8. 8Check if Performance Needs ActionIfLogic
  9. 9Build AI Analysis PromptSetLogic
  10. 10Prepare Final Output (All Good)SetLogic
  11. 11Generate AI RecommendationsGoogle GeminiModel
  12. 12Update Analytics DashboardGoogle SheetsService
  13. 13Format AI ResponseSetLogic
  14. 14Check if Escalation NeededIfLogic
  15. 15Route Based on Severity LevelIfLogic
  16. 16Prepare Final Output (No Action)SetLogic
  17. 17Send Warning Email to ManagerGmailService
  18. 18Send Critical Alert EmailGmailService
  19. 19Prepare Final Output (Escalated)SetLogic

How it's built

Starts on
A clock
Steps
19, with 3 branches
Size
Medium: a working afternoon
Connects to
Gmail, Google Sheets
Model
Gemini

Questions

What does it need to run?

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

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls Gemini. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Plan an afternoon. 19 steps is enough that you should read each one before running it.

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 19 steps before you point it at anything that matters.