User Registration Google Sheets

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

Installation #

1. Firstly, you need to purchase the User Registration Premium Plan.
2. After the successful purchase, you will get the plugin zip file under your WPEverest account page.
3. Now, you can download the User Registration Pro plugin and Google Sheets add-on from there.
4. Through your WordPress Dashboard, visit Plugins -> Add New -> Upload and then choose the downloaded zip file and then install and activate it.
5. Now you are ready to use this add-on for your site.

Alternative Method:

1. Once you have entered the User Registration Pro license on your site, go to User Registration > Dashboard > All Features.
2. Search for the ‘Private Notes‘ add-on.
3. Click on ‘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.