What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Concerned about Full Acess Permission in Google Spreadsheet Integration

    Asked by 1thomh1 on November 24, 2014 at 05:14 AM

    With most integrations with cloud storage you only require access to the stuff that Jotform creates, but I can see when trying to integrate Google Sheets, you ask for access to everything! I can't grant that access so I'm not able to use this feature :/ 

     

    Thanks, Thom

    integrate google integration integrations google spreadsheets authentication permission
  • Profile Image
    JotForm Support

    Answered by Jan on November 24, 2014 at 10:05 AM

    Hi,

    The steps regarding authentication and granting is permission is required for the integration to work. 

    Here's our guide on How to Integrate Form with Google Spreadsheet.

    Setting up an integration with Google Spreadsheets should be quick and easy. Can you please tell us which part are you having issues with?

    Let us know if need any help. Thank you.

  • Profile Image

    Answered by 1thomh1 on November 26, 2014 at 09:29 AM

    Hi,

    I understand it needs permissions to access the drive, but when I set up the Drive integration for it to store the results there, it only asked for access to one folder, which it created itself, and nothing else.

    The permission for this requests access to the full drive etc - surely you don't need that much access just to work on one Sheet?

     

    Thanks, Thom

  • Profile Image
    JotForm Support

    Answered by Welvin on November 26, 2014 at 11:11 AM

    Hi Thom,

    I understand that you are concerned of the following permissions:

    But the app only requires an access to the spreadsheet that is created by itself. Clicking "More Info" button would tell you what the permission is all about. I don't see any full permission access in the integration. 

    Thank you!

  • Profile Image

    Answered by 1thomh1 on November 26, 2014 at 11:42 AM

    Hi,

     

    Please see below the more information boxes, which state it's able to 'view and modify existing spreadsheets' as well as share these with others. there's nothing in there about only having access to the ones Jotform crates. The tool for integrating with Drive only had one permission, while this one is SO MUCH more intrusive! You do not need that much permission!

     

     

  • Profile Image
    JotForm Support

    Answered by Welvin on November 26, 2014 at 12:14 PM

    Jotform does not necessarily modify any other existing spreadsheets from your account. The idea of the permission is to just solely access the specific spreadsheet that's been created by the integration. 

    View and Modify permissions are for updating the spreadsheet after it receives a submission. And as far as I know, the share spreadsheet permission is to let collaborators see the update to the form. Well, if only we can change the messages, but we cannot because that was generated by Google API. It's a bit confusing or misleading, but again, that's how the permission works.

    Thanks