Funnel form submissions to an existing Google Spreadsheet

  • Profile Image
    FarmigoSupport
    Asked on October 15, 2013 at 11:02 AM

    Hi,

    I would like to know if it's possible to have form submissions populate a pre-existing spreadsheet in Google Docs.  Do you have a help page on how to set that up?

    Thank you,

  • Profile Image
    ardy0689
    Answered on October 15, 2013 at 11:33 AM

    Hello. Yes this is possible with JotForm. There are 2 ways that you can do this:

    From "Integrations Wizard":

    1. Click "Setup & Embed"

    2. Click "Integration" button and "Integrations Wizard" will popup

    3. Click "Document Sharing Tab"

    4. Choose "Google Spreadsheets"

     

    5. Click "Authenticate" button

     

    6. Click "Authenticate" again from the popup window

     

    7. Click "Next"

     

    8. Fill the required fields: Folder Title and the Spreadsheet Name

     

    The second one is using our Google Spreadsheet Integrations App. It will automatically create a form that will redirect you into the Integrations steps.

     

    As for using existing spreadsheet, I advise that you send a test submission for the new integration and use the created template by JotForm and adjust the columns accordingly on your existing template.

    For further info please refer to this guide:

    https://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

  • Profile Image
    chantinon
    Answered on February 23, 2015 at 09:25 PM

    One problem use Form Spreadsheet with integration, i necessary others columns and thats columns eliminated if created in form spreadsheet. Whats solution? 
  • Profile Image
    Welvin
    Answered on February 24, 2015 at 07:10 AM

    @chantinon,

    Your question will be answered to this thread: http://www.jotform.com/answers/521467.

    Thank you!

  • Profile Image
    WheelsofJustice
    Answered on March 06, 2016 at 10:38 AM

    is the google sheets/forms integration two way, so that a if I edit in Google, will it change the submission in jotform ?

     

    thanks

  • Profile Image
    FarmigoSupport
    Answered on March 06, 2016 at 10:45 AM
    ## Please do not write below this line ##
    Hello!
    I am out of the office currently. If this issue is urgent and you cannot wait for a response until Monday, please call my cell at 347-450-3307. This will ring my cell phone and send me a text message with your voicemail if I cannot answer immediately. Urgent issues include not being able to access your system or members not being able to access your system. Of course, if you think something is urgent, you can call!
    Thank you,
    Karli
    [N8LORK-PP01]
    ...