With this add-on, you can send the user’s data to Google Sheets.

Install User Registration & Membership Pro #

To use the Google Sheets Addon, ensure User Registration & Membership Pro is installed and activated. If not, purchase it from wpuserregistration.com and follow our guide on activating it with a license key. The addon is available for Plus and Professional plans.

Activate the Google Sheets Addon #

1. Navigate to User Registration & Membership > Addons in your WordPress dashboard.
2. Locate or search for the Google Sheets and toggle to Activate.

Setup and Configuration #

Creating Google Client ID and Secret for Google Sheets #

• Go to: https://console.cloud.google.com/
• Click on the option “Select a project”, after which a window will pop up. Then, click on the “New Project” option.
  Please note that if you already have a project, the project’s name will appear in the place of ‘Select a Project‘. For example, in the image below, ‘WPEverest‘ should be clicked.

• Add your project name.
• Browse your location OR choose the option, “No Organization”.
•  Click on the “Create” button.

• Navigate to the left and go to: API & Services > Library

• Search ‘Google Spreadsheet’.
• Click on ‘Enable‘.

• Navigate to the left and click on “Oauth Consent Screen.”

• Select the “External” radio button.
• Click on the “Create” button.
• Add an “Application Name” in the field.
• Add User Support Email.
• Add an email address in the Developer contact information option.
  Please note, that the User Support Email and Developer contact information can be the same email address.
• Click on the “Save” button.
  Once you have created the app, you will have to publish it. For this, go to: OAuth Consent Screen and click on ‘Publish App’.
• Navigate through the menu on the left and click on “Credentials”.
• Click on the “Create Credentials” button.
• Select “Oauth Client ID” from the dropdown menu.

• Select the Application type “Web Application“.
• Add the text you desire in the field under “Name”.
• Add your site’s URL under “Authorized redirect URIs”.
  Note: If you site’s URI is https://example.com, then the redirect URIs should be:
  https://example.com/wp-admin/admin.php?page=user-registration-settings&tab=integration
• Click on the “Save” button and you will see a popup window with the Client ID and Client Secret.

Copy these keys to a clipboard. You will need it for the integration.

Authenticating Google Sheets with User Registration #

Once you have created the client ID and Secret, you can now authenticate the Google Sheets with the User Registration. For this, go to:

User Registration > Settings > Integration > Google Sheets

Enter the Client ID and Secret and click on Connect. Now, you will automatically get the access token. Click on the Verify Access Code.

Connecting registration forms to Google Sheets #

Once you have successfully created the connection, you can now send data from the registration forms to the desired Google Sheets.

• Go to User Registration > Add New and create a form. You can do this on existing forms as well. Now, go to the Form Settings > Google Sheets.
• Click on the Add New Sheet button.

You will then need the Sheet ID. For this, go to your Google Sheets, and on the URL of the sheets, you will be able to find the ID. The Sheet Name doesn’t need to match.

Enter this Sheet ID and click on Add Sheet. You will then be able to map the User Registration form fields with the columns on your Google Sheets.