Connect google doc app script to intermediate server

Setup

• Open Demo google doc

• Tools → script editor

• Get Google doc script to add to it.

  • click on raw, select all, copy and paste in script editor.

  • Line 27 edit URL.

    var capServer = 'http://8f209ae3.ngrok.io';
    

• Click save.

  • Click run to test it out.

  • Authorise permissions

Setup time trigger

• Setup a 1 minute triggered event in google app script for appendToDocument function under

  • Edit -> All your triggers

.

Documentation

• see readme of repository
• Google documentation on how to use google app scripts
• Google OAuth, client verification
• Google app script time triggered events