Connecting a Google Sheet via Webhook

This setup allows you to automatically send data from Chekkit (or any other app) directly into a Google Sheet; no manual copy-pasting required.

Each time data is sent to your webhook (for example, when a lead form is submitted or an automation runs), a new row will automatically be added to your Google Sheet.

When the webhook receives data, the script:

1. Opens your Google Sheet (specifically a sheet named “Sheet1”).

   Reads the data sent by the webhook (e.g., name, phone, email, message text).

   Adds a new line to the sheet with:

   • The current date and time in the first column.
   • The submitted details in the following columns.
2. Sends back a confirmation response to confirm successful delivery.

How to Install and Activate the Script

1. Open Your Google Sheet

• Create or open the Google Sheet where you want incoming data to appear.
• Make sure your first sheet is named “Sheet1” or update the script later to match your sheet name.

2. Open the Script Editor

• In the top menu, click Extensions → Apps Script.
• A new tab will open with the Google Apps Script editor.

3. Add the Script

• Delete any existing code in the editor.
• Copy and paste the following script:

function doPost(e) {  
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');  
  const data = JSON.parse(e.postData.contents);  

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

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

4. Save the Script

• Click the Save icon or press Ctrl + S (Windows) / Cmd + S (Mac).

• Name your project (e.g., “Webhook to Sheet”).

5. Deploy as a Web App

1. Click Deploy → New deployment.
2. Select Web app as the deployment type.
3. Under Execute as, choose Me (your account).
4. Under Who has access, choose Anyone or Anyone with the link.
5. Click Deploy.
6. Approve the requested permissions when prompted.

6. Copy the Web App URL

After deploying, you’ll receive a unique URL such as:

https://script.google.com/macros/s/AKfycbyEXAMPLE12345/exec 

This URL is your Webhook Endpoint.

7. Connect to Chekkit (https://dashboard.chekkit.io/settings/inbound-webhook)

• Go to your Chekkit dashboard.
• Navigate to Settings → Textchat → Inbound Message Webhook URL
• Paste your Web App URL into the Inbound Message Webhook URL field.
• Save the changes.

Now, any data sent to this URL (e.g., from a form submission, automation platform, or app) will instantly appear in your Google Sheet as a new row.

Notes and Troubleshooting

• Ensure your sheet name matches exactly ("Sheet1"  by default).
• The sheet must belong to the same Google account used to deploy the script.
• If no data appears, double-check that your webhook POST request uses JSON format matching the fields in the script (name, phone, email, text ).

Example Use Cases

• Lead Collection from Web Forms

  Automatically send new website or landing page form submissions straight into a Google Sheet for easy lead tracking and follow-up.

• Appointment or Quote Requests

  When customers request an appointment or quote through your Chekkit form, their details are instantly logged in a shared Google Sheet for your team to review.

• Customer Feedback Logging

  Store all customer survey responses or review requests in one Google Sheet to analyze feedback trends over time.

• Marketing Automation Tracking

  Send data from automated campaigns (e.g., form fills, sign-ups, or event registrations) directly into Sheets for quick reporting.

• Support Ticket or Inquiry Log

  Keep a running list of all inbound Chekkit messages, including customer names, phone numbers, and messages, for internal audit or reporting purposes.

• Multi-Location Reporting

  Use separate webhooks for each business location so messages or leads are automatically categorized in different sheets.

* * * 

Hopefully, this helps you get everything running, but if you have any difficulties or other questions, please get in touch with us at support@chekkit.io!