I want to run a complex SQL query in Make and insert the result to GSHEETs

To get helpful responses

When I run the Query in BigQuery it works perfectly fine. I think pasting it into the module causes the problem

Include screenshots of


[400] Syntax error: Illegal input character β€œ\342” at [3:1]

Welcome to the Make community!

Could you please share screenshots of the module fields and/or filters in question? It would really help other community members to see what you’re looking at.

You can also export the blueprint file to allow others to replicate the issue. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.


Uploading it here will look like this:

blueprint.json (123.4 KB)

1 Like

Hi Samliew,

I had Linebreaks in my query! Your tip with exporting the blueprint has helped a lot!

1 Like

Is it possible to save all rows from the query to a Gsheet?

Is there any documentation on that?


You should check out the Google Sheets module, which offers the ability to add rows to a spreadsheet and place the results of your query into the columns you specify from your Google Sheet.

1 Like