Use below steps to get Client ID & Client Secret got Gravity Forms Google Spreadsheet Addon V3.0 +. For older version please scroll to bottom.
Please make sure you have set correct site url (including https if you have ssl ) from WP Admin => Settings => General
To get Client ID & Client Secret you will need to create a new Project with your google account.
-Go to Google Console & login with your gmail account.
– Create a new project (if necessary): If you don’t have a project already, you can create one by clicking on the project dropdown at the top of the page and selecting “New Project”. Follow the prompts to create the project.

– Select your project: Once you have your project created or selected, ensure it’s active.

– Enable the Google OAuth 2.0 API: In the left sidebar, navigate to “APIs & Services” > “Library”. Search for “Google OAuth 2.0 API” and click on it. Then, click the “Enable” button.

– Set up OAuth consent screen: In the left sidebar, navigate to “APIs & Services” > “OAuth consent screen”. Select the user type as External and click “Create”. Fill in the required fields such as application name, user support email, etc., and click “Save and Continue”. On the next page, click “Save and Continue” until you reach the end, then click “Back to Dashboard”.

–

– Create OAuth 2.0 client ID: In the left sidebar, navigate to “APIs & Services” > “Credentials”. Click on “Create credentials” and select “OAuth client ID”. Choose the application type as Web application give your application a name, and add the authorized redirect URIs as your website url e.g https://mywebsite.com/. ( Important :Url should be with slash at the end e.g http://mysite.com/ ) . Click “Create” to generate your client ID and client secret.




– Enable the drive & sheet api for your project.

-Select Drive API & Sheet API

