Binary Output When Sending JSON Data from Webhook to Google Sheets

Jordan_Karim · May 29, 2024, 11:44pm

Description:

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.

Details:

Webhook Module:

The Webhook module is configured to receive JSON data from an external service.

{
“name”: “John Doe”,
“email”: “johndoe@example.com”
}

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.

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.

Problem:

Despite these configurations, the data in Google Sheets appears as binary instead of the expected text.

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