(5/5)

Googlesheets Workflow

Automated workflow: Googlesheets Workflow. This workflow integrates 11 different services: webhook, stickyNote, itemLists, code, merge. It contains 69 nodes and follows best practices for error handling and security.

Integrations Used (4)

Workflow Structure (48 nodes)

100%

Webhook

Receive Raw Materials Webhook

Set

Standardize Raw Material Data

Code

Calculate Total Price

Google Sheets

Append Raw Materials

Supabase

New Record Row

Code

Validate Quantity Received

Supabase

Search Current Stock

Google Sheets

Lookup Existing Stock

Merge

Check If Product ID Exists

Item Lists

Format response

Code

Calculate Updated Current Stock

Google Sheets

Initialize New Product stock

Google Sheets

Update Current Stock

Supabase

New Row Current Stock

Supabase

Current Stock Update

Google Sheets

LookUp Current stock

Trigger Low Stock Alert

Code

Low stock Detection2

Gmail

Send Low Stock Email Alert

Webhook

Get Approvals

Webhook

Receive Issue Request

Set

Standardize Data

Set

Format Approval Response

Code

Validate Issue Request Data

Code

Verify Approval Data

Supabase

Searck Issues

Code

Verify Requested Quantity

Google Sheets

Retrieve Issue Request Details

Google Sheets

Append Material Request

Supabase

Create Record Issue

Merge

Merge1

Process Approval Decision

Supabase

Search Product ID

Google Sheets

Check Available Stock for Issue

Merge

Merge Lookups

Google Sheets

Get Stock for Issue Update from Current

Supabase

Materials Issue Table Update

Google Sheets

Update Stock After Issue

Code

Update Stock

Code

Prepare Approval

Gmail

Send Approval Request

Google Sheets

Update Current Stock1

Supabase

Update Current Stck

Google Sheets

LookUp Current stock1

Code

Low stock Detection1

Is Stock is Low

Gmail

Low Stock Email Alert

Node Types:

action

trigger

transform

code

default

logic

Requires credentials

Prerequisites

No credentials required!

This workflow can be imported and used immediately.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~35 min

Score: 65/100

Custom Code

Conditional Logic

5 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

workflow.json

{
  "meta": {
    "instanceId": "workflow-487a188d",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:43.027446",
    "updatedAt": "2025-09-29T07:07:43.027469",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "nodes": [
    {
      "id": "c983fae5-a779-4a56-ace0-304aaefe0433",
      "name": "Append Material Request",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        6780,
...