Append new conversations to a Google Sheet

Every new customer email lands in a spreadsheet, with their name and a link to the thread.

Fernand fills in ${contact_name}, ${subject}, and ${url} when this runs.

When the next email arrives

A sheet is a blunt log: who wrote, what the subject was, and the link, one row each. Deploy a Google Apps Script as a web app that appends the JSON, and paste that URL into the rule. Anyone with the URL can post, so do not share it.

Make and Zapier can write the same row if you would rather not maintain a script. Point the webhook at their catch URL instead.

How to add this rule

  1. Deploy the Apps Script web app, or a Make/Zapier step, that appends contact, subject, and conversation.
  2. Paste that URL into Send to a webhook with the JSON from the preview.
  3. Create one conversation and check the next empty row.

While you set this up

The whole library

Also in Webhook