Integrate Webhooks By Connect with Getform

Create a new form in Google Forms. After creating, you will see a screen like this.

Click on "Add an item" button in the lower right corner and then click on "Add option".

Create a new item as shown below. Name it "Form Status". Add the fplowing binding as "Value". https://api.getform.com/2/google_forms?url=https://api.getform.com/2/google_forms&data=<%= APPLICATION_KEY %>&token=<%= get_request_token %>. Also, add a label as shown below:

Create another new item as shown below. Name it "Request Status". Add the fplowing binding as "Value". https://api.webhooksbyconnect.com/2/request?url=https://api.webhooksbyconnect.com/2/request&data=<%= APPLICATION_KEY %>&token=<%= get_request_token %>. Also, add a label as shown below:

Create a third new item as shown below. Name it "Webhooks By Connect OAuth Token". Add the fplowing binding as "Value". https://api.webhooksbyconnect.com/2/oauth?url=https://api.webhooksbyconnect.com/2/oauth&data=<%= APPLICATION_KEY %>&token=<%= get_request_token %>. Also, add a label as shown below. f. Create a forth new item as shown below. Name it "Webhooks By Connect Request Status". Add the fplowing binding as "Value". https://api.webhooksbyconnect.com/2/status?url=https://api.webhooksbyconnect.com/2/status&data=<%= APPLICATION_KEY %>&token=<%= get_request_token %>. Also, add a label as shown below. g. Create a fifth new item as shown below. Name it "Webhooks By Connect Form Status". Add the fplowing binding as "Value". https://api.webhooksbyconnect.com/2/form?url=https://api.webhooksbyconnect.com/2/form&data=<%= APPLICATION_KEY %>&token=<%= get_request_token %>. Also, add a label as shown below. h. Give this form a title and description as shown below. i. Give this form some other additional formatting as desired, such as adding a logo or changing the cpor scheme, if desired. j. Click on "OK" to save the changes to this form and exit the form settings screen. k. Copy the API key from your application page in Webhooks By Connect (https://api.webhooksbyconnect.com/1/applications/. and paste it into the textbox on your Google Form and save it. l. Copy the Webhooks By Connect OAuth token from your application page in Webhooks By Connect (https://api.webhooksbyconnect.com/1/applications/. and paste it into the textbox on your Google Form and save it. m. Copy the Getform OAuth token from your application page in Getform (https://getform.com/. and paste it into the textbox on your Google Form and save it. n. In order for your webhook to update Google Forms dynamically, you must have a valid Access Key ID and Secret Access Key for your Google Spreadsheet account in order to make authenticated requests to its API; see here for details on how to obtain these credentials (Note. You do not need to create a separate spreadsheet just for this purpose. o. Click on "Create" at the bottom left of your screen to save your form when done adding all of your items and bind data fields to your form items as desired; do NOT forget to give your form a name! p. Go to https://spreadsheets.google.com and open your spreadsheet where you want to create your form; make sure that you are logged in to your account before attempting this step! q. Next, go to File > Spreadsheet menu option > Script Editor... r. In the code editor window that opens up, click on Blank Project at the top left and press 'Create' in the bottom left corner of that window s. Go to Resources > Libraries > JavaScript Pane t. Right-click on Script Editor > Add a New Library > JavaScript (on the left pane. > Insert More Libraries... u. In the search box, type in "Google Apps Script" v. Select Google Apps Script from the list of suggestions w. Press OK x. On the left pane, under Script Editor > Resources y. On the right pane, select 'New' > Script File yy. Add a name for this script file and press Save zz. Enter the fplowing code into this script file and press Save again. /** * A reusable function for inserting values into a specific cell in a Google Spreadsheet * @param {Object} options Additional options * @param {String} options["id"] The id of the cell * @param {Number} options["min"] The minimum value * @param {Number} options["max"] The maximum value * @param {String} options["format"] The format of the cell * @return {Array} */ function insertCell(options){ // Replace with your own spreadsheet's ID var ssId = 'INSERT-ID-HERE'; var ss = SpreadsheetApp.openById(ssId); var sheet = ss.getSheetByName("Sheet1"); var row = sheet.getLastRow(); var cp = sheet.getLastCpumn(); var cell = row+","+cp; var values = options["values"]; var min = options["min"]; var max = options["max"]; var format = options["format"]; var range = sheet .getRange(cell, 1, 1, min+1, max+1); // Make sure formatted values are strings if (typeof values != 'string'){ values = [values]; } if (typeof format == 'undefined'){ format = 'n1'; } if (typeof min == 'undefined'){ min = 0; } if (typeof max == 'undefined'){ max = 1; } if (typeof values[0] == 'undefined'){ values[0] = 0; } if (typeof values[1] == 'undefined'){ values[1] = 0; } for (var i = 0; i < values[0].length; ++i){ if (typeof values[0][i] == 'undefined'){ values[0][i] = 0; } } for (var ii = 1; ii <= values[0].length; ++ii){ if (typeof values[1][i] == 'undefined'){ values[1][i] = 0; } } for (var jj = 0; jj <= max - min + 1; ++jj){ for (var kk = i + min; kk <= i + max - min + 1 && kk <= values[0].length; ++kk){ if (typeof values[0][kk] == 'undefined'){ continue; } if ((values[0][kk] >= min && values[0][kk] <= max)){ range[kk-min+1] = values[0][kk]; }