How to integrate my form with google spreadsheet?

  • alexi7631
    Asked on November 25, 2016 at 9:05 PM

    We work with artists and the casting of them.
    We want the main organizer to simply write a name down on our website, so he would submit a name in a form.
    We want this info to then automatically transfer into a list that tracks what we've done with it, meaning have we contacted them, if so what date, and what was their reply.
    For the organizers, we want to simplify life. They go to our site, add a name to a list and then check for updates as we move along.
    I hope this makes sense.
    Can you let me know how to make this happen.
    I am currently using Google sheets, which is embedded to my site. If I update google sheets, my site is automatically updated. I don't want to give the organizers access to google sheets, because the formulas in there is a lot of work and I don't want them to have it, so for protection, I want them to go to our site and add names there.
    I have not been able to find out how google sheets could be editable once embedded, only that is editable in sheets or google drive itself, which is what I don't want.
    So, that is why I am thinking if I can make a form, through jotform, with artist name and then a submit button, then I will be notified of a new artist, but instead of manually typing that into google sheets, I hope this step can be automatic.
    Thank you!

  • Helen
    Replied on November 26, 2016 at 5:14 AM

    Thanks for contacting us.

    As I understood, you want to integrate your form with Google Spreadsheet. Please follow these steps:

    1. Click "Integrations" at the top the page on your form that you integrate.

    How to integrate my form with google spreadsheet? Image 1 Screenshot 40

    2. Choose "Google Spreadsheets Integration"

    How to integrate my form with google spreadsheet? Image 2 Screenshot 51

    3. Click the "Authenticate" button:

    How to integrate my form with google spreadsheet? Image 3 Screenshot 62

    Here is a guide helps to you: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Please let us know, if you need any further assistance.