SmartSuite - One platform for all your business needs

info@smartsuite.co.in

Google Form Integration

Here’s a step-by-step breakdown based on your instructions for integrating the script into Google Forms:

1. Go to your Google Form's edit mode.

2. Click the three-dot "More" button (on the top-right of the form).

3. Open the "Script Editor" from the dropdown.

4. Copy the following code and paste it inside the Script Editor:

function callFormsAPI(e) {
                                        var formResponse = e.response;
                                        var itemResponses = formResponse.getItemResponses();
                                        var params = {};
                                        for (var i = 0; i < itemResponses.length; i++) {
                                          var itemResponse = itemResponses[i];
                                          var question = itemResponse.getItem().getTitle();
                                          var answer = itemResponse.getResponse();
                                          params[question] = answer;
                                        }
                                        params.userId = "ENTER_USER_ID"; // add your user id
                                        params.companyId = "ENTER_COMPANY_ID"; // add your company id
                                        var formsAPIUrl = 'ENTER_BASE_URL';
                                        var options = {
                                          'method': 'post',
                                          'contentType': 'application/json',
                                          'muteHttpExceptions': true,
                                          'payload': JSON.stringify(params)
                                        };
                                        try {
                                          var response = UrlFetchApp.fetch(formsAPIUrl, options);
                                          var responseCode = response.getResponseCode();
                                          var responseBody = response.getContentText();
                                          Logger.log('Response code: ' + responseCode);
                                          Logger.log('Response body: ' + responseBody);
                                        } catch (error) {
                                          Logger.log('Error: ' + error.message);
                                        }
                                       }

5. Update the placeholders in the code:

Open app mobile app google form integration and click on view

● Replace "ENTER_USER_ID" with your User ID.
● Replace "ENTER_COMPANY_ID" with your Company ID.
● Replace 'ENTER_BASE_URL' with your API's base URL.

6. Press Ctrl + S to save the script

7. Go to the left-hand sidebar in the script editor and click on "Triggers" (the clock icon).

8. Add a new trigger:-

● Select the function: callFormsAPI
● Select the event type: "On Form Submit"
● Click "Save" and follow the prompts to continue with Google authentication.

9. Go back to your Google Form's edit mode and copy the form's URL.

10. Paste the Google Form URL here if needed or to connect the process:

(You can provide it now if you need help confirming the setup further.)

11. Check the connected fields during the API integration and mapping process. Then, submit a test response to verify the connection.