How to Connect with Google Sheet
Follow the below steps to generate a Client Id and Client Secret Key.
- Go to Google Cloud Console and log in with your Gmail account details.
- Now create a new project(or choose an existing one), enter the project name, and click on Create.
- Select your project from the dropdown at the top of the page.
- From the left menu, go to API & Services -> Library.
- Search for "Google Sheets API" and "Google Drive API", open each one, and click Enable to turn them on.
- On the left menu, click on OAuth Consent Screen and then click Get Started.
- Add your App name and Support email, then click Next.
- Choose External as the audience.
- Add your Contact info, and agree to the terms.
- Then, click Create.
- On the left menu, click Branding, scroll down to Authorized Domains, and click Add Domain.
- Copy the URL from Form Vibes -> Settings -> Google Sheets (Step 8) and paste it here. This URL is generated automatically. Click Save.
- Go to the Audience menu in the sidebar and click Publish App.
- Now, go to the client option in side menu and click on the Create Client button.
- Choose your App type and enter a name.
- Copy the Authorized Redirect URL shown in Form Vibes -> Settings -> Google Sheets -> Step 13.
- Then click on Add URL, paste the copied link, and click Create.
- A popup will appear — copy the Client ID and Client Secret and paste them into the correct fields in Form Vibes.
- Click the Authenticate button in Form Vibes.
- Then, you’ll be redirected to log in with your Gmail account.
- If you see a “App is not verified” warning, click Show Advanced and then Go to App.
- Approve all requested permissions.
- Once done, your Form Vibes status will show Connected.