Go to MetForm=> Settings=> Google Sheet Integration=> Here you’ll require Google Client ID and Google Client Secret. If you’re not familiarized with it, go ahead and click on the create form here link.
Create a google developer project
Put your project name then press the create button.
After creating a project you might need to wait for a few seconds to receive a notification then select the project you created from the notification panel.
Go to APIs Overview
Go to OAuth consent screen page
Select user type external then press create button
See screenshot and fill all selected input fields. If your site is on the live server then you need to authorize the domain. An authorized domain does not allow subdomain names and any protocol. However, you can use this Google project for websites created with your subdomain. For localhost, you do not need to authorize the domain.
Click the Save and continue button.
Add a test user
Click back to dashboard button
Click publish app button and go to the credentials page. If your website inside localhost then you don’t need to click to publish app button. Just go to the credentials page.
Select OAuth client ID
The select application type is a web application, fill name input field and you need to add an authorized redirect URL, you get the redirect URL inside your MetForm dashboard. After filling all input fields just press create button.
You got the client ID and client secret. Just copy the credentials and paste them inside the MetForm dashboard.
After pasting the necessary credentials, first save changes. Then go to the next step.
Go to the Library page
Select Google Sheets API Library.
Press Enable button
After enabling Google Sheets API, go to your MetForm dashboard and click Generate Access Token link.
Log in to your Gmail account and press the continue link.
Press Allow button
Go Form Setting and Enable Google Sheet