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

Questions & Answers
, ,
1

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

image
image712×1270 63.1 KB

RuntimeError

[400] Syntax error: Illegal input character “\342” at [3:1]

2

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.

Screenshot_2023-08-24_230826

Uploading it here will look like this:

blueprint.json (123.4 KB)

1 Like
3

Hi Samliew,

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

1 Like
4

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

Is there any documentation on that?

:frowning:

5

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