Send Jotform submission to Google BigQuery

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!

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.

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

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.

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.

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

Hope this helps. Thank you.

Mark

Hi Mark

Thanks.

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

best

Robert

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.

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

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

Thank you!