Jotform's integration with Google Sheets.

  • waterforishmael
    Asked on January 22, 2019 at 8:59 AM

    I receive hundreds of applications a year from a jotform of mine. I would like all of them to automatically be added to a google sheet under a "main" worksheet, then separate the males and the females into two additional worksheets in the same google sheet. Is that possible? 

    Do you know if Zapier or IFTTT or some other application could do that if Jotform and Google can't do it through their integration? Thanks in advance for any help you can offer.

  • Kevin Support Team Lead
    Replied on January 22, 2019 at 10:18 AM

    They will only allow to send submissions data to an specific spreadsheet and column in a spreadsheet, you may check more about it here: https://zapier.com/apps/google-sheets/integrations/jotform 

    The request to separate the records by male and female seems very specific for your purpose only so you would need to find an alternative to do this directly from the sheet, you may need to develop your own script to do this since Google allows it, here is a link with info about that: https://developers.google.com/apps-script/guides/sheets 

    Thanks.