Question

SQL Query to Excel Spreadsheet

  • 28 March 2023
  • 1 reply
  • 49 views

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!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @DODonnell 

Good question.

Please post detailed screenshots with how your Zap steps are configured.

Also please elaborate about the data mapping you are trying to do between the apps.