This is awesome! So we have leads populating a Google Sheet from a Web Form and we've been looking for an automated way of populating the contract and send for signature. We use DropboxSign which has an Extension for Sheets known as "DropboxSign (fka as HelloSign) for Google Docs" - how would we integrate that element to what you've done? We populate our Contract Doc with the Variables from our Sheet and then send something - either a Google Doc or PDF via email to be signed using DropboxSign? Would that be the workflow? And would Doc or PDF be better?
I'm assuming that extension takes a Google Doc input, so what I could recommend is saving the result of this script as a Google Doc, then paste the link to it in the Google Sheet, and then you should be able to run the plugin from there
This is awesome! So we have leads populating a Google Sheet from a Web Form and we've been looking for an automated way of populating the contract and send for signature. We use DropboxSign which has an Extension for Sheets known as "DropboxSign (fka as HelloSign) for Google Docs" - how would we integrate that element to what you've done? We populate our Contract Doc with the Variables from our Sheet and then send something - either a Google Doc or PDF via email to be signed using DropboxSign? Would that be the workflow? And would Doc or PDF be better?
I'm assuming that extension takes a Google Doc input, so what I could recommend is saving the result of this script as a Google Doc, then paste the link to it in the Google Sheet, and then you should be able to run the plugin from there