{"id":173,"date":"2025-05-02T14:06:06","date_gmt":"2025-05-02T14:06:06","guid":{"rendered":"https:\/\/znicrm.com\/guide\/?p=173"},"modified":"2025-05-02T14:09:10","modified_gmt":"2025-05-02T14:09:10","slug":"connect-google-form-or-google-sheets-with-crm","status":"publish","type":"post","link":"https:\/\/znicrm.com\/guide\/173\/connect-google-form-or-google-sheets-with-crm\/","title":{"rendered":"Connect Google Form or Google Sheets With CRM"},"content":{"rendered":"\n

To integrate the ZNICRM WebLead API with Google Forms, follow these steps:<\/p>\n\n\n\n

Step 1: Generate Your ZNICRM API Key<\/h2>\n\n\n\n
  1. Log in<\/strong> to your ZNICRM dashboard.<\/li>
  2. Navigate to Settings<\/strong>.<\/li>
  3. In the left menu, select Developers \u2192 API Key<\/strong>. How To Generate API Key For CRM<\/a><\/li>
  4. Click the \u201cAdd Key\u201d<\/strong> button to generate a new API key.<\/li>
  5. Copy and securely store the generated API key.<\/li><\/ol>\n\n\n\n

    Step 2: Create and Link Your Google Form<\/h2>\n\n\n\n
    1. Create<\/strong> your Google Form with the necessary fields (e.g., Name, Email, Phone).<\/li>
    2. Click on the Responses<\/strong> tab.<\/li>
    3. Click the \u201cLink to Sheets\u201d<\/strong> icon to create a linked Google Sheet that will store form responses.<\/li><\/ol>\n\n\n\n

      Set Up Google Apps Script<\/h2>\n\n\n\n
      1. Open the linked Google Sheet.<\/li>
      2. Click on Extensions \u2192 Apps Script<\/strong>.<\/li>
      3. Delete any existing code in the script editor and replace it with the following:<\/li><\/ol>\n\n\n\n
        function onFormSubmit(e) {\n  var responses = e.values;\n\n  \/\/ Adjust indices based on your form's structure\n  var leadName = responses[1];  \/\/ Assuming 'Name' is the second column\n  var leadEmail = responses[2]; \/\/ Assuming 'Email' is the third column\n  var leadPhone = responses[3]; \/\/ Assuming 'Phone' is the fourth column\n\n  var apiKey = 'YOUR_API_KEY'; \/\/ Replace with your actual API key\n  var departmentId = ''; \/\/ Optional: Replace with your department ID if applicable\n  var leadQuery = 'Form submission from Google Forms';\n  var leadConversionPage = 'Google Form';\n  var leadIP = ''; \/\/ Optional: You can capture the IP if available\n\n  var params = {\n    apikey: apiKey,\n    leadName: leadName,\n    leadEmail: leadEmail,\n    leadPhone: leadPhone,\n    department: departmentId,\n    leadQuery: leadQuery,\n    leadConversionPage: leadConversionPage,\n    leadIP: leadIP\n  };\n\n  var queryString = Object.keys(params)\n    .map(function(key) {\n      return encodeURIComponent(key) + '=' + encodeURIComponent(params[key]);\n    })\n    .join('&');\n\n  var url = 'https:\/\/api.intueri.io\/weblead.php?' + queryString;\n\n  try {\n    var response = UrlFetchApp.fetch(url);\n    Logger.log('Response: ' + response.getContentText());\n  } catch (error) {\n    Logger.log('Error: ' + error);\n  }\n}\n<\/code><\/pre>\n\n\n\n
        Note:<\/strong> Adjust the responses<\/code> indices to match the order of your form fields. The first element (responses[0]<\/code>) is the timestamp.<\/p>\n\n\n\n
        Step 4: Set Up a Trigger for Form Submissions<\/h2>\n\n\n\n
        1. In the Apps Script editor, click on the Triggers<\/strong> icon (clock symbol) in the left sidebar.<\/li>
        2. Click \u201c+ Add Trigger\u201d<\/strong>.<\/li>
        3. Set the following: