Use Data in Google Sheets to Generate Forms?

  • Profile Image
    rtolmach
    Asked on August 01, 2021 at 06:14 PM

    Hello

    We have a Google sheet with more than 100k rows of companies.

    We have thousands of volunteers who will help research several missing fields of info for those rows (for instance, the email address and phone # of each company).

    We do not want to have lots of people working on the same google sheet, as that becomes chaotic. Also, we want to keep track of who did what. So we would like to do this with jotform.

    Is there a way to do the following:

    • Volunteer goes to a jotform we create.
    • One or more fields (such as company name and URL) for just one record (that is, one row of the spreadseet) are displayed on the form. The jotform needs to somehow get that info from our google sheet.
    • They fill in the other fields, such as email and phone #.
    • They submit.


    BTW, we are familiar with integrating jotform submissions into a google sheet, but this needs to go in the other direction.


    I had one idea about how to do it:

    We could do something like what is discussed in this article: 'Prepopulating Fields to Your Jotform via URL Parameters' https://www.jotform.com/help/71-prepopulating-fields-to-your-jotform-via-url-parameters


    But instead of populating the fields with the user's info, we could do this: Within the google sheet, we would add a column where we would generate a unique form URL for each row of the sheet, with pre-fill parameters generated from the data (such as company name) in our google sheet. Of course, we would set those fields as Read-Only.

    Then we just need a way to dispense those URLs to the volunteers one at a time.

    Your thoughts or suggestions?

    Thank you!
    Robert


  • Profile Image
    Vanessa_T
    Answered on August 01, 2021 at 11:03 PM

    Please note that our Google Sheets integration is only one way:

    Jotform to Google Sheets, not Google Sheets to Jotform

    May I ask if your Google sheets is already final?

    That means, any future edits or new rows will be done in Jotform or you will still continue to make manual edits in Google Sheets?

    If you're main goal is just to be able to use the data that is already in your Google Sheets, and have all past, new and edits in one Google Sheets, then that can be done by following these steps:

    1) Create your form that corresponds to all the fields in your current Google Sheets.

    2) Export your Google Sheets into an Excel file.

    Create separate excel files for rows that are already complete, those that no longer need edits, and those that need additional info.

    3) For those that no longer need edits, please use the Import App to add it as a submission on your form:

    Import-app-easily-import-your-excel-or-csv-data-into-jotform

    4) For those that still require edits, please import it using the Spreadsheet to Form widget:

    How-to-use-the-spreadsheet-to-form-widget

    5) Integrate Google Sheets into the form.

    How-to-integrate-forms-with-google-sheets


    Your volunteers simply need to open your form, then in the widget section, type in the keyword to pull out one row of the excel, and the widget will automatically prefill other fields.

    After the volunteer fills out the rest of the fields, he/she will then submit the form.

    Since you have integrated Google Sheets, you will then have a separate Google Sheets that has all the data (past, new and edits).