Binary Output When Sending JSON Data from Webhook to Google Sheets


I am working on a small test automation scenario in where I am receiving JSON data via a Webhook and then trying to add that data to a Google Sheets spreadsheet. However, I am encountering an issue where the data is being output as binary instead of the expected JSON format.


  1. Webhook Module:
  • The Webhook module is configured to receive JSON data from an external service.

“name”: “John Doe”,
“email”: “

  1. Expected Data Handling:
  • I expect the JSON data to be parsed and then added to Google Sheets with name and email fields being mapped to respective columns.
  1. Current Configuration:
  • Webhook Module: Receives the JSON payload.
  • Create JSON Module: Attempted to create a JSON structure to format the data correctly.
  • Google Sheets Module: Maps the parsed fields to the columns in the spreadsheet.
  1. Problem:
  • Despite these configurations, the data in Google Sheets appears as binary instead of the expected text.
  1. Troubleshooting Steps Taken:
  • Ensured the Webhook correctly receives the JSON data.
  • Added a “Create JSON” module to explicitly format the data.
  • Used a “JSON Parse” module to correctly interpret the JSON data.
  • Set the Content-Type header in the Webhook response to application/json;charset=utf-8.

Please see images of setup and output below

Many thanks in advance.

Welcome to the Make community!

You are wasting an operation here.

Delete the Create JSON module,

In the Webhook module, edit the webhook and select JSON-pass through set to YES.

samliewrequest private consultation

Join the unofficial Make Discord server to chat with us!

1 Like