Google Sheets

Need to upgrade to 1.3.0+

Introduction

Directly connecting the data binding logic to Google Sheets can effectively improve the efficiency of users using the form helper. All source data changes can be operated within Google Sheets, and after the data is updated, the form helper can be directly reloaded to use

Data binding steps

1. Select Google Sheets as your data source in the form helper floating window (VIP users only).
2. Upon first use, you will be prompted to sign in to Google Sheets . After clicking "Google SHeets Login" you will be redirected to the authorization page. 
   
3. After authorization is complete, you can click the "Load Spreadsheet" button to load the spreadsheet . If everything goes smoothly, you will see the spreadsheet title, worksheet, and other information.
   
4. After clicking the "Load Worksheet" button, the form helper will fetch data from Google Forms, starting from the first row by default (excluding the header). For performance reasons, it will fetch 500 rows at a time. To fetch more data, simply modify the "Start Row Number" value and reload the worksheet.
5. Clicking the "Preview" button will display all field data that matches the field configuration.
   

Get Spreadsheet ID

1. Open your Google Sheets list and select the spreadsheet you want to load in Form Helper.
   
2. Open the selected spreadsheet; the underlined part in the spreadsheet's links is the Spreadsheet ID.