Amazon affiliate marketing automation
Who this is for This workflow is for Amazon affiliate marketers and social media managers who want to quickly turn product links into engaging Facebook posts with AI-generated captions and images — fully automated. --- What this workflow does This workflow starts every time a new Product Link is added to a connected Google Sheet. It then: Extracts the ASIN from the product link. Fetches product details from Amazon using RapidAPI. Generates a short, scroll-stopping Facebook caption with OpenRouter AI. Creates a product image prompt and sends it to Google Gemini for high-quality image generation. Uploads the creative directly to Facebook via the Facebook Graph API. Marks the Google Sheet row as “Done ✅” after posting. The Facebook post includes: Product image (AI-enhanced) Short, benefit-focused caption with emojis Affiliate link --- Setup To set this template up, follow the sticky notes inside the workflow and: Google Sheets → Connect your sheet and ensure the columns “Product Link” & “Facebook Upload” exist. RapidAPI → Add your API key in the “Amazon Product Details” node. OpenRouter → Add credentials for caption generation. Google Gemini → Add your API key for image generation. Facebook Graph API → Connect your Facebook account for posting. --- How to customize this workflow to your needs Change the Facebook caption prompt to match your tone or branding. Adjust the AI image generation prompt to fit your preferred photography style. Modify the Google Sheet update logic if you want to track additional info (e.g., posting date, engagement stats). Switch Facebook posting to Instagram or another platform by replacing the final API call.
By Rakin JakariaSend sales forecast charts and answer Q&A on WhatsApp with OpenAI
How It Works Top Branch Workflow The Data Scientist: Ingest: Pulls historical sales data from Google Sheets. Math Engine: Runs 7 statistical algorithms (e.g., Seasonal Naive, Linear Trend, Regression). It backtests them against your history and scientifically selects the winner with the lowest error rate. The Data Analyst: Interpret: The AI Agent takes the mathematical output and translates it into business insights, assigning confidence scores based on error margins. Report: Generates a visual trend chart (PNG) and sends a complete briefing to your phone. Bottom Branch Workflow The Consultant: AI Agent 2 handles the follow-up questions. It pulls the latest analysis context and checks historical rate data to give an informed answer. Recall: When you ask a question via WhatsApp, the bot retrieves the saved forecast state. Answer: It acts as an on-demand analyst, comparing current forecasts against historical actuals to give you instant answers. Setup Steps 1) Google Sheet: Prepare columns: Year, Month, Sales. Map the Sheet ID in the "Workflow Configuration" node. 2) Forecast Engine: No config needed. It automatically detects seasonality vs. linear trends. 3) Database: Create a table latest_forecast to store the JSON output. 4) Credentials: Connect Google Sheets, OpenAI, and WhatsApp Use Cases & Benefits For Business Owners: Gain enterprise-grade forecasting on autopilot. Always have a sophisticated financial outlook running in the background 24/7. For Sales Leaders: Get immediate visibility into future revenue trends. Bypass the wait for end-of-month manual reports and get a strategic "pulse check" delivered instantly to your phone. 🤖Virtual Data Team: Instantly add the capabilities of a Data Scientist and Data Analyst to your business or division. It works alongside your existing team to handle the heavy lifting, or stands in as your dedicated automated department. 🧠Precision & Trust: Combines the best of both worlds: rigorous, deterministic code for the math (no hallucinations) and advanced AI for the strategic explanation. You get numbers you can trust with context you can use. ⚡Decision-Ready Insights: Stop digging through dashboards. High-level intelligence is pushed directly to you on WhatsApp, allowing you to make faster, data-driven decisions from anywhere. 📬 Want to Customize This? leelin.business@gmail.com
By Lee LinExporting Tawk.to help center articles to Google Drive as markdown files
🧠 Export Tawk.to Help Center Articles to Google Drive as Markdown Files Transform the way you manage your knowledge base with this fully automated N8N workflow! This automation connects directly to your Tawk.to Help Center, reads all published categories and articles, converts them to Markdown (.md) format, and uploads each file to Google Drive --- 🔹 Key Benefits 🚀 Complete Extraction Automatically captures all categories and articles from your Tawk.to Help Center, even without direct API integration. 🧩 Automatic Conversion Transforms HTML content into clean Markdown files — perfect for editing, version control, or migration to another CMS. ☁️ Native Google Drive Integration Saves each article with a structured filename, avoids duplicates, and organizes them by category. 🔁 Fully Customizable Easily adapt the workflow to export to Notion, GitHub, Dropbox, or any other platform supported by N8N. 💡 Ideal Use Cases Migrating your Tawk.to Help Center Creating automated content backups Integrating documentation across multiple systems --- ⚙️ Prerequisites Before running this workflow, make sure you have: An active Tawk.to account with access to your Help Center. A Google Drive account (personal or workspace). Access to N8N (self-hosted or cloud). --- 🧰 Setup Instructions Import the Workflow Download the JSON file from the provided link or your N8N community instance. In N8N, click Import Workflow and upload the file. Authenticate Google Drive Open the Google Drive node. Click Connect, choose your Google account, and allow access. Configure Output Folder Choose or create a target folder in your Google Drive where articles will be saved. Run the Workflow Click Execute Workflow. The automation will read all Help Center articles, convert them to Markdown, and save them to your Drive.
By Pedro Entringer