I am trying to write a Zap that will query Microsoft SQL Server (this part works) and then creates a CSV in Excel, OneDrive, whatever (this part does not work).
Excel will create a spreadsheet and let me add the required headers, but will not allow me to add the data from SQL.
I tried creating the blank spreadsheet with required headers and using a second step to “add a row” but I can’t figure out how to get it to add the data from SQL.
Help!
