Integrate Google Sheets With Balbooa Joomla Forms

Balbooa Joomla Forms builder allows you to export forms submissions to Google Sheets. In this tutorial, we'll show you how to sync Balbooa Joomla Forms and Google Sheets.

Create the Google Spreadsheet.

1. Create a New Google Spreadsheet. To sync your form and spreadsheet properly, be sure that each column header on your spreadsheet corresponds to a similar field on your form.

Create the Google Spreadsheet

Connect Form to Google Sheets.

2. Go to: Components >> Forms >> Your Form.

Open Joomla Forms

3. Open the Form Integration Modal by the clicking on the button "Integration" at right top corner.

Joomla Forms Integration

4. Click on the Google Sheets logo.

Joomla Forms Integration Dialog

5. Click on the Login button.

login

6. Provide Balbooa Joomla Forms PRO access to your account. Click "Allow" and copy "Authentication Code."

Authentication Code

7. Paste Authentication Code into the field Authentication Code and click on the button "Apply"

Authentication Code

NOTE: Authentication can take few seconds. Continue to the next step after field "Spreadsheets" will be active.

8. Select Spreadsheet and Worksheet from the dropdown lists.

Select Spreadsheet and Worksheet

9. Mutch your Form fields and Google Sheets fields.

Mutch Form fields

10. Save your Form and enjoy!