BrightTALK POST Connector for Google Forms and Sheets - Getting Started

BrightTALK can automatically pass leads to Google Forms and Sheets using the POST Connector.  Please follow the below steps in order to get set up:

Creating a Form

Connecting to BrightTALK

Mapping your Fields

Adding Custom Value Fields (optional)

Determining a Sync Schedule

Troubleshooting: Google Form POST

Creating a Form

To set up the integration you'll first need to create a Google Form with the fields that you want BrightTALK to send. In addition to including basic contact fields (email, first name, etc.), we also recommend adding the following fields to your form:

 Note: Since this form will not be publicly facing (i.e. the lead will not see it), the design can be kept fairly basic (Just the fields and a submit button is sufficient).  

Once you've created your form, at the top of the screen look for the Form ID and copy it down:

Once you have that, we'll need to find the id codes for each of your fields.   This can be done by clicking "preview" on the form (eye icon), then right-clicking one of the fields in the form and selecting "Inspect."  Then follow these easy steps:

1) In the Inspect window click "Console" (upper right tab)

2) Copy and paste this code into the console and hit "enter":

function loop(e){
if(e.children)
for(let i=0;i<e.children.length;i++){ 
let c = e.children[i], n = c.getAttribute('name'), o = document.querySelectorAll(`[id^="i"]`), d = []
for(var j=0;j<o.length;j++){
if(document.querySelectorAll(`[id^="i"]`)[j].getAttribute("aria-level") == 3){
d.push(o[j].innerText)
}
}
if(n && n.indexOf('entry') != -1) console.log(`${d[i]}: ${n}`); 
loop(e.children[i]);
}
}; loop(document.body);

This will output the id codes for each field (in the format "entry.[number]).  Copy those down as you'll need them in the field mapping section.

Note: If you're stuck here, here is a quick gif of me going through this process:

  

Connecting to BrightTALK
Now that you have the Form ID and Field Ids, return to BrightTALK to finish the setup.  From the Connectors page of your Demand Central account,  click "Connect" on the Channel you wish to use and select "Connect" under the box labelled "POST Connector."  Then enter your credentials as shown below and click "Continue Setup":

-POST URL: https://docs.google.com/forms/d/[Form ID goes here]/formResponse

-"Part of the URL"

-Sync All Leads*

*Note: Instead of syncing all leads, you can also "Sync Paid Leads" only- when selected, this Connector will only pass leads from your paid lead Campaigns (excluding all Organic and Direct traffic).

Mapping Your Fields

Once you've established a Connection, you can begin identifying the fields you need BrightTALK to update.  Select the BrightTALK field you need on the left, and enter the Id of your Google Form field on the right (using the format "entry.[field ID]"):

Adding Custom Value Fields (optional)

Custom Value Fields are hard-coded fields that you can include in your sync.  For instance, if you have a field called "Lead Source" and you need every lead BrightTALK sends to include that field with the custom value "BrightTALK," you can set that up like this:

Determining a Sync Schedule

Once you've saved your field mappings, you will see an option to select a preferred sync schedule (either hourly, daily, or weekly).  Select one of these options, determine how far back you'd like to sync data and click "Activate Sync."  

Once that's activated, data will begin syncing to your Google Form based on your preferred schedule.  If you'd like to data to go into a Google Sheet, simply connect that Sheet to your Form.  

Additional Notes

-If you haven't already, you'll need to disable the setting on your Google Form that requires users to Sign-in.  

-Google Forms do not automatically de-dupe- so if a lead registers, attends, and attends on-demand, it will create three records.