Populate form from a Google Sheet with data

  • Profile Image
    Michael Fuselier
    Asked on June 20, 2022 at 02:54 PM

    I want to send 20 or more people each their own form, populated from a unique Google Sheet with data specifically for each one, and then have them submit the for with a few fields such as the date and possibly a pic of when they tended to the item on the list.

    This is a re-post of a comment on How to Integrate a Form with Google Drive

  • Profile Image
    Answered on June 20, 2022 at 04:56 PM

    Hello Michael,

    Thanks for reaching out to Jotform Support. Unfortunately, it's not possible to populate a form with data from an integrated Google Sheet. Our Google Sheet integration only sends the submission data to the spreadsheet but not the other way around where the data from the sheet can be used to populate a form.

    As a workaround for that, you can import the data from a spreadsheet into the Jotform table and then you can create the prefilled form based on this table using the Tables Prefill.

    Give it a try and let us know if you have any other questions.