Google Forms

​

Connect Google Forms

    const KERUX_URL = "PASTE_YOUR_KERUX_URL_HERE";
    
    function sendToKerux(e) {
      const answers = {};
      e.response.getItemResponses().forEach(function (r) {
        const value = r.getResponse();
        answers[r.getItem().getTitle()] = Array.isArray(value) ? value.join(", ") : String(value);
      });
      UrlFetchApp.fetch(KERUX_URL, {
        method: "post",
        contentType: "application/json",
        muteHttpExceptions: true,
        payload: JSON.stringify({
          response_id: e.response.getId(),
          form_id: e.source.getId(),
          form_name: e.source.getTitle(),
          submitted_at: e.response.getTimestamp().toISOString(),
          email: e.response.getRespondentEmail(),
          answers: answers,
        }),
      });
    }

​

Choose where each field goes

• Automatic is Kerux’s guess. It uses the field’s type when Google Forms sends one (an email question is the email), then the question’s words (First name, Company, Job title, Phone…), and any answer that is an email address or a LinkedIn profile URL.
• Pick another target to change it: Email, First name, Last name, First and last name, Phone, Company, Job title, Location, Address, City, Country, Postal code, LinkedIn profile, a Custom field (use it in messages as {{contact.custom.<name>}}), or Don’t keep.
• Click Save mapping. Every next submission uses it.

​

Start a campaign from the form

​

Good to know

• No LinkedIn profile? They still come in. People without a LinkedIn URL become contacts by their email. Email and other steps run; LinkedIn steps wait (shown in Home > Tasks with the reason missing LinkedIn URL) until someone adds their profile, then continue by themselves.
• Never twice. Google Forms may send the same submission again (a retry, a test sent twice): Kerux recognizes it by its response id and adds the person once. Someone who is already a contact is updated: empty fields are filled, their answers are saved as custom fields.
• One URL per form. Make as many URLs as you like (Add another URL), so each campaign can pick its own.
• If the URL leaks, click Make a new URL on its card: the old one stops working at once. Paste the new one in Google Forms. Turn off stops the URL for good.
• Limits. Each URL takes up to 60 requests a minute; more get an answer to try again later. A body can be up to 256 KB.
• Only workspace owners and admins can make URLs and see them. Members see Ask an admin on the row.
• Answers are data, never instructions: whatever someone types in your form is stored as text, nothing else.

​

With the API

​

Sources

• Google: Installable triggers, FormResponse and UrlFetchApp.