Several excellent posts on these forums around the subject of Google AppScript integration with appsheet. There are a variety of use cases for this. Here are some excellent examples and forum posts:
https://community.appsheet.com/t/solved-google-script-and-appsheet-integration/20270/8 https://community.appsheet.com/t/how-to-integrate-google-apps-script-trigger-with-an-appsheet-app/11805 https://community.appsheet.com/t/learning-resource-google-apps-script-and-cloud-technology/16388 https://community.appsheet.com/t/google-app-script-appsheet-api-write-data-to-spreadsheet-add-fields-name-to-row-1/28454 https://community.appsheet.com/t/executing-a-deeplink-action-from-an-email-silently/10992/2 https://community.appsheet.com/t/how-to-implement-functions-written-in-google-app-script-within-appsheer/24054/2
Yes, yes we all know it’s not very “no code” to add a google script to your appsheet solution no arguments there. Anyway, I’ve always been curious as to the inner workings of appscript. In my spare time recently, I figured out a way to create a Google Doc from appsheet data. Spoilers/Warnings:
- this solution requires the AppSheet Rest API.
- this is a code solution, it’s not for the faint of heart. You need some moderate understanding of app script.
This solution solves for a particular missing workflow output type of “Google Document”. I didn’t see anything on the forums on this, so hopefully folks find it useful. Perhaps at some point in the future AppSheet will natively be able to render a Google Doc (from a Google Doc template of course).
As a side effect, this solution also solves the fact that currently the AppSheet PDF output cannot include headers, footers or pagination. Something @Jonathon went to great lengths to solve in a different forum post.
Here’s the code and readme:
For you folks with massive talents on app script code greater than mine, let me know if you see anything that I could improve.