AI in Sales Experiments: Practical Tips and Case Studies for Non Technical Folks

1. Simple Tech Stack Finder

A simple Tech Stack Finder using Google Sheets scripts to detect the software used by DTDC companies.

It’s simple; Create two columns in your sheets.

Then, paste the script below into the Google Sheets script editor, save it, and run it.

function analyzeTechStack() {
 var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
 var data = sheet.getDataRange().getValues();
 
 sheet.getRange(1, 2).setValue("Tech Stack");
 
 for (var i = 1; i < data.length; i++) {
 var url = data[i][0];
 if (url) {
 var result = getTechStack(url);
 sheet.getRange(i + 1, 2).setValue(result.techStack);
 }
 }
}
function getTechStack(url) {
 var techStack = [];
 
 try {
 var response = UrlFetchApp.fetch(url, {muteHttpExceptions: true});
 var content = response.getContentText();
 var headers = response.getHeaders();
 
 var technologies = [
 // E-commerce Platforms
 "Shopify", "BigCommerce", "Magento", "WooCommerce", "Salesforce Commerce Cloud", "Volusion", "3dcart", "Ecwid", "LemonStand", "Miva",
 "OpenCart", "osCommerce", "PrestaShop", "Squarespace", "Wix", "X-Cart", "Zen Cart", "nopCommerce", "Demandware", "Oracle Commerce",
 
 // Payment Processors
 "PayPal", "Stripe", "Square", "Authorize.Net", "Braintree", "Adyen", "Klarna", "Affirm", "Amazon Pay", "Apple Pay",
 "Google Pay", "Visa Checkout", "Masterpass", "Alipay", "WeChat Pay", "Skrill", "2Checkout", "Worldpay", "Cybersource", "BlueSnap",
 "Checkout.com", "Dwolla", "Payoneer", "CCAvenue", "Razorpay", "Paytm", "Mollie", "iDEAL", "Giropay", "SOFORT",
 
 // Email Service Providers (ESPs)
 "Mailchimp", "Constant Contact", "SendGrid", "Klaviyo", "Drip", "ConvertKit", "ActiveCampaign", "Campaign Monitor", "AWeber", "GetResponse",
 "Sendinblue", "Omnisend", "Iterable", "Bronto", "dotdigital", "Emma", "iContact", "MailerLite", "Benchmark Email", "Mailjet",
 
 // Analytics and Tracking
 "Google Analytics", "Adobe Analytics", "Mixpanel", "Heap", "Amplitude", "Kissmetrics", "Hotjar", "Crazy Egg", "FullStory", "Optimizely",
 "VWO", "Google Tag Manager", "Segment", "Pendo", "Matomo", "Chartbeat", "comScore", "New Relic", "Datadog", "Lucky Orange",
 
 // Customer Service and Support
 "Zendesk", "Intercom", "Freshdesk", "Helpscout", "Drift", "Olark", "LiveChat", "Tidio", "Tawk.to", "Crisp",
 "Kayako", "Uservoice", "Groove", "Desk.com", "Salesforce Service Cloud", "Gladly", "Kustomer", "Gorgias", "Dixa", "Front",
 
 // Loyalty and Referral Programs
 "Yotpo", "Loyalty Lion", "ReferralCandy", "Smile.io", "Sweet Tooth", "Friendbuy", "Extole", "Influitive", "Annex Cloud", "Zinrelo",
 
 // Reviews and Ratings
 "Trustpilot", "Bazaarvoice", "PowerReviews", "Feefo", "Reevoo", "Yotpo Reviews", "REVIEWS.io", "eKomi", "Shopper Approved", "Judge.me",
 
 // Personalization and Recommendations
 "Dynamic Yield", "Nosto", "Monetate", "RichRelevance", "Certona", "Evergage", "Qubit", "Personyze", "Barilliance", "Attraqt",
 
 // Social Media and Marketing
 "Facebook Pixel", "Twitter Pixel", "LinkedIn Insight Tag", "Pinterest Tag", "Snapchat Pixel", "TikTok Pixel", "Buffer", "Hootsuite", "Sprout Social", "Salesforce Social Studio",
 
 // Retargeting and Advertising
 "AdRoll", "Criteo", "Google Ads Remarketing", "Facebook Retargeting", "Perfect Audience", "SteelHouse", "Rollworks", "Meteora", "Choozle", "Marin Software",
 
 // Shipping and Fulfillment
 "ShipStation", "ShipBob", "Shippo", "EasyPost", "Ordoro", "ShippingEasy", "Shipwire", "Fedex", "UPS", "DHL",
 
 // Inventory Management
 "Stitch Labs", "TradeGecko", "Brightpearl", "Cin7", "Fishbowl", "Finale Inventory", "SkuVault", "Orderhive", "Zoho Inventory", "Unleashed",
 
 // Product Information Management (PIM)
 "Akeneo", "Pimcore", "inRiver", "Salsify", "Plytix", "Syndigo", "Contentserv", "Productsup", "Catsy", "Sales Layer",
 
 // A/B Testing and Optimization
 "Optimizely", "VWO", "AB Tasty", "Google Optimize", "Kameleoon", "Convert", "SiteSpect", "Unbounce", "Omniconvert", "Freshmarketer",
 
 // Chatbots and Conversational Commerce
 "MobileMonkey", "ManyChat", "Chatfuel", "Octane AI", "Landbot", "Botpress", "Dialogflow", "Motion.ai", "Botsify", "Flow XO"
 ];
 technologies.forEach(function(tech) {
 if (content.toLowerCase().includes(tech.toLowerCase())) {
 techStack.push(tech);
 }
 });
 } catch (e) {
 return {
 techStack: "Error: " + e.toString()
 };
 }
 
 return {
 techStack: techStack.join(", ")
 };
}

A few things to keep in mind if you’re building one using Chatgpt/Claude:

✅ Limit the scope: Focus on tech relevant to your industry (e.g., DTC, media tech) to avoid unnecessary complexity. If you’re offering a specific solution, only ask it to include tech tools that integrate with or complement your product.

✅ Accuracy caution: Website tags aren’t always up-to-date, so this method isn’t foolproof. For thorough analysis, consider specialized tools like BuiltWith.

✅ Use for prospecting carefully:  When reaching out, lead with something like “I came across X on your site—are you currently using it?”

2. AI automation to make landing media sponsorships more efficient (pretty easy to replicate even if you can’t code).

If you’re in the game of selling ad space or sponsorships, this one’s for you. I tried out N8n for this, and here’s the breakdown:

1. Automatically search for emails in the inbox that mention sponsorships.

2. Use AI (in this case Groq) to pull key info: Sponsor Name, Sponsored Content, and Newsletter Name.

3. Dump it all into a Google Sheet.

Bonus tip: Use APIs like Clearbit to find the sponsor’s website and decision-maker details.