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.

Google Cloud API & Services

  • Search for "Google Sheets API" and "Google Drive API", open each one, and click Enable to turn them on.

Google Cloud Enable Drive & Sheet API

  • On the left menu, click on OAuth Consent Screen and then click Get Started.

Google Cloud OAuth Screen


  • Add your App name and Support email, then click Next.

Google Cloud Enter App Information

  • Choose External as the audience.

Google Cloud Select Audience


  • Add your Contact info, and agree to the terms.

Google Cloud Add Contact Info



  • Then, click Create.

Google Cloud Create App

  • 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.

Google Cloud Add Branding Details


  • Go to the Audience menu in the sidebar and click Publish App.

Google Cloud Publish App

  • Now, go to the client option in side menu and click on the Create Client button.

Google Cloud Create Client

  • 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.

Google Cloud Add Authorized Redirect URIs

  • 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.

Form Vibes Authenticate Client ID and Secret

  • 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.

Google App not verified error

  • Once done, your Form Vibes status will show Connected.

Form Vibes Connected with Google Sheet

Still need help? Contact Us Contact Us