• 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.

update cell value for google sheet doesn't work

Your Task History ID
IjU3NjUwNTY0MDYzZTA0MzQ1MjZhNTUzYzUxMzQi_pc
My current workflow:
new or updated row of google sheet -> create new sheet on another spreadsheet -> update cel value for new sheet with source sheet value

My workflow history shows partial failure.
The error message is "Required field Value missing.".
However, I have filled up all values. It seems to me that Pabbly hasn't updated the workflow. The test goes fine, but after that, it doesn't update the value.

螢幕擷取畫面 2024-09-17 163113.png

螢幕擷取畫面 2024-09-17 163128.png
 
Last edited:

Preeti Paryani

Well-known member
Staff member
Hello @lelehelloworld

We have checked your workflow and as you have mentioned the trigger cell contains a formula, to capture the response in that case auto-send on schedule should be enabled, responses are sent every hour by default.

Please refer to the attached screenshot for more info.

image (19).png


While it is possible to reduce the response interval to one minute using an AppScript, we wanted to inform you that this might cause a conflict with the existing AppScript you’re already using. To better understand this process please refer to this thread - https://forum.pabbly.com/threads/google-sheets-1-minute-trigger.12927/

To help you better, could you please provide us access to your Google Sheet? This will allow us to look into the specifics and guide you through setting it up efficiently. Please provide us with access here - [email protected]
 

Attachments

  • 1726559332439.png
    1726559332439.png
    13.7 KB · Views: 67
Hello @lelehelloworld

We have checked your workflow and as you have mentioned the trigger cell contains a formula, to capture the response in that case auto-send on schedule should be enabled, responses are sent every hour by default.

Please refer to the attached screenshot for more info.

View attachment 47345

While it is possible to reduce the response interval to one minute using an AppScript, we wanted to inform you that this might cause a conflict with the existing AppScript you’re already using. To better understand this process please refer to this thread - https://forum.pabbly.com/threads/google-sheets-1-minute-trigger.12927/

To help you better, could you please provide us access to your Google Sheet? This will allow us to look into the specifics and guide you through setting it up efficiently. Please provide us with access here - [email protected]
I have changed the content of my thread.
Now the trigger cell is not a formula, so it's fine with the original setting.
The new issue is fail to update cell value. Please refer to my workflow ID. You may find the failed workflow history.
 

Preeti Paryani

Well-known member
Staff member
Hello @lelehelloworld

You are receiving a partial failure because a sheet with the same name captured from the trigger step already exists. This leads to a different response format, causing the update step to receive empty fields.

Could you please elaborate on your use case and let us know exactly what you're trying to achieve? This will help us understand your workflow better and provide you with more precise assistance.
 
Top