Use Google Sheets to Find Company URLs from Company Names

Category : General

Problem: I needed to find Company URLs from company names to sync contacts to companies in HubSpot.

Solution:

Use, “https://autocomplete.clearbit.com/v1/companies/suggest?query=” along with the company name to fetch data on the company
Create this function in Google Sheet scripts:
function FETCH(url) {
var response = UrlFetchApp.fetch(url);
Logger.log(response.getContentText());
var out = JSON.parse(response.getContentText());
return out[0][“domain”];
}
Run the function using: fetch(Field of URL)

September 5, 2019July 13, 2023

Dummy Credit Card Numbers

Category : General

https://developers.bluesnap.com/docs/test-credit-cards

August 12, 2019July 13, 2023

How To Fix Defer Parsing of Javascript Warning in WordPress Using Async

Category : Wordpress

You can do defer JS in WordPress and that is by editing your theme’s functions.php file.

Simply copy the code below and paste it at the bottom of your theme’s function.php file:

function defer_parsing_of_js ( $url ) {
if ( FALSE === strpos( $url, '.js' ) ) return $url;
if ( strpos( $url, 'jquery.js' ) ) return $url;
return "$url' defer ";
}
add_filter( 'clean_url', 'defer_parsing_of_js', 11, 1 );

Source of solution – https://www.collectiveray.com/defer-parsing-of-javascript-wordpress-async ( 4. Using functions.php tweaks )

Warning – After adding this code make sure that wordpress admin is working correctly. Trying editing page,posts etc.

August 7, 2019July 13, 2023

HubSpot – Blocking Known Spam From Submitting Website Forms

Category : Hubspot

@gmail and @msn and other freemail addresses could be high-level prospects in disguise. Blocking specific domains rather than blocking all freemail will ensure you’re getting forms from valid contacts.

How to block specific domains from submitting forms:

Go to the email section of the form or pop-up form (Figure 2)
Enter the spam domain name – the @ not needed (gmail.com not @gmail.com)
Publish the form (if a HubSpot page)
Update the form (if it is not a HubSpot page)

The offending spammer will see this notification (Figure 3) and will not be able to submit the form.