Communication

Connect Google Sheets to Gmail and Supabase automatically

51 nodes 117 82 Webhook
Download

Workflow Description

Automation receives data via webhook, processes and stores it in Supabase, updates Google Sheets rows automatically, and sends email notifications through Gmail. Complete end-to-end data flow with logging and communication.

How it works

  1. 1.Receive incoming data through webhook endpoint
  2. 2.Transform and standardize data format
  3. 3.Store records in Supabase database
  4. 4.Update Google Sheets with new information
  5. 5.Send email notifications via Gmail

Use cases

  • Collect web forms into a spreadsheet and email confirmation to users
  • Log customer requests in database and notify team automatically
  • Connect contact forms to unified customer relationship system

Requirements

  • Google account with Sheets and Gmail permissions
  • Active Supabase project with API credentials
  • Gmail account configured for outbound messages

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Google Sheets Gmail Supabase

Details

Trigger Webhook
Nodes 51
Apps 3
Views 117
Downloads 82

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (51)

/

Append Material Request

Google Sheets

#1

Get Approvals

Webhook

#2

Standardize Data

Set

#3

Update Stock

Code

#4

Receive Issue Request

Webhook

#5

Send Approval Request

Gmail

#6

Prepare Approval

Code

#7

Create Record Issue

Supabase

#8

Search Product ID

Supabase

#9

Searck Issues

Supabase

#10

Update Current Stck

Supabase

#11

Merge Lookups

Merge

#12

Update Current Stock1

Google Sheets

#13

LookUp Current stock1

Google Sheets

#14

Low stock Detection1

Code

#15

Merge1

Merge

#16

Sticky Note

Sticky Note

#17

Append Raw Materials

Google Sheets

#18

Calculate Total Price

Code

#19

Calculate Updated Current Stock

Code

#20

Validate Quantity Received

Code

#21

Initialize New Product stock

Google Sheets

#22

Update Current Stock

Google Sheets

#23

LookUp Current stock

Google Sheets

#24

New Row Current Stock

Supabase

#25

Current Stock Update

Supabase

#26

Search Current Stock

Supabase

#27

Format response

Item Lists

#28

Merge

Merge

#29

Low stock Detection2

Code

#30

Sticky Note4

Sticky Note

#31

Sticky Note2

Sticky Note

#32

Receive Raw Materials Webhook

Webhook

#33

Standardize Raw Material Data

Set

#34

Lookup Existing Stock

Google Sheets

#35

Check If Product ID Exists

If

#36

New Record Row

Supabase

#37

Trigger Low Stock Alert

If

#38

Send Low Stock Email Alert

Gmail

#39

Low Stock Email Alert

Gmail

#40

Validate Issue Request Data

Code

#41

Verify Requested Quantity

Code

#42

Check Available Stock for Issue

Google Sheets

#43

Format Approval Response

Set

#44

Verify Approval Data

Code

#45

Retrieve Issue Request Details

Google Sheets

#46

Process Approval Decision

If

#47

Get Stock for Issue Update from Current

Google Sheets

#48

Update Stock After Issue

Google Sheets

#49

Materials Issue Table Update

Supabase

#50

Is Stock is Low

If

#51

Similar Templates

Automate Gmail email filtering and organization

4 nodes

Send new Gmail messages to Slack in real time

6 nodes

Analyze suspicious emails with ChatGPT and create tracking tickets

18 nodes

Route important Gmail messages to Slack channels

43 nodes

Extract expense data from emails and log to Google Sheets

6 nodes

Send new Google Calendar events to Telegram instantly

4 nodes