Forms & Surveys
Build n8n Forms with Dynamic Dropdowns from Google Sheets
When a Google Sheet changes or a form is opened, it updates the n8n form's dropdown options from sheet values using the n8n API.
What it does
# Form with Dynamic Dropdown Field ## Overview Automated workflow: Form with Dynamic Dropdown Field. This workflow integrates 9 different services: stickyNote, formTrigger, googleSheetsTrigger, code, n8n. It contains 18 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 18 - Node Types: 9 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - n8n | get wf: n8n - n8n | update: n8n - On form submission: formTrigger - Google Sheets Trigger: googleSheetsTrigger - Execute Workflow: executeWorkflow - Sticky Note: stickyNote - Sticky Note1: stickyNote - Sticky Note2: stickyNote - Sticky Note3: stickyNote - Sticky Note4: stickyNote - ... and 8 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- n8n | get wf
- n8n | update
- On form submission
- Google Sheets Trigger
- Execute Workflow
- Write JSON
- Replace values
- Get all values
- Format to 'values'
- Error Handler for 0b874994
- Error Handler for 07635565
- Error Handler
Similar automations