Import Specific Field Types from Google Sheets

Google Form Question/Field Types

Google Forms provides different types of questions/fields that you can include in a form.

The following types are

Field Type can be one of the following (Case insensitive)

Form Builder supports the following questions/field type

Click on "Google Sheets."
The Google Picker will open, allowing you to choose a sheet to create a new form or add fields to an existing one.
Once you select a sheet, its name will appear just below the apps button.
You can access the chosen sheet by clicking the "Open in New" icon.

After selecting a sheet, the Form Builder will display all the tab names in the "Choose Tab" section. Choose one tab from the list.
Next, select the "Question and Answers" pattern. By default, the range will be set to A2:E10, which covers the first 9 rows of the selected tab.
In the "Question and Answers" pattern:

Choose the "Questions" column from the dropdown menu.
If your sheet has a "Types" column, select it from the dropdown menu.
If your sheet includes a "Descriptions" column, select it from the dropdown menu.
Select the "Starting Answer" column from the dropdown menu.
Select the "Ending Answer" column from the dropdown menu.
If there is a "Required" column in your sheet, choose it from the dropdown menu.
Use the "Add other" option to include "Other" choices in multiple-choice and checkbox fields.
If a cell contains multiple options separated by a delimiter (e.g., ","), specify the delimiter.

Refer to the sample data provided below. You can adjust the range and click the "GET" button to refresh the list of fields/questions.

The Form Builder displays all available fields for import. If you specify a valid type, the correct question format will be applied; otherwise, an invalid type will default to Text.
The Form Builder also allows for quick configuration of field types— for example, you can switch from Multiple Choice to Drop Down.
Choose the position where you want the fields to be imported. You can import individual fields by clicking the Action button or import multiple selected fields by clicking the Import Selected button.
Once you've completed these steps, your form will be ready.

Select a sheet from the dropdown menu to either build a new form or add fields to an existing one.
Choose the Range type: Full or Range By default, Full is selected, which includes the entire sheet. If you select Range, the default range will be A2:F10, covering the first 9 rows of the selected tab.

Choose the "Question and Answers" pattern.
Select the "Questions" column from the dropdown menu.
If your sheet includes a "Types" column, select it from the dropdown menu.
If your sheet has a "Descriptions" column, select it from the dropdown menu.
Select the "Starting Answer" column from the dropdown menu.
Select the "Ending Answer" column from the dropdown menu.
If there is a "Required" column in your sheet, choose it from the dropdown menu.
Use the "Delimiter" option only if a cell contains multiple options separated by a delimiter (e.g., ",").
Select the "Add other" column to include "Other" options in multiple choice and checkbox fields.

Refer to the sample data to see the pattern. The Form Builder will list all fields; you just need to specify which column corresponds to each field in your sheet.
Click the Get button to proceed.

Form Builder lists all fields and makes fields available for you to import.
If you enter proper or supported type it will get correct question otherwise invalid type will be consider as Text.