Is it possible to set a complex path to a google sheet?

  • Profile Image
    Kai
    Asked on February 14, 2020 at 12:38 AM

    Is it possible to set a complex path to a google sheet, so the sheet ends up in the right subfolder in my google drive? I tried using '/' 'berlinhistory_bla/blub/form' but it only created a folder with the whole string as name including all the '/' characters.

     

    Thanks!



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

  • Profile Image
    Jed_C
    Answered on February 14, 2020 at 03:10 AM

    Unfortunately, you cannot select the folder where you want to store the form submissions. A new folder will always get created and named after your settings in the integration process. 

    The Google Spreadsheet does the same thing. You have to set the folder name and that will be created in your Google Account. 

    You may consider doing the integration through Zapier. With Zapier, you should be able to select what folder to save the data.

    https://zapier.com/zapbook/zaps/1924/add-new-jotform-submissions-to-a-google-sheets-spreadsheet/ 

    https://zapier.com/zapbook/zaps/1949/add-new-jotform-file-uploads-to-google-drive/ 


  • Profile Image
    jotformactd
    Answered on February 23, 2020 at 09:18 PM

    Actually the way around this is to do your integration with your Google Spreadsheet and then move the spreadsheet to the folder you want it placed in. Since the link to the Google spreadsheet does not change when you move it, JotForm will continue to use the spreadsheet in the new location.  You just need to make sure that what every JotForm account is creating the spreadsheet when doing the integration, has access to the new location of the file in Google Drive.