Google sheet insert formula

[javiermarcon]

Whenever I try to add a formula to the "add row" google sheet action, it gives an invalid argument error.

The workflow is https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZiMDYzNDA0MzY1MjZiNTUzMDUxMzQi_pc

 

[ArshilAhmad]

Currently, it's not possible to add formulas to a spreadsheet through the Google Sheets action step.

 

[Fagun Shah]

Whenever I try to add a formula to the "add row" google sheet action, it gives an invalid argument error.
View attachment 40315
The workflow is https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZiMDYzNDA0MzY1MjZiNTUzMDUxMzQi_pc

The screenshot is for Append Row not Add New Row.

Here is my video where I am passing formulas dynamically completely fine using Google Sheet - Add New Row action -