-
rtolmachAsked on November 6, 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! -
Mark_LouisReplied on November 7, 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.
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
-
rtolmachReplied on November 7, 2021 at 5:34 PM
Hi Mark
Thanks.
Is Integromat the way to get submission data into Google's BigQuery?
best
Robert
-
John Support Team LeadReplied on November 7, 2021 at 6: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.
-
John Support Team LeadReplied on November 7, 2021 at 9:16 PM
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.
-
rtolmachReplied on November 18, 2021 at 4:13 PM
Thank you!