This article will show you how to send videoask response data to Google Sheets via Zapier if you have:
- Custom variables included in your videoask URL
- The Product name field enabled in your Contact form
If you don’t need to send responses with custom variables or the Product name, check out how to just send your videoask responses to Google Sheets here.
We recommend setting up this workflow before sharing the videoask with your audience. Previously received responses (before setting up the integration), won’t be sent across.
Before we get started, here’s what you’ll need to set up this workflow:
- A VideoAsk account
- A Google account
- A Zapier account
In the Google Sheet where you want your videoask responses to be sent, add column headers to the first row. Enter a column header for each piece of information you want pulled through from your videoask.
The column header will indicate which column your videoask data will be sent to. Make sure to include column headers for your custom variables and Product name.
In our example below, we’ve entered column headers for Name, Email, and Product name from our contact form. The next column header is labeled Source, which is the custom variable we’ve used in our videoask. We’ll use Response for the answers we received from respondents.
Submit a test response to your videoask with the custom variable and fill in the contact form.
In our example below, we’ve used source as our custom variable and entered Facebook as the source we want to track.
Log in to your Zapier account and click + Create Zap.
Search for and select VideoAsk from the Zapier app catalog.
Choose what event in VideoAsk will trigger the zap and click Continue.
We’ll select New Response (From a Respondent). This will trigger when a respondent submits a response to our videoask.
Choose which VideoAsk account you would like to connect.
If you haven’t connected your VideoAsk account to Zapier before, you’ll be prompted to log in. After you’ve selected the account, click Continue.
Select which organization and videoask you would like to connect. Then click Continue.
Click Test trigger to ensure your videoask is properly connected.
Select the test response you’ve submitted and scroll down to make sure your custom variable and Product name appear in the response.
Then, click Continue with selected record.
Search for and select Google Sheets from the Zapier app catalog for the Action of this zap.
Select the Event you want from this zap and click Continue.
We’ll select Create Spreadsheet Row.
Select your Google Sheets account and click Continue.
Select which Drive, Spreadsheet, and Worksheet you want to send your videoask data to.
Next, you’ll see the column headers you’ve entered in your Google Sheet as fields you can map to. Map the information you want to pass to each column header from the dropdowns. Click Continue when you’ve finished mapping.
Click Test action.
Head over to your Google Sheet and check if everything is appearing as expected.
When you’re happy with how everything’s working, head back over to Zapier and click Publish.