Dynamic Form with Auto-Updating Dropdown from Sheets

This workflow enables the creation of interactive forms in n8n featuring a dynamic dropdown field that automatically refreshes its options from an external data source, such as Google Sheets. It polls the source at configurable intervals, processes new data, and updates the form seamlessly using the n8n API for self-modification.

Key components include a polling mechanism to fetch data, formatting nodes to prepare dropdown options, and n8n API nodes to retrieve and update the workflow itself, ensuring the form always reflects current data without manual intervention. This is ideal for scenarios where options change frequently, like product lists, employee directories, or financial instruments.

Setup is straightforward: configure Google Sheets credentials and sheet details, adjust polling frequency, customize form title/fields, and link submissions to downstream workflows. Benefits include reduced maintenance, real-time data sync, and scalability to other sources like APIs or databases.

Use cases span finance (e.g., dynamic account selection), surveys (e.g., updating respondent options), e-commerce (product catalogs), and CRM (lead source dropdowns), saving hours on manual updates and minimizing errors.