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.

I have a zap set up to send data from hubspot to a google sheet. 

The action if to create a new spreadsheet row. In the past it’s always added this at the bottom on the sheet, however, now this is adding it at the top.

I want it to go back to adding it at the bottom. Any ideas?

 

 

Hi @otimo!

Hmm, that’s not what we want is it? Have you made any changes to the Zap or Google Sheet recently

The first thing to mention is that you need to be careful about changes to your spreadsheet while the Zap is turned on. Specifically, if you make any of the following changes while the Zap is on it can cause errors:

  • Deleting existing rows or columns.
  • Adding rows anywhere other than to the bottom of your sheet.
  • Resorting the sheet.
  • Renaming/adding/rearranging columns.
  • Renaming the sheet.
  • Filtering the sheet.

If you need to make any of those changes to your Google Sheet, turn your Zap off while you work on the spreadsheet, and then turn it back on again.

 

If you haven’t made any changes to your Zap or the sheet, could you share more about your Zap? What trigger/actions do you have? And could you please share a screenshot of the step that adds a row to your sheet. Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).

​I hope that's clear, please let us know if you have any questions!

Hi @Danvers !

So the trigger is an incoming text with a specific phrase. This has been working as it used to send the team a notification in slack as you can see in the photo below. When I run a test for adding a new row, it adds it at the top above my titles

 

Hi @otimo, I’ve had this happen to me before! Unsure if this is the “official” fix, but perhaps you can try this. Make sure the text for your titles is different than the text underneath them, even if it’s just bolded out. You can also try freezing the row at the top. As Danvers mentioned, please make sure your Zap is turned off before making any changes! 

Hi @otimo 

Make sure to review the available help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

Terms & Conditions