Webhook to Google Sheets with duplicate check by Flowpaja

Flowpaja created this template. It receives JSON from any app or script through a Make custom webhook and writes each request to Google Sheets once, using a request_id to skip repeats.

How it works: the webhook receives name, email, message, source, submitted_at and request_id. A filter stops requests without a request_id or email. Google Sheets "Search Rows" looks for the request_id in column F. "Add a Row" runs only when it isn't found, and writes the data with a received_at time. Retry handlers cover temporary Google errors.

Apps: Webhooks and Google Sheets.

Sheet: a tab named Leads with these headers in row 1: submitted_at, name, email, message, source, request_id, received_at.

Setup:

1. Copy the example sheet or add the headers.
2. In the webhook module, click Add to create your own webhook and copy its URL.
3. Connect Google and pick the spreadsheet and the Leads tab in both Sheets modules.
4. Click Run once and send a test request, so Make learns the fields.
5. Switch the scenario on. Send a unique request_id per submission, and the same one on retries.

Credits (measured in our test): 3 for a new request, 2 for a duplicate, 1 for a request stopped by the filter.

Settings: Store incomplete executions (needed by Retry) and Process data in order are on, so copies of one request are checked one at a time.

Example sheet, test requests and setup guide: https://flowpaja.com/templates/webhook-to-sheets-dedupe-free/ Flowpaja is independent of Make and Google.