Get results of BigQuery "Write Query" module in a single array

[Chambon_Robin]

I’m looking to obtain the results of a BigQuery “Write Query” module in a single array, with the key = value combination for each result, like this

This is the output of the module “Write Query” on Make.

The final objectif is to add every result on a google sheet, like this

Here is the blueprint !

Thank you !!
Mapper l’output d’un module BigQuery.json (5.4 KB)

[samliew]

Welcome to the Make community!

Thanks for providing screenshots of your output bundle, but we need it in text format to assist you —

After running the scenario, click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!