Connect WhatsApp and Google Sheets

Save customer answers to a spreadsheet as they come in. A bot collects the details, an HTTP Request step sends them to a Google Apps Script, and the script adds a row.

This only uses the HTTP Request step, so the same idea works for any service that accepts a webhook. Google Sheets is just a handy example.

Note

LoopChat also has built-in Google Sheets steps: Get Sheet Record, Add Sheet Record, Update Sheet Record and Delete Sheet Record, in the Integrations group. They need the Google Sheets integration connected under Configure → Integration. The Apps Script method below doesn’t need any integration.

Step 1: Create the sheet

1. Create a new Google Sheet.
2. Add column headings:

Name | Phone | Email | Message | Date

Step 2: Create the Apps Script

1. Click Extensions → Apps Script.
2. Delete the code that’s there.
3. Paste this:

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);

  sheet.appendRow([
    data.name,
    data.phone,
    data.email,
    data.message,
    new Date()
  ]);

  return ContentService
    .createTextOutput(JSON.stringify({status: "success"}))
    .setMimeType(ContentService.MimeType.JSON);
}

Change the list inside sheet.appendRow([ ]) to match your own columns.

4. Click Deploy → New deployment.
5. Choose Web app.
6. Under Who has access, choose Anyone.
7. Click Deploy and copy the Web app URL.

Caution

A web app open to Anyone can be called by anyone who has the URL. Keep it private, and don’t use this method for sensitive data: the script has no login of its own.

Step 3: Set up the HTTP Request step

In your bot, add an HTTP Request step from the Integrations group and open it.

Setting	Value
HTTP Method	POST
URL	Your Apps Script web app URL
Headers (JSON format)	{"Content-Type": "application/json"}
Request Body (JSON format)	See below

Put your bot’s variables into the body:

{
  "name": "{{name}}",
  "phone": "{{phone}}",
  "email": "{{email}}",
  "message": "{{message}}"
}

Note

Use the variable names your bot actually saves. If an earlier step saved the answer as customer_email, write {{customer_email}}, not {{email}}.

The step has Success and Failed outputs, so you can tell the customer if something went wrong.

Step 4: Test

Click Test API, then check your sheet for the new row.

Note

Google Apps Script answers with a redirect, and LoopChat doesn’t follow redirects. So the test, and the step at run time, may report a redirect (status 302) or take the Failed output even though the row was added. Check the sheet itself. If the row is there, the connection works; connect both outputs to the same next step so customers don’t see an error.

Step 5: Publish

Click Publish Now. From then on, every customer who reaches the step adds a row to your sheet.

If rows don’t appear

• Nothing arrives: check that the deployment is open to Anyone, and that you copied the web app URL, not the script editor’s address.
• Rows have empty cells: a variable name in the body doesn’t match what the bot saved. Check the bot’s Logs for what was collected.

Going further

The same settings, method, URL and body, work for any API. Swap the Apps Script URL for your CRM or your own system and the bot sends data there instead.