Extraction data into google sheet

Hello everybody,

how can i insert the data extracted from a query(mysql) into a google sheet?

thank you

Hey @renato!

The Append data to a spreadsheet action accepts an array of rows you'd like to append. Something like this should work!

Since SQL queries generally return data as an object of arrays instead of an array of objects, you can use the formatDataAsArray helper function to do the appropriate conversation :slightly_smiling_face:

thk