Step 1: You need to add Google Sheets Integration key.
Please go to Dashboard > Piotnetforms > Settings > Google Sheets Integration > Enter Google Sheets Integration API Key > Save Setting
Step 2: Enable the Sheets API at https://console.developers.google.com/apis/library, search for the keyword “sheets”, select “Google Sheets API” and click Enable
Step 3: After the Google Sheets API appears in the results, click it and then click ENABLE.
Step 4: Click Create credentials.
Step 5: Click the client ID link.
Step 6: To create an OAuth client ID, you must first set a project name on the consent screen. Click the Configure consent screen button to continue.
Step 7: Enter the following information on the OAuth consent screen:
- Application name – Enter any appropriate name for your application.
- Authorized domains – Enter to add the domain.
Step 8 : Select Credentials from the side menu, click CREATE CREDENTIALS and then select OAuth client ID
Step 9: You choose the type of application is the web application and URLs. For example: http://pet.piotnet.com/wp-admin/admin.php?page=piotnetforms
Step 10: Click Create and copy Your Client ID and Your Client Secret add Step 1
Step 11: You need to create a new form with the Name and Email fields
Step 12: After creating a new field of your choice enable Google Sheets Connector.
You just need to add Google Sheet ID, Shortcode field, Column in Google Sheets, it will word.
Note: You need to create the same id forms.