Populating Dropdown in Customer Fields from a .xlsx file(spreadsheet)

Shopify Apps

Topic summary

Populating a dropdown in the Customer Fields app using data from a spreadsheet is addressed via a Google Sheets integration provided by Helium. This integration dynamically loads dropdown options from a Google Sheet.

  • Implementation: Use Helium’s documented method to link a Google Sheet to the dropdown field so options are auto-populated.
  • Resource: Documentation link provided for setup and details: https://help.heliumdev.com/en/articles/5507010-load-field-options-from-a-google-sheet.
  • Outcome: The original requester confirmed the guidance was helpful, implying the approach resolves the need to import spreadsheet data.
  • Limitations: The thread does not specify any cap on the number of dropdown items; this remains unanswered.

Status: Effectively resolved with a recommended solution (Google Sheets integration); no further action noted in the thread.

Summarized with AI on January 24. AI used: gpt-5.
2

Hey @JonathanReeves , I know you reached out to us directly already, but I’ll comment here as well in case anybody else is looking for a similar solution.

Our team has built an integration with Google Sheets to dynamically populate the field values of a dropdown from a spreadsheet. You can view our documentation for this here: https://help.heliumdev.com/en/articles/5507010-load-field-options-from-a-google-sheet