Now, our form can be integrated with Google Sheets. When the form is submitted, the submitted data will sync to the connected Google Sheets.




If you need to integrate your form with Google Sheets, please follow the steps below to set it up.


Connect the app with your Google account.


Step1:Enter the app and select Settings.



Step2:Click the Connect button in the Google Sheets section to connect your Google account.



Please make sure to grant pifyapp.com access to See, edit, create, and delete all of your Google Drive files and See, edit, create, and delete all your Google Sheets spreadsheets.


If you only grant one of these permissions, some features may be unavailable. If you do not grant access, integration with Google Sheets will not be possible.



Integrate form with Google Sheets.


Step1:Enter the editing page of the form.


Step2:Select Settings, Expand Integration.



Step3:Enable Google Sheets. Select the spreadsheet you need to connect to.


IMPORTANTThe table used to synchronize form data must be a blank spreadsheet, data cannot be synchronized if it is any other type of spreadsheet.




Please note that if no Google Sheets are displayed in the list, you will need to click "Create a new spreadsheet" to create a Google Sheets. Our app cannot connect to tables created in Google Sheets.



Step4:Select the form fields that need to be synchronized to the spreadsheet. 



The fields you select will be synced to your connected spreadsheet after the form is submitted.


After you have completed the above steps, the data submitted in the form will be synced to your Google Sheets.


IMPORTANTAfter you have finished configuring, please do not make any changes to anything in the Google sheet, as it will result in data synchronization failure.