Plugin - Google Sheets (send form data to your Google Sheets)

RSForm!Pro Google Sheets Plugin
 

Your form submitted data can be sent to your Google Sheets using this plugin. The RSForm!Pro Google Sheets plugin allows you to connect to your Google Sheets and map form data within the desired sheet columns. When the form is submitted, the data you map is passed to your spreadsheet as well.

 
Downloading and Installing the plugin
Download

You can download the plugin by logging with your purchase user, then head to My Downloads > RSForm!Pro - Modules & Plugins > Plugins > "Google Sheets".

Install

In the backend area go to the Extensions > Manager > Install page, and install the plugin. Next thing is to publish the plugin from Extensions > Plugins, search for the "System - RSForm! Pro Google Sheets" plugin.

Connecting to Google Sheets
  • Access Google Developers Console.
  • Login using your Google account and Create a new Project.
  • Add a project name, organization, location and click on the "Create" button (wait a few moments after you click the create button to load your project, otherwise you can manually select it).
  • In the Dashboard view search for "Google Sheets API" and access it.
  • Enable the "Google Sheets API" by clicking on the "Enable" button at the top.
  • Click on "Credentials" from the left sidebar.
  • Click the "Configure Consent Screen" button.
  • Enter a application name (for example: RSForm!Pro Google Sheets) and click Save
  • Next click on the "Create Credentials" button and select the "OAuth client ID" option.
  • Select "Web application" and add a Name.
  • Within the "Authorized JavaScript origins" add your website (for example: https://www.rsjoomla.com). If you're on localhost you can leave it blank.
  • Within the "Authorized redirect URIs" add the already generated URL found via backend > Components > RSForm!Pro > Configuration > Google Sheets > "Redirect URI".
  • Click the Create button.
  • Now, two keys will be generated, client ID and client secret that you have to be placed in your installation within backend > Components > RSForm!Pro > Configuration > Google Sheets > "Google Client ID" respectively "Google Secret" fields.
  • Use the top "Save" button to save your keys (these have to be firstly saved).
  • After the page refreshes, you'll find a new button "Authenticate" which you'll have to click. Doing so will redirect you to Google to choose your Google account and will ask you to Allow the application.
  • Clicking the Allow button will redirect back to your website where a successful green "Access token successfully stored!" message should be encountered if everything was properly configured. Eventually you'll view more data being specified within the Google Sheets tab of your RSForm!Pro configuration, though there's no need to further change anything here.
 
Mapping Submission Data
  • Access your form in the backend > Components > RSForm!Pro > Manage Forms > your form > Form Properties > Google Sheets Settings tab.
  • Enable the "Use Google Sheets" option.
  • Add your "Spreadsheet ID". This can either be the exact ID of your spreadsheet or its entire URL (more details below).
  • Click top Save button (this has to be firstly saved to retrieve your sheets and their columns).
  • If your spreadsheet has multiple sheets, you can then select the one you need from the "Sheet Name" dropdown.
  • Finally, if your sheet has columns, these will be available for your to map with your form's data. A placeholder selector is also provided for each column that can be used to include the needed placeholder of your form.
Finding your spreadsheet ID or URL:
  • go to Google Sheets.
  • access your spreadsheet.
  • notice top browser URL. For example:

    https://docs.google.com/spreadsheets/d/UkFHSrjrhN9TzRRp47fr4JFJSA83rjFH1eFGr438v4/

  • either use its URL or take its ID from the URL, in this case the ID is the following:

    UkFHSrjrhN9TzRRp47fr4JFJSA83rjFH1eFGr438v4

6 persons found this article helpful.


Was this article helpful?

Yes No
Sorry about that