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

Comments

3 comments

  • 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

    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.