Automations Cookbook API

import pandas as pd
import requests

# Method 1: Direct CSV access
df = pd.read_csv('https://www.automationscookbook.com/automacoes_db.csv')

# Search by software
crm_templates = df[
    (df['software_a'].str.contains('HubSpot', case=False)) | 
    (df['software_b'].str.contains('HubSpot', case=False))
]

# Search by use case
marketing_templates = df[df['tags'].str.contains('marketing', case=False)]

# Get specific template info
def get_template_by_software(software_a, software_b):
    results = df[
        (df['software_a'].str.contains(software_a, case=False)) &
        (df['software_b'].str.contains(software_b, case=False))
    ]
    return results[['titulo_pagina', 'descricao_curta', 'slug_url']].to_dict('records')

# Example usage
templates = get_template_by_software('Shopify', 'Google Sheets')
for t in templates:
    print(f"Title: {t['titulo_pagina']}")
    print(f"URL: https://www.automationscookbook.com/integracoes/{t['slug_url']}.html")
    print()

const axios = require('axios');
const Papa = require('papaparse');

// Fetch CSV database
async function fetchTemplates() {
  const response = await axios.get(
    'https://www.automationscookbook.com/automacoes_db.csv'
  );
  
  const parsed = Papa.parse(response.data, { 
    header: true,
    skipEmptyLines: true 
  });
  
  return parsed.data;
}

// Search function
async function searchTemplates(query) {
  const templates = await fetchTemplates();
  
  return templates.filter(t => {
    const searchText = `${t.software_a} ${t.software_b} ${t.tags} ${t.caso_uso_resumido}`.toLowerCase();
    return searchText.includes(query.toLowerCase());
  });
}

// Example: Find WhatsApp + CRM integrations
searchTemplates('whatsapp crm').then(results => {
  console.log(`Found ${results.length} templates`);
  results.slice(0, 5).forEach(t => {
    console.log(`- ${t.software_a} → ${t.software_b}`);
    console.log(`  ${t.descricao_curta}`);
  });
});