n8n Tutorial: Loop Over Google Sheets Rows & Apply Conditional Logic

Headline: Master data iteration in n8n! In this tutorial, we dive deep into the Split In Batches node to create a functional "Loop Over" workflow. What you’ll learn: In this video, I walk you through a real-world automation scenario where we: Extract Data: Pull a list of products and prices from a Google Sheet. Initialize Loops: Use the Split In Batches node to handle items individually. Conditional Logic: Implement an If Node to check if a price is greater than 100. Data Transformation: Use the Set Node (Edit Fields) to calculate discounts (10% vs 20%) based on the item's price. Closing the Loop: Routing the data back to the batch node until all items are processed. Why this matters: Standard workflows often process all data at once. Learning how to loop allows you to perform complex, item-specific actions like sending individual emails, calling APIs for each row, or performing unique calculations without crashing your workflow.