Whats API to Google Sheet not updating the sheet even though test is successful

[thecloudelite]

I have established the connection between Whats API cloud and Google Sheet and tested the workflow. The data were added to the sheet during the test. However, when I run an actual test with whats apps, i don't see the data coming into google sheet. Pabbly does consume the tasks so that means it is receiving the message but it is failing to upload it.

I have the headers in the file and i also tried adding blank for headers that i am not using in the integrations. why this is happening ? any ideas?

 

[ArshilAhmad]

Hi @thecloudelite,

Based on your Task History, we can see that the key received during automation has changed from what was captured during your workflow setup. During your workflow setup, it was captured as 'Assigned', and in automation, it's coming up as 'Incoming'. Since the keys have changed, it's not being recognized by the Google Sheets action step, and it's not getting through to your spreadsheet.

google_screen_recording_2024-04-19T16-46_20.641Z.webm

drive.google.com

We suggest that you click on 'Re-Capture Webhook Response' and try capturing a new message in your workflow setup. Once you have captured the new response, map that response in your Google Sheets action step and see if that fixes your issue in automation.