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

NRS108
Asked on November 08, 2017 at 01: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.

This is a re-post of a comment on How to Integrate Forms with Google Sheets
Jim

Jotform Support Manager

Answered on November 08, 2017 at 02: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