Can we use jotform to query data from a google sheet?

  • thesocialbarber
    Asked on June 27, 2019 at 3:57 PM

    I want to use an existing sheet and filter data in an existing google sheet.  I need to share the sheet with a lot of people so I don't want to allow them edit access to my sheet.  A lot of them don't know how to use google filters.


    I want it to work like this: 

  • Alan_D
    Replied on June 27, 2019 at 5:05 PM

    Unfortunately, there is no direct integration, tool, widget, etc. to accomplish your goal. 
    But, I can recommend you our Data Grid widget. You should be able to able to customize your data as the widget's format to use it. Can we use jotform to query data from a google sheet? Image 10Can we use jotform to query data from a google sheet? Image 21This is my demo form. You can clone and inspect that. Can we use jotform to query data from a google sheet? Image 32https://www.jotform.com/91776057508971 
    Guide: How-to-Clone-an-Existing-Form-from-a-URL