No Submissions going to Google Sheet
-
Hi There
I have setup a Contact Form 7 Form and installed and verified this plugin with my Google Sheets.
It currently sits on our staff intranet which is internal only.
Basically here is the form I have below:
<fieldset><legend>1. College site</legend>[select site include_blank “Bersham” “Deeside” “Llysfasi” “Northop” “Yale” “Hawarden Composites Centre”]</fieldset>
<fieldset><legend>2. Details of injured person</legend>
[text your-name placeholder "Name"][text age placeholder "Age"]Gender [select gender include_blank “Male” “Female”]Status[select status include_blank “Employee” “Student” “Contractor” “Visitor” “Client”]Next of kin informed?<br />[radio kin “Yes” “No”]<br />Parents informed? (Nursery / Holiday Club Only)<br />[radio parents “Yes” “No”]
</fieldset><fieldset><legend>3. Details of accident</legend>
[text date placeholder "Date (dd/mm/yy)"][text time placeholder "Time"][text location placeholder "Location of accident"]Risk assessment in place?<br />[radio risk “Yes” “No”][textarea details placeholder “Details of Occurrence/Injury”]
</fieldset><fieldset><legend>4. Witnesses</legend>
[textarea detailswit placeholder “Details of witnesses (if any)”][text whom placeholder "By whom?"]
</fieldset><fieldset><legend>5. Treatment</legend>
Was first aid given?<br />[radio firstaid “Yes” “No”]<br />Was the individual:<br />[select individual include_blank “Retained in college” “Sent home” “Taken to hospital” “Referred to GP”]
</fieldset><fieldset><legend>6. Reporting</legend>
[text reportedby placeholder "Accident reported by:"][text datereportedby placeholder "Date (dd/mm/yy)"][text timereportedby placeholder "Time"]<br /><br />[text reportedto placeholder "Accident reported to:"][text datereportedto placeholder "Date (dd/mm/yy)"][text timereportedto placeholder "Time"]
</fieldset>
[submit “Submit”]I have also setup the Google Sheet where I want all submissions to go to and the CF7 Google Sheets I have setup looks like this:
Google Sheet Name
AccidentReportGoogle Sheet Tab Name
submissionsI have added in my Google Sheet the name called ‘AccidentReport’ and the tab is ‘submissions’. I have then added the column names in to each column on the spreadsheet (please see below:
date [site][your-name][your-age][your-gender][your-status][your-kin] [your-parents] [your-date] [your-time] [location][risk] [details] [detailswit] [whom] [firstaid] [individual] [reportedby] [datereportedby] [timereportedby] [datereportedto] [timereportedto]
I am getting an email with the successful submission but its not getting added to the Google Sheet. I also checked the CF7 log and getting this message:
PHP 5.5.38 Error fetching OAuth2 access token, message: ‘invalid_grant’ :: 400
Please help?
Thanks
- The topic ‘No Submissions going to Google Sheet’ is closed to new replies.