Wdata - File ID for emailing files
RespondidaI'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?
-
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
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
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.
0Por favor, entrar para comentar.
Comentários
3 comentários