Setting up automated workflows with Zapier puts an end to repetitive tasks, saving you and your team time. Here, we'll dive into how to collect responses with a videoask, and send the data to the Airtable of your choice using Zapier. Sound good? Read on to learn how to automate this flow.
Before we get started, here's what you'll need to set up this workflow:
Note: Free plans are available for all of these tools.
VideoAsk newbie? Check out how to create your first videoask.
From your videoask, click Connect to other apps.
Scroll down the list of integrations until you see Airtable. Click Connect.
Click Try this template.
Now, click Get started.
At this point, you'll be asked to sign in to your Zapier account. If you've never used Zapier before, you can sign up for a free account.
Choose the VideoAsk account you'd like to connect, and click Next.
If you're part of more than one VideoAsk Organization, select the one with the videoask you want to connect to Airtable, and click Next.
Choose the videoask you'd like to connect to Airtable (you can use the search bar instead of scrolling), then click Next.
Now it's time to connect your Airtable account to Zapier. Click Connect.
If you haven't connected Airtable with Zapier before, you'll need to get your API key. This gives Zapier access to your Airtable account. To find it, go to Airtable and select Account, then click Generate or Regenerate Key.
Copy this key from Airtable, and paste it into the API key box back over in Zapier. Then click Yes, Continue.
Select the base where your Airtable is stored. Click Next.
Choose the table you'd like to connect to your videoask. Click Next.
Select the fields you'd like to send data to in Airtable, then scroll down and click Next.
Now it's time to map your videoask steps to the fields in Airtable.
In our example, we're capturing data from people who want to rent a plot of land in our allotment to grow their own vegetables.
Our videoask asks them for their name, email, the plot size they'd like, whether they're interested in signing up for our gardening course, and why they'd be a good fit for our allotment community. All of this data will then be passed over to our Airtable through an automated connection, known as a Zap.
The videoask step that asks our respondents to explain why they'd be a good fit for the gardening community allows them to answer by video, audio, or text. So, to make sure we're capturing this data however they choose to answer, we've made sure to map to both the text and transcription options for this question:
💡 Tip: If you're sending data to Airtable from a multi-step videoask, we recommend naming each of your steps. This will make it easier to figure out which step is which when mapping your fields in Zapier.
When you've finished mapping, click Next.
Now it's time to test out the Zap. Click Send test.
Head over to your Airtable to check that everything has worked correctly.
If everything has pulled through as expected, click Next, or, click Back to make any changes to your Zap.
Click Turn on Zap to start the automation. Now, every time you receive a response to this videoask, your respondents' answers will be sent directly to your Airtable.
💡Tip: Want to edit or turn off a Zap? Learn more about managing your Zaps.