How to share the google spreadsheet link?

  • kknaul
    Asked on March 6, 2018 at 2:11 PM

    I'm using the free version and have integrated my form with google spreadsheet. My goal is to share the spreadsheet with a committee who can review the fields or see a full version of the form submission. Is there a way to include a link in the google spreadsheet to the full submitted responses as a form or pdf view? Right now what shows up is "edit submission" as a link, but I don't want my committee to be able to edit the submitted responses. 

  • Richie JotForm Support
    Replied on March 6, 2018 at 3:10 PM

    You can open the link given by the Google Spreadsheet Integration

    How to share the google spreadsheet link? Image 1 Screenshot 70

    and then make sure to click Share in the Google Spreadsheet,

    How to share the google spreadsheet link? Image 2 Screenshot 81

    so that we can share the link to your users. Click get shareable link and use that link.

    How to share the google spreadsheet link? Image 3 Screenshot 92


    Copy the link and place it in your autoresponder.

    How to share the google spreadsheet link? Image 4 Screenshot 103

    then insert the link into your email content

    How to share the google spreadsheet link? Image 5 Screenshot 114

    Here is a sample output.

    How to share the google spreadsheet link? Image 6 Screenshot 125

    Hope this information helps.


    Please let us know if we can be of further assistance.

  • kknaul
    Replied on March 6, 2018 at 3:18 PM

    Thanks, but I'm good on how to share the google spreadsheet. What I want is a column in the google spreadsheet that contains an auto-populated link to a pdf version, or non-editable version, of the form with the submissions. This way whoever has access to the google spreadsheet can see all of the answers in the form format, rather than spreadsheet format if they want to.

  • Richie JotForm Support
    Replied on March 6, 2018 at 3:59 PM

    Thank you for the clarification, but I can't seem to find a work around to include the pdf link in the Google Spreadsheet.

    How to share the google spreadsheet link? Image 1 Screenshot 30

    The PDF link can only be placed in the Email notification or in the autoresponder.

    However, my colleague Charlie have a workaround and I have tested it and it works.

    How to share the google spreadsheet link? Image 2 Screenshot 41

    You can check the thread at this link Adding-PDF-link-in-the-Google-Spreadsheet-integration


    Hope this information helps.


    Please let us know if we can be of further assistance.