Creating a doc from a sheet online

I seem to be hitting a barrier. I assume it's correct that Appsheet can't make a Google sheet generate a Google Doc from a template with completed values on command? This is presumably something that has to happen from a Google script inside the sheet?

I was thinking of alternatively using Excel as my base sheet and then generating a Word doc via VBA but of course can't do this from the Google cloud.

Would welcome any suggestions. My problem is that I need to launch the new Google Doc when a specific field in the Sheet is changed in value, but I can't see anything in the documentation for Triggers that allows this.

2 14 12.8K
14 REPLIES 14
Top Labels in this Space