How can I have the respondent link his Google Sheet to my form?

  • NRS108
    Asked on November 8, 2017 at 1:52 AM

    Question...

    Is there a way to connect a form to a private google sheet owned by the person filling in the form? Each time the form would be filled, another row would be added to the sheet.

    Then somebody else filling in the same form could connect the form answers to his private google sheet.

    etc., etc.

    Thanks.

  • Support_Management Jotform Support
    Replied on November 8, 2017 at 2:40 AM

    Is there a way to connect a form to a private google sheet owned by the person filling in the form?

    I'm afraid the Google Spreadsheet Integration doesn't work that way. This was meant to be used by you, as the form owner, and is not intended to be used by your users. However, you can still opt to share the generated sheet on your Google Account if you want to.

    Related articles:

    https://support.google.com/docs/answer/2494822

    Everything-you-need-to-know-about-sharing-in-google-docs

    If your aim is to share your submission data, privately with your users, you can either use reports or share the submission page itself with password protection.

    Complete guide: How-to-Share-Form-s-Submissions-Page

    Related guides:

    How-to-Create-Form-Reports-in-JotForm

    How-to-Create-a-Grid-Listing-Report

    How-to-Create-an-HTML-Table-Listing-Report