Hello everybody,
how can i insert the data extracted from a query(mysql) into a google sheet?
thank you
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