Grow Your Business with
Proven Step-by-Step Playbooks

// Email Drip Campaign — reads from Google Sheet, sends 3-email sequence function runDripCampaign() { const sheet = SpreadsheetApp.openById('YOUR_SHEET_ID').getActiveSheet(); const data = sheet.getDataRange().getValues(); const today = new Date(); for (let i = 1; i < data.length; i++) { const [name, email, company, status, dateAdded, e1, e2, e3] = data[i]; if (status === 'active' && email) { const daysSince = (today - new Date(dateAdded)) / 86400000; if (!e1) { // Day 0 — send email 1 sendEmail(email, name, company, 1); sheet.getRange(i+1, 6).setValue('sent'); } else if (!e2 && daysSince >= 3) { // Day 3 — send email 2 sendEmail(email, name, company, 2); sheet.getRange(i+1, 7).setValue('sent'); } else if (!e3 && daysSince >= 7) { // Day 7 — send email 3 sendEmail(email, name, company, 3); sheet.getRange(i+1, 8).setValue('sent'); } } } } function sendEmail(to, name, company, emailNum) { const templates = { 1: { subject: `Connecting from EximHub — Trade Opportunity for ${company}`, body: `Hi ${name},\n\nI wanted to introduce EximHub...` }, 2: { subject: `Following up — ${company} Trade Partnership`, body: `Hi ${name},\n\nJust checking if you had a chance...` }, 3: { subject: `Last note — Verified Buyer Data for ${company}`, body: `Hi ${name},\n\nOne last reach out...` } }; const t = templates[emailNum]; GmailApp.sendEmail(to, t.subject, t.body, { name: 'EximHub Team' }); }

// Run from Google Sheets — generates quote PDF and emails it function generateAndSendQuote() { const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const row = sheet.getActiveRange().getRow(); const [name, email, company, product, qty, unitPrice] = sheet.getRange(row, 1, 1, 6).getValues()[0]; const total = qty * unitPrice; const doc = DocumentApp.openById('YOUR_QUOTE_TEMPLATE_DOC_ID'); const body = doc.getBody(); // Replace placeholders in template body.replaceText('{{NAME}}', name); body.replaceText('{{COMPANY}}', company); body.replaceText('{{PRODUCT}}', product); body.replaceText('{{QTY}}', qty); body.replaceText('{{TOTAL}}', `₹${total.toLocaleString('en-IN')}`); const pdf = DriveApp.getFileById(doc.getId()).getAs('application/pdf'); GmailApp.sendEmail(email, `Quote for ${product} — EximHub`, `Hi ${name}, please find your quote attached.`, { attachments: [pdf], name: 'EximHub Sales' } ); sheet.getRange(row, 7).setValue('Quote Sent ✓'); }