Import Google Spreadsheet into a Google Spreadsheet -
i'm trying import url query of google spreadsheet google spreadsheet. on webpage use url this: https://docs.google.com/a/chiseledimages.com/spreadsheet/tq?tqx=out:html&tq=select%20c,d,e,f,g,h,i%20where%20%28a%20contains%20301%29&key=0auoqku9htnwvdg5 create table referenceing specified doc , selecting columns column equals clients account number, in case 301. what want have spreadsheet automatically fill data url. tired =importdata(" https://docs.google.com/a/chiseledimages.com/spreadsheet/tq?tqx=out:html&tq=select%20c,d,e,f,g,h,i%20where%20%28a%20contains%20301%29&key=0auoqku9htnwvdg5 ") seemed import html , not fill sheet data. want able client can have google spreadsheet auto filled data @ times, while not having direct access original spreadsheet clients data. i'm not sure if you're looking for, typically use importrange pull data 1 sheet another. http://support.google.com/drive/bin/answer.py?hl=en&answer=155183