Make SQL like queries to Google spreadsheets and CSV files on your Google Drive.
1. Login to your Google account and open your Google Drive.
2. Create a folder with the name Quick Sheets on your Google Drive (e.g. My Drive > Quick Sheets)
3. Create Google spreadsheets or CSV files and copy them to the Quick Sheets folder. *** Please note that MS Excel files (.xls, .xlsx) are not compatible with the Quick Sheets ***
4. The structure of the spreadsheets and CSV files must follow the following conventions: - first row in the document must contains columns names - the second and following rows must represent the data - the data structure should be flat (e.g. no pivot tables)
Example (Students.csv):
Name Email Score Major Activity John john@gmail.com 78 Math Basketball Maria maria@live.com 83 Art Drama Club Alex alex@gmail.com 84 Math Debate
5. Use SQL like queries to find data in Google Spreadsheets and CSV documents: Note: - Maximum columns in the SELECT statement - 2 or you can use the key word 'all' (or 'everything') instead of column names: * SELECT name AND email WHERE ... * FIND all WHERE ... - Maximum columns in the WHERE statement - 2: * FIND all WHERE major IS Math AND activity IS basketball * GIVE ME name AND score WHERE major IS Art AND activity IS drama - Selects by date are not supported - Selects with expressions > (greater than), >= (greater than or equal), < (less than), <= (less than or equal) are not supported.
It is better to open the document first and then work with queries: Y: Alexa, ask Quick Sheets to open Students A: Great, opening Students. You can search by Name, Email, Score, Major and Activity. What would you like? Y: Find top 1 name by score A: Alex: 84
Examples of supported queries:
SELECT all WHERE email IS gmail (FIND everything WHERE email IS gmail) GIVE ME email AND score WHERE name IS john (FIND email AND score WHERE name IS john) SELECT COUNT WHERE major IS math (GIME ME COUNT WHERE major IS math) SELECT AVERAGE score WHERE major IS math (FIND AVG score WHERE major IS math) SELECT SUM score WHERE major IS math (GIME ME TOTAL score WHERE major IS math) SELECT TOP 3 name BY score (FIND TOP 3 name by score) SELECT LOWEST 3 name BY score (GIVE ME LOWEST 3 name BY score)
*** If you need a help, please drop us a line: support@voiceactivity.com *** *** More info: https://voiceactivity.com ***
market
