· 4 min · TextMeFlow Team

WhatsApp Notification for Every Google Forms Submission

Many small businesses use Google Forms for quote requests, registrations or complaint forms, but the submissions often sit in a spreadsheet until someone happens to open it. With a small Apps Script, you can instead send a WhatsApp message straight away to yourself, your team or the customer, as soon as the form is submitted.

This article shows the shortest route: no Zapier or Make subscription needed, everything runs for free inside Google Forms/Sheets itself.

How it works

Google Forms automatically stores every submission in a linked Google Sheet. On that Sheet you can set an "On form submit" trigger that calls an Apps Script function. That function makes an HTTP request to the textmeflow API to send the message.

So three parts:

  1. The form + linked Sheet (you probably already have this)
  2. An Apps Script function that calls the API
  3. A trigger that links that function to "form submit"

Step 1: Get your API key and device ready

You need an active device in your textmeflow dashboard (linked via QR code) and an API key. You'll find both under your account settings. See the basic steps in /en/docs/getting-started if you haven't linked a device yet.

Note down:

  • your API key
  • the phone number you want to send to (e.g. your own number, in international format without + or 00)

Step 2: The Apps Script code

Open your Google Sheet → Extensions → Apps Script and paste this:

function onFormSubmit(e) {
  var values = e.namedValues; // object with { "Question": ["answer"] }
  var naam = values["Name"] ? values["Name"][0] : "unknown";
  var email = values["Email"] ? values["Email"][0] : "-";

  var tekst = "New form submission:\n"
    + "Name: " + naam + "\n"
    + "Email: " + email;

  var payload = {
    "to": "32470000000", // your receiving number
    "message": tekst
  };

  var options = {
    "method": "post",
    "contentType": "application/json",
    "headers": { "Authorization": "Bearer " + "YOUR_API_KEY" },
    "payload": JSON.stringify(payload)
  };

  UrlFetchApp.fetch("https://textmeflow.eu/api/messages", options);
}

Adjust the field names ("Name", "Email") to the exact question titles from your form. You'll find them in the column headers of the linked Sheet. The full list of parameters and the exact endpoint are in /en/docs/api.

Step 3: Set up the trigger

In the Apps Script editor:

  1. Click the clock icon (Triggers) on the left
  2. Add trigger
  3. Choose function onFormSubmit, event source From spreadsheet, event type On form submit
  4. Save. Google asks for permissions the first time, which is normal

Now fill in the form yourself once as a test. Within a few seconds you'll receive the WhatsApp message.

Sending a message to the customer too

Want to confirm to the person who filled in the form that you received their request, instead of (or in addition to) an internal notification? Then add a "Phone number" question to the form and use that number as the to field in a second API call within the same function. Keep consent in mind here: only send messages to people who explicitly opted in (e.g. a checkbox "I agree to be contacted via WhatsApp").

Points to watch

  • Speed: Apps Script triggers usually fire within a few seconds, but Google gives no hard guarantee, so don't count on sub-second handling for time-critical flows.
  • Rate limits: for forms with many simultaneous submissions (e.g. during a campaign) you may run into the standard rate limits. See /en/docs/rate-limits for the exact limits per plan.
  • Error handling: UrlFetchApp.fetch throws an exception on a non-2xx response. Catch this with a try/catch if you don't want a failed WhatsApp call to make the whole trigger fail.
  • No-code alternative: if you prefer a no-code flow with several steps (e.g. also a Slack message or a CRM update), have a look at the n8n/Make/Zapier approach at /en/docs/integrations.

Conclusion

For a simple "send me a WhatsApp on every form submission" flow you don't need any extra tool: Google Forms, Apps Script and the textmeflow API are enough, and it doesn't cost you an extra subscription. For more complex flows with several steps, an automation tool is the better choice.

No account yet? You can start free with 50 messages a month, forever, no credit card needed. Create a free account.

Want to send WhatsApp messages via API yourself?

Free forever up to 50 messages/month. Scan a QR and send your first message within 5 minutes.

Free forever