How To Change/Edit Sheet Location For Saved Queries?

You can change the sheet location by simply editing the 3 columns in the saved_queries sheet.

1. Spreadsheet ID
2. SheetName
3. Cell

Here are the steps:

1. Go To Saved Queries Sheet.
2. Copy the destination Spreadsheet Id & paste it in the spreadsheet Id column. (You can find the spreadsheet Id in the address bar.)
    
3. Enter the sheet name of the destination spreadsheet. (If sheet name is not found, a new sheet with that name will be created)
4. Enter the cell of the destination sheet.

Finally, run test queries to check if the data is imported in the correct location.