topic Re: Scrapping website content to inject in email workflow in CMS Development

Scrapping website content to inject in email workflow

Jf2 — Wed, 05 Aug 2020 08:13:20 GMT

Hi all,

Looking to set up the following process (need help with step 3):

User comes to client site and creates a quote
User displays exit intent, HubSpot pop up drives user to receive quote by email
HubSpot to scrape the quote table from the page they are on and inject content into an email via the use of workflows/tokens or any proposed process

Thanks for all thoughts in advance.

Re: Scrapping website content to inject in email workflow

Kevin-C — Wed, 05 Aug 2020 17:00:40 GMT

Hey @Jf2

So this could be rather simple:

On page load capture the table data and store it on the window.

On "exit intent", popup a form with hiden field.

Populate the forms hidden field with the data from the window variable.

Re: Scrapping website content to inject in email workflow

Kevin-C — Wed, 05 Aug 2020 20:39:41 GMT

@Jf2

Following up on my comment:

Checkout @alyssamwilie 's answer to this post. This is the technique you'd want to use to get the info.

Write a function similar to the code below to get the data and add it to the window object:

$(document).ready(function() {
      // Declare your table data variable
      var tableData = [];

      $('#target tr').each(function(index) {
        // Add empty array to the tableData variable
        tableData.push([]);

        // Loop through trs and push values to the array at index
        $(this).find('td').each(function(j, el) {
          tableData[index].push(el.textContent);
        });
      });

      // Add the tableDato the window object for easy access
      window.tableData = tableData;
    });

You'll get a data structure like so:

Then write a function that populates the hidden fields in the popup. Somthing like this maybe:

$('#hidden-field-id').val(window.tableData[1][2]);