Append new data below existing lines (google sheets)

Is there way to have Google Sheets append the new data on the next line available on the data sheet?

4 people have this question
  • Hi Clayton,

    only by setting up a new query to the next line. When refreshing the old query, it updates the same cells. You can also change the old query in your "SupermetricsQueries" manually to use next row but you have to do this every time when you refresh if you wish to keep the old results.

    Best regards,

    Jouni Hyötylä

    Twitter: @Supermetrics 

    Support forum: supermetrics/forum

  • is there a way to utilise a formula for the query range so its selecting the first empty row below existing data? I want to pull 1-2 days worth of data and have it paste below existing data each day.

  • Hi,

    if you mean that you want to keep old results and append new ones, you can only do that in Supermetrics for Google Drive. Please see this solution:

    Best regards,

    -Supermetrics Team

  • Thanks yes I found the option to do this in Google sheets after I posted. Cheers

  • Hi clayton,

    Can you please let me know how to append new values in google sheets

  • In the side bar when you create each data pull, look under "options" at the bottom. There is a checkbox for "combine new results with old". Cheers

Login to post a comment