Populate form from a Google Sheet with data

  • Michael Fuselier
    Asked on June 20, 2022 at 2: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.

  • Gilbert JotForm Support
    Replied on June 20, 2022 at 4: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.