• 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

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

How to Add Rows in Google Sheets Without Overwriting Formulas?

sven-bo

Member
I’m having trouble with Google Sheets when adding new rows through Pabbly.

I want to add a new row to my spreadsheet but only update specific columns. For example, I have formulas in some columns that should not be touched. In my simplified example (see screenshot attached):
  • I want to enter First Name and Last Name in columns A and B.
  • Column C has a formula (e.g., =A2&" "&B2) to automatically combine the values.
When I try using the "Add New Row"-Action to leave the column blank using {{blank}}, {{skip}}, or leaving it empty in Pabbly, it overwrites the formula in column C with a blank value, which breaks the formula.

How can I add new rows while updating only specific columns without affecting formulas in other columns?

Thanks in advance!
 

Attachments

  • GS_Example_1.png
    GS_Example_1.png
    16.9 KB · Views: 55
  • GS_Example_2.png
    GS_Example_2.png
    19 KB · Views: 51

Preeti Paryani

Well-known member
Staff member
Hello @sven-bo,

The Google Sheets "Add New Row" API endpoint replaces any field containing a formula with a blank value upon execution. Unfortunately, this is how the endpoint functions, and we do not have a way to preserve the formula while adding a new row.
 
Top