How to integrate google sheets information in jotform element

  • Profile Image
    Asked on January 09, 2022 at 03:27 AM

    Hello Jotform,

    I have a few small questions,

    • Is it possible to import / upload information (room prices) from Google sheets to Jotform.
    • I use unique id in my form, and it has been working for a long time but the last year (sorry because of corona we dont receive many forms) the unique id does not work and gmail adds all the forms in one jotform email receipt. Can you please advise.
    • Is it possible in the new app that when people click on book this room, the form is automatically filled with the room name etc?

    Thank you very much,

    Best regards,

    Bedouin Star

  • Profile Image
    Answered on January 09, 2022 at 04:39 AM

    Hello there,

    Thanks for contacting Jotform.

    Unfortunately, that's not possible. I'm afraid we do not have that feature. You can however achieve what when you use your form source code and implement the function in the form source. 

    Here's how to get your form source code and here's how to pull data from Google Sheet and place it on a dropdown field: Watch the guide.

    I have move your other inquiries to get specific answer in each inquiries.


  • Profile Image
    Answered on January 09, 2022 at 04:44 AM

    Hi Carissa,

    Thank you for your fast reply, I will take a look in it.

    Best regards,