Export Excel in an action flow

It looks like the error is saying the data you're trying to insert into the sheet doesn't have the same shape. Based on the module, you need to insert values in those rows.

Right now, those rows are returning NULLs/No data, so it does not have a shape to insert. You'll likely need to insert data points to be able to insert rows.

Thanks Matt! I could solve it!!

one question, I do have in the sheet a column for price, but it's coming as euros, I a trying to find a way to convert it to USD. Do you have any ideas? thanks!

Also, it´s sending several emails with the information, I just need the file to be sent once...

You can do this in the data transformations. There should be a currency conversion transformation that allows you to convert. If not, you should be able to do some mathematical functions to adjust them within the action flow

You have to tell the "Create XLSX file" or whichever module that creates the Excel file to make the Query Data Module the source.

Essentially, you're telling the action flow to wait until each bundle goes through the execution and then build the Excel file