Developer & DevOps
Form with dynamic dropdown field
16 nodes
222
115
Automatic trigger
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.Receive form submission via form trigger node
- 2.Fetch dynamic data from Google Sheets table
- 3.Update dropdown options based on retrieved data
- 4.Process submitted form data with custom code logic
- 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
222
Downloads
115
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (16)
/
n8n | get wf
N8N
n8n | update
N8N
On form submission
Form Trigger
Google Sheets Trigger
Google Sheets Trigger
Execute Workflow
Execute Workflow
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Write JSON
Code
Replace values
Set
Get all values
Google Sheets
Format to 'values'
Set