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. Click on the project on the notification bar.
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 (not necessary)
Click back to dashboard button
Click publish app button and go to the credentials page. If your website is on localhost then you don’t need to click to publish app button. Just go to the credentials page.
Go to Credentials
Select OAuth client ID
The select application type is a web application, fill the name input field
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.
Now you will get 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. After, login, it will say Google has not verified this app. Don’t worry and just click on go to unsafe mode.
Click on the Allow Access button
Note: You need to turn on the Google sheet integration option to use the form in your Google Sheet.
To do so, from the dashboard
- Go to Metform > Forms
- Click on Edit option of the form you want to add to sheet.
- Go to Form Settings > Integration
- Turn on Google Sheet option