I followed the instructions here => Google Script - Send active sheet as PDF to email listed in cell, but ScriptApp.getOAuthToken() returns null when called inside google sheets (see => getOAuthToken returns null when called from Google Sheets)
Does anyone have any other solution to this?
Asked
Active
Viewed 137 times
0
Savy Brandt
- 1
- 2
-
What do you mean by "returns null when called inside google sheets". Also, how are you running your code? – AMolina Oct 08 '19 at 06:54
1 Answers
0
This is the only code I have looked up that has worked for me so far, although I would like to figure out how to change the recipient email based on a cell content (in other words, have the script go and fetch the email address from a cell as I am using a vlookup).
https://www.sheetmania.com/2017/11/export-and-email-custom-sheet-to-pdf.html
-
1Please, post also here the full solution and no only as a link. – Roberto Caboni Jan 06 '20 at 08:41