paguecombitcoin
Member
- Your Task History ID
- IjU3NjYwNTZkMDYzNjA0MzI1MjY0NTUzNjUxMzUi_pc
Hello, everyone!
I need help collecting data from a standard webhook via POST and transforming it into rows in Google Sheets.
Here’s the situation: the data is being sent from a chatbot software where a survey is conducted. Each survey response is saved in a variable within the program. In Pabbly, I’m receiving this information via HTTP request, and it’s arriving correctly, labeled as “contactdata1”, “contactdata2”, and so on. All 15 responses are being received in Pabbly without any issues.
The problem occurs when I try to take the next step, which is creating a row in Google Sheets with this information. I’m getting the following error:
Error Code: 400
Error Message: Invalid JSON payload received. Unknown name "": Root element must be a message.
Error Status: INVALID_ARGUMENT
Error Details 0 @type: type.googleapis.com/google.rpc.BadRequest
Error Details 0 FieldViolations 0 Description: Invalid JSON payload received. Unknown name "": Root element must be a message.
It seems that the issue is with how I’m trying to pass the data to the sheet. I’ve connected the sheet correctly using the integrated Google Sheets app in Pabbly, but I’m not sure how to resolve this error. Could someone please help me?
I need help collecting data from a standard webhook via POST and transforming it into rows in Google Sheets.
Here’s the situation: the data is being sent from a chatbot software where a survey is conducted. Each survey response is saved in a variable within the program. In Pabbly, I’m receiving this information via HTTP request, and it’s arriving correctly, labeled as “contactdata1”, “contactdata2”, and so on. All 15 responses are being received in Pabbly without any issues.
The problem occurs when I try to take the next step, which is creating a row in Google Sheets with this information. I’m getting the following error:
Error Code: 400
Error Message: Invalid JSON payload received. Unknown name "": Root element must be a message.
Error Status: INVALID_ARGUMENT
Error Details 0 @type: type.googleapis.com/google.rpc.BadRequest
Error Details 0 FieldViolations 0 Description: Invalid JSON payload received. Unknown name "": Root element must be a message.
It seems that the issue is with how I’m trying to pass the data to the sheet. I’ve connected the sheet correctly using the integrated Google Sheets app in Pabbly, but I’m not sure how to resolve this error. Could someone please help me?
