Send Jotform submission to Google BigQuery

  • Profile Image
    rtolmach
    Asked on November 06, 2021 at 11:40 PM

    Hello

    I know how to integrate submissions into a Google sheet.

    We will have more rows than Google sheets can accommodate.

    If we want to get submission data into Google's BigQuery, can we do that with Integromat?
    Thanks!

  • Profile Image
    Mark_Louis
    Answered on November 07, 2021 at 12:00 AM

    Hi,

    Thanks for reaching out.

    Yes we can integrate Integromat to Jotform.

    To connect your Jotform account to Integromat, follow the general instructions for Connecting to services. Jotform uses an API key-based connection, so you need to generate one first. You can do so in your profile settings under the API tab.

    1636257596_61874f3c5fe68_

    Hit the Create New Key button and a new API key will be generated for you.

    mceclip2.png

    You can name it as you want, but it's important to grant Full Access to the key otherwise some of the integrations won't work correctly. The write permission is required for webhook registrations, for example.

    mceclip3.png

    Copy your new API key to your clipboard and return to Integromat. Simply paste the API key to the corresponding field and click the Continue button.

    mceclip4.png

    And that's it, you're all set. Now, you can continue creating your scenario.

    Hope this helps. Thank you.

    Mark

  • Profile Image
    rtolmach
    Answered on November 07, 2021 at 05:34 PM

    Hi Mark


    Thanks.

    Is Integromat the way to get submission data into Google's BigQuery?


    best

    Robert

  • Profile Image
    JohnRex
    Answered on November 07, 2021 at 06:23 PM

    Hello Robert - Unfortunately, there is no Jotform > BigQuery integration in Integromat: https://www.integromat.com/en/templates/google-bigquery/jotform

    However, I found out that you can use Zapier to do the task: https://zapier.com/apps/jotform/integrations/google-bigquery. I wasn't able to test this since I don't have that much knowledge in BigQuery yet, but if you have some time, I believe it's worth a try.

  • Profile Image
    JohnRex
    Answered on November 07, 2021 at 09:16 PM

    Hi again Robert - I was fiddling with Integromat and saw that we can, indeed, link Jotform to Big Query:

    1636337738_6188884a37eaf_

    In case you already have an Integromat account, you might want to try if this will work.

  • Profile Image
    rtolmach
    Answered on November 18, 2021 at 04:13 PM

    Thank you!