One of our customers bumped into the ivalid_grant error in their Shack Forms/Google Sheets integration. The "Shack Forms Pro" Joomla extension allows you to automatically feed data submitted in a Shack Form to your selected Google Sheets.
You need to authorize your "Shack Form" connection to Google Sheets for this data transfer to take place. But such authorized connection may get corrupted. Then you will see the "invalid_grant" error in your form. Let's take a look at how to fix this error.
Here is how the "invalid_grant" error will look on the "Integration" tab of your "Shack Forms" Joomla extension:
Here is how to fix it.
- FTP to your Joomla site.
- Check if the legacy file /modules/mod_pwebcontact/form/fields/tokenData.json exists.
- If it does exist, delete it and re-grant access of your "Shack Forms" module to Google Sheets.
Note: See this tutorial if you need a refresher on how to authorize "Shack Forms" to work with Google Sheets.
- If that file doesn’t exist and you are still seeing the ivalid_grant error, then check if the following file exists: /administrator/components/com_shackforms/helpers/googleSheetsToken.
- If it exists, delete re-connect your "Shack Forms" module to work with Google Sheets.
Save $1000's when you sign up to Joomlashack's Everything Club.
You will get access to all our 28 extensions, templates, and Joomla training.