Import Specific Field Types from Google Sheets

Click on "Google Sheets"

After clicking "Google Sheets" Google Picker opens where you can choose any Sheet to build a new Form or add new fields to the existing one.

After selecting the sheet you can see the sheet name just below the apps button.

You can access the selected sheet by clicking on the Open in New icon

After choosing sheet, Form Builder will list all the tab name in Choose Tab, now you need to select one of the tab name form Choose Tab

Select the Question and Answers pattern

Default range will be A2:E10 i.e first 9 rows of a selected tab.

Select the Question and Answers from pattern.

Select the Questions column from the dropdown.

If your sheet have a types column then select the types column from the dropdown.

If your sheet have a descriptions column then select the descriptions column from the dropdown.

Select the Starting answer column from the dropdown.

Select the Ending answer column from the dropdown.

If your sheet has a required column then select the required column from the dropdown.

Choose the Add other at column to add the Other options to the multiple choice and checkbox fields.

We can use delimiter only when one cell has multiple options with a separator (example: ",")."

You can refer the sample data below.

You can change the range and hit GET button to refresh the list of fields/ questions

Form Builder lists all fields and makes fields available for you to import.

If you enter proper or supported type it will get the correct question otherwise invalid type will be consider as Text.

Form Builder have an option to configure rapidly type (for example If you want drop down , in place of Multiple choice.

Choose the position where the fields need to be imported.

You can import individual field by clicking on the Action button.

You can also import the selected fields by clicking import Selected button.

That's it, your Form is ready.

Choose any sheet from the drop down to build a new Form or add new fields to the existing one.

Select the Range type Full or Range.

Full is selected by default i.e full range of the sheet. If you select the Range then default range will be A2:F10 i.e first 9 rows from the selected tab.

Select the Question and Answers from pattern.

Select the Questions column from the dropdown .

If your sheet have types column then select the types column from the dropdown.

If your sheet have descriptions column then select the descriptions column from the dropdown.

Select the Starting answer column from the dropdown .

Select the Ending answer column from the dropdown .

If your sheet have required column then select the required column from the dropdown.

You can use delimiter only when one cell has multiple options with a separator (example: ",")."

Choose the Add other at column to add the Other options to the multiple choice and checkbox fields.

Below is the sample data you can see the pattern.

Form Builder lists all fields. you just need to tell the Form Builder which column is what in sheet.

Click Get button

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.

Click on Choose button to add question/fields to the selected form.

Click on Create button and enter the form name to build a new Form and adds questions/fields to the new form.

After Selecting/Creating the form you can see the form name appearing just below the Choose/Create button.

You can access the selected/created form by clicking on the Open in New icon

You can import individual field by clicking on the Action button

You can also import the selected fields by clicking Import Selected button.

That's it, your Form is ready.