Skip to content

Instantly share code, notes, and snippets.

@adamamyl

adamamyl/IMPORTQUERY

Created September 29, 2015 21:12
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save adamamyl/efe24c4a3abb0ae980bd to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save adamamyl/efe24c4a3abb0ae980bd to your computer and use it in GitHub Desktop.
Download ZIP
Import selected stuff from another google doc
Raw
IMPORTQUERY
=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PQe7nPK97toYYocbqMX7qn2_6F6w2FpW7Bf4waOLucw/edit#gid=1402173896", "Form Responses 1!A1:H500"), "SELECT Col2, Col7, Col3, Col4, Col5, Col6, Col8 where Col5 CONTAINS 'Decor'",1)
=QUERY(IMPORTRANGE("
https://docs.google.com/spreadsheets/d/1PQe7nPK97toYYocbqMX7qn2_6F6w2FpW7Bf4waOLucw/edit#gid=1402173896", // LINK TO SHEET
"Form Responses 1!A1:H500" // RANGE TO SELECT FROM
),
"SELECT Col2, Col7, Col3, Col4, Col5, Col6, Col8 WHERE Col5 CONTAINS 'Decor'",1) // NOTE, here, we can't use B, G, C, D etc -- convert to Col#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment