DEV Community

Discussion on: I've written a Google Sheet to SQL automation using WayScript

Collapse
 
easrng profile image
easrng

You can query GSheets with SQL and have it output CSV. The catch is, there is no where clause. You use the gid query parameter to specify what sheet to query. the url format is https://docs.google.com/spreadsheets/d/*sheetid*/gviz/tq?tqx=out:csv&tq=*SQL query*&gid=*sheetid*