Populate dropdown list dynamically from Google Sheets

Questions
1

Hello, I have an issue with populating dropdown list from google sheets. I draw up some basic workflow that I need to work with. The person chooses variable in the first form and depending on the choice, the next form gives option to choose from list.

When I open the form node, I can see all the available vehicles.

{6BB75B41-FACB-444B-B07D-4FC98180E74D}

But when I start the form, it shows only the first one.

{F0A425FC-FF76-45D5-A3B8-F58506281670}

Information on your n8n setup

  • n8n version: 1.75.2
  • Database (default: SQLite): SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Desktop app
  • Operating system: Windows 11
2

Hey @Valters_Zilvinskus

You’ll need to define the fields dynamically in the form node using the “json” mode.

I shared a template to demonstrate this here - Generate n8n Forms from Airtable and BaseRow Tables | n8n workflow template

For Google sheets, here’s a simplified template you can try.
Hope this helps!

4 Likes
3

Thank you for your reply, I already had it figured out using Code node, but this is much easier. Thanks a lot.

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.