Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Forms & Surveys

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

  1. n8n | get wf
  2. n8n | update
  3. On form submission
  4. Google Sheets Trigger
  5. Execute Workflow
  6. Write JSON
  7. Replace values
  8. Get all values
  9. Format to 'values'
  10. Error Handler for 0b874994
  11. Error Handler for 07635565
  12. Error Handler

Similar automations