Upon adding a google sheets pdf template to my automation bot, the email preview shows a empty/blank email. This is when I add the template to the "Email body template under advanced settings". Without this, it won't copy the format I'd like. It also does not send any emails. If I remove the template, it copies what I have under email body. Any reason why this is having issues? My other automation bots use similar google sheets type and work. Thanks.
I was able to fix it. It was strange, a formatting issue with the text in excel. An example photo is shown below.
The first column was giving me issues. Upon trying the second column, it worked.
User | Count |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |