• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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

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

Moderator
Staff member
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.

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.

1713545608516.png
 
Top