Title: cotrones's Replies | WordPress.org --- # cotrones [ ](https://wordpress.org/support/users/cotrones/) * [Profile](https://wordpress.org/support/users/cotrones/) * [Topics Started](https://wordpress.org/support/users/cotrones/topics/) * [Replies Created](https://wordpress.org/support/users/cotrones/replies/) * [Reviews Written](https://wordpress.org/support/users/cotrones/reviews/) * [Topics Replied To](https://wordpress.org/support/users/cotrones/replied-to/) * [Engagements](https://wordpress.org/support/users/cotrones/engagements/) * [Favorites](https://wordpress.org/support/users/cotrones/favorites/) Search replies: ## Forum Replies Created Viewing 3 replies - 1 through 3 (of 3 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Forms: 3rd-Party Integration] Gravity Forms to Goole Sheets](https://wordpress.org/support/topic/gravity-forms-to-goole-sheets/) * Thread Starter [cotrones](https://wordpress.org/support/users/cotrones/) * (@cotrones) * [9 years, 9 months ago](https://wordpress.org/support/topic/gravity-forms-to-goole-sheets/#post-7605138) * Do you happen to have an example of a Google Form submission url? Or could you point me in the right direction in the page source? * Thanks in advance! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Forms: 3rd-Party Integration] Gravity Forms to Goole Sheets](https://wordpress.org/support/topic/gravity-forms-to-goole-sheets/) * Thread Starter [cotrones](https://wordpress.org/support/users/cotrones/) * (@cotrones) * [9 years, 9 months ago](https://wordpress.org/support/topic/gravity-forms-to-goole-sheets/#post-7605126) * Hey Zaus, I was wondering what should be in my Google Form in order for it to integrate properly? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Forms: 3rd-Party Integration] Gravity Forms to Goole Sheets](https://wordpress.org/support/topic/gravity-forms-to-goole-sheets/) * Thread Starter [cotrones](https://wordpress.org/support/users/cotrones/) * (@cotrones) * [9 years, 9 months ago](https://wordpress.org/support/topic/gravity-forms-to-goole-sheets/#post-7605043) * Thanks for the reply. I’m new to this if you couldn’t already tell. I am still receiving a failure notice, I’m not sure where I’m going wrong. I will paste the email below. A few other questions: * Do you think I am messing up the mapping? I already have the field names on my Google Sheet, should I delete these? Does this form seem correct to you or do I not even need this code?: * ``` function doPost(e) { if (!e) return; var sheetID = "1_pextohBKnlOyWvuD3bwypdXSX7ZqHBnf7zvFjB7jkw"; // Replace this with the Google Spreadsheet ID var sheetName = "Gravity Forms Test Sheet"; // Replace this with the sheet name inside the Spreadsheet var status = {}; // Code based on Martin Hawksey (@mhawksey)'s snippet var lock = LockService.getScriptLock(); lock.waitLock(30000); try { var sheet = SpreadsheetApp.openById(sheetID).getSheetByName(sheetName); var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0]; // Add the data and time when the Gravity Form was submitted var column, row = [], input = { "timestamp": new Date() }; for (var keys in e.parameter) { input[normalize_(keys)] = e.parameter[keys]; } for (i in headers) { column = normalize_(headers[i]) row.push(input[column] || ""); } if (row.length) { sheet.appendRow(row); status = { result: "success", message: "Row added at position " + sheet.getLastRow() }; } else { status = { result: "error", message: "No data was entered" }; } } catch (e) { status = { result: "error", message: e.toString() }; } finally { lock.releaseLock(); } return ContentService .createTextOutput(JSON.stringify(status)) .setMimeType(ContentService.MimeType.JSON); } function normalize_(str) { return str.replace(/[^\w]/g, "").toLowerCase(); } ``` * Really sorry for the long post I just want to figure this out. I appreciate your help. Here is the failure email I received: * There was an error when trying to integrate with the 3rd party service {Service 1} ([https://script.google.com/macros/s/AKfycbyWce3ApBXG2CwobvA4e4hAYoTDhzwDdgsRqc_SIbP89klDCDox/exec](https://script.google.com/macros/s/AKfycbyWce3ApBXG2CwobvA4e4hAYoTDhzwDdgsRqc_SIbP89klDCDox/exec)). * **FORM** Title: SIGNUP NOW Intended Recipient: –na– Source: [http://hotjobing.com/browse-jobs/?search_keywords&search_location&search_category=22](http://hotjobing.com/browse-jobs/?search_keywords&search_location&search_category=22) * **SUBMISSION** Array ( [timeout] => 10 [body] => Array ( [First Name] => Tom[ Last Name] => Cotroneo [Email Address] => [tomcotroneo@gmail.com](https://wordpress.org/support/users/cotrones/replies/tomcotroneo@gmail.com?output_format=md)[ Phone Number] => (973) 303-0477 [Job Category] => E-Commerce [Edu. Level] => Completed HS or Ged [Interested In] => Yes ) * ) * **RAW RESPONSE** Array ( [headers] => Array ( [content-type] => text/html; charset =UTF-8 [content-length] => 1555 [date] => Wed, 27 Jul 2016 18:52:16 GMT ) * [body] => Error 400 (Bad Request)!!1

400. That’s an error.

Your client has issued a malformed or illegal request. That’s all we know. * [response] => Array ( [code] => 400 [message] => Bad Request ) * [cookies] => Array ( ) * [filename] => [safe_message] => physical request failure ) Viewing 3 replies - 1 through 3 (of 3 total)