Developer & DevOps

Form with dynamic dropdown field

16 nodes 223 116 Automatic trigger
Download

Workflow Description

An automation template that creates a web form with a dynamic dropdown field pulling live options from a Google Sheets table, enabling real-time data synchronization between the form interface and your centralized spreadsheet.

How it works

  1. 1.Receive form submission via form trigger node
  2. 2.Fetch dynamic data from Google Sheets table
  3. 3.Update dropdown options based on retrieved data
  4. 4.Process submitted form data with custom code logic
  5. 5.Store results back in Google Sheets

Use cases

  • Building survey forms with product or category options sourced from a central spreadsheet
  • Creating request forms that automatically populate department or project lists from Sheets

Requirements

  • Active Google Workspace account with Google Sheets access permissions
  • Active n8n account with properly configured form trigger node

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

N8N Form Trigger Google Sheets

Details

Trigger Automatic trigger
Nodes 16
Apps 3
Views 223
Downloads 116

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 (16)

/

n8n | get wf

N8N

#1

n8n | update

N8N

#2

On form submission

Form Trigger

#3

Google Sheets Trigger

Google Sheets Trigger

#4

Execute Workflow

Execute Workflow

#5

Sticky Note

Sticky Note

#6

Sticky Note1

Sticky Note

#7

Sticky Note2

Sticky Note

#8

Sticky Note3

Sticky Note

#9

Sticky Note4

Sticky Note

#10

Sticky Note5

Sticky Note

#11

Sticky Note6

Sticky Note

#12

Write JSON

Code

#13

Replace values

Set

#14

Get all values

Google Sheets

#15

Format to 'values'

Set

#16