Converts a CSV you upload or link to into a real .xlsx workbook and emails it to you as an attachment.
Uses
CloudConvert
Gmail
Turn a CSV into an Excel file
Set csvSource to blank.Set csvSource to blank.Set excelFileName to blank.Set excelFileName to blank.Set sendTo to blank.Set sendTo to blank.
Trim csvSource and save it as source.Trim csvSource and save it as source.
If source in lowercase doesn't start with doc_ and source in lowercase doesn't…If source in lowercase doesn't start with doc_ and source in lowercase doesn't…Yes
Stop and report a problem: The 'csvSource' step needs either a CSV uploaded onto the step itself or an https link that downloads one. What it has is neither, so nothing was converted.Stop and report a problem: The 'csvSource' step needs either a CSV uploaded onto the step itself or an https link that downloads one. What it has is neither, so nothing was converted.No
No steps
Trim excelFileName and save it as fileName.Trim excelFileName and save it as fileName.If fileName doesn't end with .xlsx (ignoring case)If fileName doesn't end with .xlsx (ignoring case)Yes
Change fileName to fileName.xlsx.Change fileName to fileName.xlsx.No
No steps
Set converted to blank.Set converted to blank.Set problem to blank.Set problem to blank.
If a step below fails, save the error as convertErrorIf a step below fails, save the error as convertErrorTry
CloudConvertConvert a file to xlsx. Save it as converted.Convert a file to xlsx. Save it as converted.On error
Trim convertError.message and save it as rawReason.Trim convertError.message and save it as rawReason.Replace source with the file you gave it in rawReason and save it as safeReason.Replace source with the file you gave it in rawReason and save it as safeReason.If safeReason contains ://If safeReason contains ://Yes
Change problem to the file could not be converted.Change problem to the file could not be converted.No
Change problem to safeReason.Change problem to safeReason.If problem isn't emptyIf problem isn't emptyYes
Stop and report a problem: The CSV could not be turned into an Excel workbook, so nothing was emailed: problem.Stop and report a problem: The CSV could not be turned into an Excel workbook, so nothing was emailed: problem.No
No steps
Make converted.output_format lowercase and save it as gotFormat.Make converted.output_format lowercase and save it as gotFormat.
Set gotSize to converted.size_bytes multiplied by 1.Set gotSize to converted.size_bytes multiplied by 1.Trim converted.document_ref and save it as workbookRef.Trim converted.document_ref and save it as workbookRef.If gotFormat is not xlsxIf gotFormat is not xlsxYes
Stop and report a problem: The converter sent back something other than an Excel workbook, so nothing was emailed. It came back as: gotFormat.Stop and report a problem: The converter sent back something other than an Excel workbook, so nothing was emailed. It came back as: gotFormat.No
No steps
If gotSize is less than 1If gotSize is less than 1Yes
Stop and report a problem: The workbook came back empty, so nothing was emailed. Check that the CSV has rows in it and run it again.Stop and report a problem: The workbook came back empty, so nothing was emailed. Check that the CSV has rows in it and run it again.No
No steps
If workbookRef doesn't start with doc_If workbookRef doesn't start with doc_Yes
Stop and report a problem: The workbook was not saved, so there was nothing to attach and nothing was emailed. Run it again.Stop and report a problem: The workbook was not saved, so there was nothing to attach and nothing was emailed. Run it again.No
No steps
GmailSend an email to sendTo.Send an email to sendTo.
Subject: fileNameAttached is fileName, converted from the CSV set up in this workflow's 'csvSource' step. Every value was carried across as it was written - nothing was rounded, relabelled or left out.
Show in the output: Emailed fileName.Show in the output: Emailed fileName.