How to integrate Google Sheets with Joomla forms?

Balbooa Joomla Forms Builder allows you to export your form submissions directly into Google Sheets. In this tutorial, we will show you how to automatically export Balbooa Joomla Forms to Google Sheets.

Google Sheets configuration

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

OAuth client configuration

To get Client ID for Desktop you must be signed in to a Google account.

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

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

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

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

6. Fill in the fields and click the button Save.

7. Go to OAuth consent screen ➝ Publishing status ➝ set In production.

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

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

10. Copy your Client ID and Client Secret.

Form configuration

1. Open the Form Integration modal window: Integration ➝ Data Storage ➝ Google Sheets.
2. Paste Client ID and Client Secret ➝ click Authenticate Google Accounte.
3. Confirm your choices: click Allow ➝ copy Authentication Code.

4. Paste Authentication Code.
5. Select Spreadsheet and Worksheet from the dropdown lists.
6. Match your form and Google Sheets fields.

7. Click the button Save.