Agriculture

Dairy Milk Collection & Quality Pricing

Records daily milk collection, calculates the rate from fat and SNF quality, blocks duplicate entries and sends a WhatsApp receipt. A daily summary report goes out automatically.

The Dairy Milk Collection & Quality Pricing workflow on the n8n canvas, with its 17 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Agriculture
Nodes
17
Apps
HTTP, Google Sheets
Price
Free
Download JSON
On this page

How it works

  1. A form captures the farmer, quantity and quality readings.
  2. Input is validated and checked against today's entries for duplicates.
  3. Rate and amount are calculated from quality and the entry is saved.
  4. The farmer gets a WhatsApp confirmation, or an alert if there's a problem.
  5. Each day, totals are aggregated and a report is sent on WhatsApp.

Use cases

  • Milk collection centers
  • Dairy cooperatives
  • Private dairies

What you need

This workflow connects to these apps.

  • HTTP
  • Google Sheets
  • n8n

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Google Sheets account
  • Twilio account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Milk Collection Sheet → Sheet1Google SheetsFarmer NameCollection DateSessionFarmer IDMobile NumberMilk QuantityFat (%)SNF (%)Collection CenterOperator NameRemarksQualityRateAmountCreated At

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
Milk Entry Form TriggerformTrigger
Validate Milk Inputif
Check Duplicate Entry (Sheet)googleSheets
Is Duplicate Entry?if
Send Duplicate Alert Messagetwilio
Save Milk EntrygoogleSheets
Send Success Messagetwilio
Daily SchedulerscheduleTrigger
Aggregate Milk Datacode
Generate Report Messagecode
Send WhatsApp Alerttwilio
Send Invalid Input Alerttwilio
Calculate Qty, Rate & Amountcode
Fetch Today Milk RecordsgoogleSheets

Frequently asked questions

Records daily milk collection, calculates the rate from fat and SNF quality, blocks duplicate entries and sends a WhatsApp receipt. A daily summary report goes out automatically. It's a 17-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Google Sheets and Twilio. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 1 table in Google Sheets. Create it with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the AI Crop Advisory for Farmers workflow

    Agriculture27 nodes

    AI Crop Advisory for Farmers

    Gives farmers practical, AI-generated crop advice based on their soil, crop and live weather. Advice is delivered instantly on sign-up and refreshed daily over WhatsApp.

  • n8n canvas of the AI Email Classifier & Slack Router workflow

    AI Automation11 nodes

    AI Email Classifier & Slack Router

    Reads incoming emails, has AI classify each one (support, sales, billing, HR and so on) and notifies the right team on Slack straight away.

  • n8n canvas of the AI Shopify Product Builder with Review workflow

    E-commerce37 nodes

    AI Shopify Product Builder with Review

    Creates complete Shopify products from a photo or a brief. AI writes the copy, generates images and saves everything for review, and approved products are published automatically.