Hi all.
I have a project that populates google sheets and hopefully be able to email the sheet once populated. I have the reading/writing cells working fine and no issues there.
What I would like to have is once the sheet is populated, have the full sheet visible on the app screen with all formatting etc. The sheet has particular formatting for an already existing program at the other end so I need to keep the same. I can email directly from the sheet with a script once a certain cell is populated.
What I was hoping for was to populate the sheet (minus the "send" cell), have the image of the sheet with formatting etc. in full screen on the app for the user to confirm, then the confirm button/notifier to populate the "send" cell on the sheet and the sheet will email off in the background. I can read data from sheet fine but I am stuck on how to generate an actual image of the sheet. Is this possible? Do I have to create a HTML of the sheet?
Please be nice, I am a novice but want to learn.
Cheers