I am currently trying to use an excel template and transforming it to PDF (it always returns a excel file).
I want it to be 100% automated but I couldn’t find a good way to do it. Here is some of my (failing) attempts :
- Try to export the excel as HTML
- Try to automate through appscript a trigger that changes the GoogleSheet to PDF
- Try to copy/paste inside a google doc
If you found a way, or just did it please let me know !!