Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Wdata - File ID for emailing files

Answered
Request Demo

I'm trying to setup a wdata chain to update a spreadsheet based on a query and then email the spreadsheet to myself.

I've been able to get the query to publish to the spreadsheet but am stuck when trying to email the file. 

Is there a simple way to send the whole spreadsheet or is there a list of extract/download commands I need to follow in order to get the email to send?

0

Comments

3 comments

Date Votes
  • Jeff Hickey

    Hi John, a simple way to accomplish this would be to use Chain notifications. First, you'd need to retrieve the Sheet data using the Get Sheet Data command. Then configure a notification for the command and add the Sheet Data as an attachment. More information on how to create notifications can be found in the Manage chain and command notifications documentation. This will send the data from the Sheet as a .csv file attached to the notification email.

    0
  • John May

    Jeff,

     

    Thanks for the overview, I was able to get that to work. Is there a more complex way that would keep the formatting of the spreadsheet?

     

    0
  • Jeff Hickey
    • Edited

    The Spreadsheet API only extracts data and not formatting. However, you could use Handlebars to build HTML tables. Or if your Sheet was small, you could extract the data from the cells and apply some formatting to the notification text body (eg. <b>this text is bold</b>). This would be tough to scale for a large Sheet and would require you to maintain formatting in both the Spreadsheet and Notification.

    0

Please sign in to leave a comment.