Make sure you have created Google Sheets integration
In your block with the data you want send, click the
Focus on Block
icon which should bring up a Settings sidebar in the right hand side like this:Under Destination, select Google Sheets. Once selected options for Integration, Spreadsheet Id, and Sheetname should appear. Fill these in:
Integration
: the nickname for the Google Sheets integration you created in step 1Spreadsheet Id
: can be found in this part of url of the Google Sheet you would like to send data to:Sheetname
: name of the sheet/tab within your Google Sheets file
Once filled in, it should look something like this:
Run your SQL block and hit Send. The results of your block should now be in your target Google Sheet
Google Sheets
Send query results to Google Sheets