Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Hubspot to Google Sheets - How to insert data into an existing row that has formulas

Hi, I’ve made a Loom video to provide further clarification on what we’re trying to accomplish.

 

In short, I have the trigger and everything from the Hubspot side all set up, but I just need to insert the data in Columns A-F into an existing row (Row 34 in my example, then the next Zap trigger it’ll need to go to Row 35, then 36, etc) because Columns G through Z have formulas that I’d like to leave untouched.

Unfortunately on my first attempt, the Zap created a new row and would then require me to pull down the formulas on about 25 columns. I would love for it to know to look for the next blank cell/row in Column A, input the 6 cells of data, and then use the next one for the following Zap trigger.

 

Thanks!

Justin

 

 

 

Hi @Justin-at-Singenuity 

For the Zap action GSheet Update Row, you need to provide a Row/ID (#) for the Row to update.

If you just want the Zap to update the next row, then you can use Storage.

Set a Key value for the next Row to update, then increment by +1 each time the Zap Runs.

Use the Zap action: Storage Get Value

 

Hi @Troy Tessalone, I appreciate the help. Unfortunately, I’m still a bit confused on getting it set up. Do you mind providing a step-by-step guide on how to set up the scenario?

At the moment, here’s what we have so you can inform me where the “Get Value” and “Increment Value” would go in the hierarchy.

The goal is for the Zap to just update the next available row and increment by +1 each time it runs.

 

Thank you!

 

 

@Justin-at-Singenuity

The Storage Get Value step can go before the GSheet step.

The Storage Increment Value can go after the GSheet step.

 

When in doubt, test it out.

Terms & Conditions