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

  • SanctuaryHostel
    Asked on June 2, 2021 at 3:50 PM

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

  • Laura JotForm Support
    Replied on June 2, 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.

  • SanctuaryHostel
    Replied on June 2, 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
    ...
  • Bojan Support Team Lead
    Replied on June 3, 2021 at 6: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.

  • SanctuaryHostel
    Replied on June 3, 2021 at 3: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
    ...
  • Laura JotForm Support
    Replied on June 3, 2021 at 5: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.

  • SanctuaryHostel
    Replied on June 3, 2021 at 5:22 PM
    Got it thanks, hopefully that can be implemented
    Best Regards,
    Ace M
    ...