Real use case
n8n emails a weekly low-stock and expiry report
On his fifth day learning n8n, a pharmacist built a weekly stock report. Every Saturday at 9 AM it downloads a stock spreadsheet from Google Drive, splits out low-stock and out-of-stock items, estimates what will be needed, and flags products expiring in the next 30 days. It turns each list into a CSV file and emails the reports through Gmail. He used AI to write the small piece of code in the middle and admits he may have made it more complicated than needed, but it worked.
Agentn8n
Copy this prompt
Help me set up an n8n workflow that runs every [SATURDAY 9 AM]. It should download my stock spreadsheet [FILE NAME] from Google Drive, list items below [REORDER LEVEL] and items at zero, list anything expiring in the next 30 days, and email me those lists as CSV files through Gmail. Explain each node in plain words and keep it as simple as possible.
Our own prompt, written from what the source describes. We haven't run it ourselves. Text in [BRACKETS] is what you replace.
Watch out for
- Test it on a copy of your spreadsheet first, and check the column names match exactly.
Where this comes from
Original post by @IWasNuezz on X, Nov 9, 2026. We rewrote it in our own words. The result is what the poster reports.
Read the original