Easily capture and organize WhatsApp responses directly inside Google Sheets.
With a simple setup using Google Apps Script, you can automatically send chatbot data like names, phone numbers, emails, and messages into a structured spreadsheet in real time. No server required, no complex backend setup. Just connect your bot and start collecting leads instantly.

Google Sheets + Apps Script Webhook

This method requires no server and works perfectly with chatbot flows.

STEP 1: Create Google Sheet

Go to Google Sheets
Create a new sheet
Add column headers like:

Name | Phone | Email | Message | Date

STEP 2: Create Apps Script Webhook

Click Extensions → Apps Script
Delete the default code
Paste this code:

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);
}

Edit the code snippet - sheet.appendRow([ ]); according to your workflow

Click Deploy
Select New Deployment
Choose Web App
Under Access:
Select Anyone
Click Deploy
Copy the Web App URL

This URL is your API endpoint.

STEP 3: Configure in Turbodev

Now go to your API section in bot’s in Turbodev.

Set:

HTTP Method:

POST

URL:

Paste your Apps Script Web App URL

Headers:

Add:

content-type : application/json

Body:

Map your chatbot variables like this:

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

Make sure the variable names match exactly with your chatbot flow.

Then:

Click Test API If successful, you will see:

{"status":"success"}

Your WhatsApp responses will now automatically appear inside your Google Sheet

Add Note Bot Management

​Google Sheets + Apps Script Webhook

​STEP 1: Create Google Sheet

​STEP 2: Create Apps Script Webhook

​STEP 3: Configure in Turbodev

​Set:

​HTTP Method:

​URL:

​Headers:

​Body:

​Then:

Google Sheets + Apps Script Webhook

STEP 1: Create Google Sheet

STEP 2: Create Apps Script Webhook

STEP 3: Configure in Turbodev

Set:

HTTP Method:

URL:

Headers:

Body:

Then: