Use Google Sheets to Find Company URLs from Company Names

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 …

CallRail – Setting up goals for first time and repeat callers in Google Analytics

Tracking first-time callers: Category Setting: Phone Label Setting: Regular Expression Value: .*Call-01 Tracking additional calls: Category Setting: Phone Label Setting: Regular Expression Value: .*Call-.*[2-5]