Google Sheets API Settings for WPSyncSheets – Setup & Configuration

WPSyncSheets For Gravity Forms

Summarise with :

Add on Google

Manual Connection – WPSyncSheets For Gravity Forms

If you prefer to use your own Google Cloud Project and OAuth credentials, you can use the Manual Connection method.

With this method, you will need to create and configure your own Google Cloud Project, enable the required APIs, generate a Client ID and Client Secret, and add those credentials to WPSyncSheets for Gravity Forms.

Continue with the Manual Google API Connection Setup instructions to complete the configuration.

How to Create New Client ID and Client Secret Keys?

Users have to use the Google API to connect the plugin to the Google Sheet in order to enable automated data transfer and real-time synchronization between their website forms and Google Sheets.

Go to WPSyncSheets > For Gravity Forms > Google API Settings

For guidance on creating Google API settings, please refer to the Video Tutorial

Step 1

Login to your Gmail account and start with here.

Step 2

Create a New Project as shown below.

Step 3

To create a new project, enter your preferred Project Name and click CREATE.

Step 4

Once the project is created, click the Project Selector in the top navigation bar and select your newly created project.

Step 5

In the left sidebar, navigate to APIs & Services > Library.

Step 6

In the API Library, search for Google Drive API and select it.

Step 7

Click on Enable.

Step 8

Navigate to APIs & Services > Library.

Step 9

Search for and select Google Sheets API.

Step 10

Click on Enable

Step 11

Navigate to APIs & Services > OAuth consent screen.

Step 12

Click on Get Started

Step 13

  1. App Information: Enter the App Name and select the User Support Email, then click Next.
  1. Audience: Choose External and click Next.
  1. Contact Information: Enter the Developer Contact Email and click Next.
  1. Finish: Accept the required agreement and click Create.
    “Email address” → Developer Contact Email (this is the current Google Cloud field).

Step 14

Navigate to Audience, click Publish App, and then click Confirm.

Step 15

Navigate to Clients and click Create Client.

Step 16

Select OAuth Client ID, choose Web Application as the Application Type, enter a name, and click Create.

Step 17

Copy the Authorized Redirect URI from the plugin’s API Integration tab.

Cpoy the Authorised Redirect URLs

Paste it into the Authorized Redirect URIs field and click Create.

Step 18

Your Client ID and Client Secret will be generated.

Copy both values and paste them into the plugin’s API Integration tab, then click Save.

Select Google API Settings

After saving, click Generate Authentication Token.

Click here to Genrate and Authentication Token

Step 19

Select the same Google account that was used to create the Client ID and Client Secret.

Select Gmail Account

Step 20

Click Advanced as per the screenshot below.

Click on Advanced

Step 21

Click Go to Your App Name (unsafe) to continue.

Proceed With link

Step 22

Review the requested permissions, select all required permissions (if prompted), and click Continue.

Select All Continue

Step 23

After successful authorization, the Authentication Token will be generated automatically. Click Save to complete the setup.

Generate Client Token

Save and Update Gravity Forms Entries in Google Sheets.

WPSyncSheets For Gravity Forms

5.0
View Plugin

Have a question?

We’re here to help, just send us a message.

Need help?

We're ready to help out & answer questions!