How to Send Shack Forms Entries to Google Sheets

How to Send Shack Forms Entries to Google Sheets

Shack Forms Pro is the easiest and most powerful way to add forms to your Joomla site.

With Shack Forms, you can integrate your Joomla forms with Google Sheets. If you enable this integration, every time someone submits a Shack Form, their data will automatically be sent to your Google Sheet.

This integration can be incredibly useful if you need to share or analyze the data sent via your forms. Google Sheets has all the power of a spreadsheet, and can also make your data pop with colorful charts and graphs.

This guide will show you how to send Shack Forms entries to Google Sheets.


Steps to Integrate Shack Forms and Google Sheets

First, you will need some preparation before attempting this tutorial:

  • Have a Shack Form created and ready to use.
  • Have a Google account and create a blank Google Sheet.

Now let's show you how to connect your Shack Form to your Google Sheet.

Inside your Shack Forms module, you want to click the "Integrations" tab.

On this tab, you want to click options "Yes" for the "Insert form data into a spreadsheet" setting.

Now you want to click the "Grant access" button of the "Google API Access Code" parameter.

grant access

  • Google will require you to approve access to your account. Click "Allow":

click allow

Google will give you a code. You want to copy that code:

02 copy this code

You want to go back to Shack Forms and paste this code into your "Google API Access Code" field.

Now would be a good time to save your module. 

Come back to the "Integrations" tab and your "Google API Access Code" box should now show in green, "Has access".

has access

You want to go to your Google Sheets account and find the ID number of your Sheet. It will be in the URL of the Spreadsheet:

https://docs.google.com/spreadsheets/d/1XlQaYdNYKnPYtJ5buUYIgTfjbEamEI9f5pMcqOT1o3I/edit#gid=0

You want to copy the part of the URL between the /d/ and the /edit. This bit is the ID of your Google Spreadsheet document. In my example, that bit is 1XlQaYdNYKnPYtJ5buUYIgTfjbEamEI9f5pMcqOT1o3I

Enter this ID into the "Document ID" field:

paste your document id number

You want to click "Get columns names".

get columns names

You should now see that Shack Forms connects to Google Sheets and fills in the columns:

the columns appeared

Now would be a good time to click "Save" or "Save & Close".

Now you can test your Shack Form. Go to the front of your site and fill in the details:

submit some test data

You will see that the form's data has been sent directly to Google Sheets:

result


What's Next?

Save $1000's when you sign up to Joomlashack's Everything Club.

You will get access to all our 30 extensions, templates, and Joomla training.

Click here to join the Everything Club


About the author

Steve is the CEO of Joomlashack. Originally from the UK, he now lives in Sarasota in the USA. Steve has been involved with Joomla since 2006.