How to automatically generate a link to a spreadsheet template per submission?

  • bcsform
    Asked on July 17, 2025 at 7:29 AM

    Could you please advise:

    1. Does Jotform have a built-in widget or feature that can automatically generate and provide a unique copy link of a spreadsheet template per submission?
    2. If such a feature does not exist yet, is it possible to integrate external automation, for example using Google Apps Script, with Jotform workflows so that after each submission a script clones a Google Sheet and sends the individual link to the user?
  • John JotForm Support
    Replied on July 17, 2025 at 7:42 AM

    Hi Charles,

    Unfortunately, Jotform does not have a built-in widget or feature that automatically generates and provides a unique copy link of a spreadsheet template per submission.

    However, you can use Google Apps Script to automate actions after each submission. You could set up a script that clones a Google Sheet and sends the individual link to the user. This can be done by integrating Jotform with Google Sheets and then using Google Apps Script to handle the cloning and sharing of the spreadsheet link.

    Once integrated, you can use Google Apps Script on your Google Sheets to clone the spreadsheet and send the unique link to the user after each submission.

    Give it a try and let us know how it goes.

Your Reply