Is there way to have Google Sheets append the new data on the next line available on the data sheet?
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.
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.
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: https://support.supermetrics.com/support/discussions/topics/19000015753
Thanks yes I found the option to do this in Google sheets after I posted. Cheers
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