How to integrate Balbooa Joomla Forms with Google Sheets?




Integrating web forms with Google Sheets is a powerful way to automate the collection and organization of data from your website. In this tutorial, we will show you how to integrate Balbooa Joomla Forms with Google Sheets. This step-by-step guide will help you set up this integration without any extra effort.




Google Sheets configuration


1. Create a New Google Spreadsheet.

2. To export your form to the spreadsheet properly, ensure each column header corresponds to a similar field on your form.

Create the Google Spreadsheet - How to Integrate Google Sheets with Balbooa Joomla Forms?
  • To get a Client ID and Client Secret for Desktop you must be signed in to a Google account

OAuth Client configuration


1. Go to Google Developers Console.
2. Click Select a project ➝ New Project ➝ click the button Create.

Create New Project - Integrate Google Sheets with Balbooa Joomla Forms



3. Navigate to Library ➝ Google Sheets API ➝ Enable.

Google Sheets API - Integrate Google Sheets with Balbooa Joomla Forms



4. Navigate to Library ➝ Google Drive API ➝ Enable.

Enable Google Drive API - Integrate Google Sheets with Joomla Forms



5. Go to the OAuth consent screen ➝ select User Type ➝ click the button Create.

OAuth Consent Screen - Integrate Google Sheets with Balbooa Joomla Forms



6. Fill in the fields at all steps: OAuth consent screen ➝ Scopes ➝ Test users ➝ Summary. Click the button Save and Continue.

Edit App Registration - Integrate Google Sheets with Joomla Forms



7. Go to Credentials ➝ Create Credentials ➝ OAuth client ID.

Create Credentials - Integrate Google Sheets with Balbooa Joomla Forms



8. Click Application type ➝ select Desktop app ➝ click Create.

Desktop App - How To Integrate Google Sheets with Joomla Forms?



9. Copy your Client ID and Client Secret.

Client ID and Client Secret - Integrate Google Sheets with Joomla Forms




Form configuration


1. Open the Form Integration modal window: Integration ➝ Data Storage ➝ Google Sheets
2. Paste Client ID and Client Secret ➝ click Authenticate Google Account.
3. Confirm your choices.
4. Enable the checkbox next to: View, create, edit and delete all files on Google Drive. 
5. Сlick Allow ➝ copy Authentication Code.
6. Paste Authentication Code.
7. Select Spreadsheet and Worksheet from the dropdown lists.
8. Match your form and Google Sheets fields.
9. Click the button Save.

  • If you're having trouble installing Google Sheets integration, download the Google library from here. Downloaded zip file place to www.site.com/components/com_baforms/libraries and unzip it

Related articles