Google Sheets integration: When selecting to integrate to an existing worksheet, a new worksheet is still created.

  • Profile Image
    jotformacem
    Asked on June 02, 2021 at 03:50 PM

    When i authenticate it shows spreadsheets in my drive but not the shared drive

  • Profile Image
    Laura_L
    Answered on June 02, 2021 at 10:15 PM

    Hi,

    Unfortunately the Google Sheets integration lets you upload the submissions only to a personal drive, and there is no option to use a shared drive.

    As a workaround, you can either use Google Workspace shortcuts to post the submission from your personal drive to the shared drive, or then create an integration with Zapier. With Zapier, you can connect Jotform directly to the shared drive.

    Let us know if you need further assistance.

  • Profile Image
    jotformacem
    Answered on June 02, 2021 at 11:11 PM
    Hi,
    I understand, i did use my personal drive. When I connected it to the
    existing spreadsheet and used an existing workspace name, it then created a
    duplicate of that worksheet instead of using the existing. Is there a way
    around that?
    Best Regards,
    Ace M
    ...
  • Profile Image
    Bojan_J
    Answered on June 03, 2021 at 06:31 AM

    Greetings.

    Unfortunately, it is possible to select only Sheets that are on your account. You could add shortcuts of your Sheet to the shared Drive.

    Let us know if you have any additional questions.

  • Profile Image
    jotformacem
    Answered on June 03, 2021 at 03:33 PM
    I am not talking about shared drive anymore, please look at my last message
    carefully and provide the requested information
    Best Regards,
    Ace M
    ...
  • Profile Image
    Laura_L
    Answered on June 03, 2021 at 05:03 PM

    Hi Ace,

    Apologies for the confusion.
    Unfortunately, currently that is how the integration is designed to work - when you select to use an existing Spreadsheet, the integration will still create a new worksheet within the Spreadsheet.

    I have forwarded this to our developers as a feature request, and I noticed that there were already a couple of similar requests existing. However, we cannot guarantee an ETA, or that the feature will be implemented.
    As soon as we have any updates, we will inform you on this ticket.

  • Profile Image
    jotformacem
    Answered on June 03, 2021 at 05:22 PM
    Got it thanks, hopefully that can be implemented
    Best Regards,
    Ace M
    ...